Online Class: Microsoft Access 2010
|
 | | |
| | Course Cost: 6 Month Subscription Course (no Certificate) = $50.00 Course with CEU Certificate* = $75.00 | * Instantly download, print, and share your CEU Certificate at course completion (additional shipping/handling charges apply for hard copy delivery).
UniversalClass™ offers many wonderful learning tools including an online portfolio service that manages all your course completions and CEUs.
 Course Description Microsoft Access 2010 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data. It can be the back-end of a business, keeping your records for you. It is this course's purpose to teach you the important features of Access 2010 and how to use them. This course was designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it. Once we cover the basics, we'll move on to advanced features. If you've used Access before, perhaps prior versions, the first few lessons will be a refresher and introduce you to some of the updates you'll encounter in the newest version of Microsoft Access. You'll learn: · All about databases and how they work · An understanding of how Access works to make even its complex inner workings seem simple · How to navigate Access · How to create tables, forms, reports, and queries · How to enter criteria into your data · How to form expressions and create functions · How to customize the appearance of forms and reports · How to use Access for home-record keeping or for a business And much, much more If you're not familiar with Access 2010, it can be overwhelming. The program is large and navigating it without any help or experience can seem impossible. This course takes its time and shows you around Access. We'll break everything down into small chunks so that Access 2010 is just as easy for the beginner to use as it is someone who's been using it for years. And if you've used Access before, don't worry. We have plenty of updates to show you – and a few more things to teach you as well. Course Lessons |  | Lesson 1: Microsoft Access 2010 IntroductionMicrosoft Access is an information management tool that allows you to store, report, and analyze information. | Lesson 2: Access 2010 Requirements and SetupThis lesson discusses the limits and requirements for running and operating MS Access 2010. | Lesson 3: About Databases and NormalizationCreating a database in Access is very easy to do. However, creating a good relational database that performs well isn't so easy. | Lesson 4: Access 2010 Database ObjectsA database contains objects that are used to store and display large, relational data. | Lesson 5: Navigating MS Access 2010Now that we've covered the basics of a database and learned some important definitions, we're going to start learning MS Access 2010. | Lesson 6: Creating a Database and Adding TablesTo add data, we must first create tables. | Lesson 7: Object ViewsObject views are simply different ways of viewing the object that you're working on. | Lesson 8: Creating Simple FormsA form is an Access database object that's used to create an interface for a database application. | Lesson 9: Introduction to Controls and Formatting FormsControls simply let you view and work with the data that you have in your database. | Lesson 10: QueriesIf you want to review, add, or change data in your database, you can use a query. | Lesson 11: Using Criteria, Operators, and WildcardsQuery criteria are expressions that Access will compare to the values in your query fields to decide whether or not to include the records that contain values. | Lesson 12: Parameter QueriesWhenever you want a query to ask for input each time you run the query, you create what's called a parameter query in Access 2010. | Lesson 13: Relationships and JoinsWhen you define a relationship in Access, you relate data from one table to another. | Lesson 14: Creating Calculated ExpressionsExpressions in Access 2010 are used to do mathematical calculations, combine or extract text, or validate the data in your database. | Lesson 15: Summarizing DataAn aggregate query lets you determine statistics for a set of values. | Lesson 16: PivotTablesIn this lesson, you're going to learn how to create and customize the PivotTable view. | Lesson 17: PivotChartsInstead of rows and columns like with PivotTable view, PivotChart view shows series and category areas. | Lesson 18: ReportsAccess 2010 gives you the ability to run reports to view your data. | Lesson 19: Designing Your ReportOnce you have your report created, you can now modify it to create a more attractive design for it. | Lesson 20: Advanced Formatting for ReportsTo group and sort data in your reports, switch to Design view and go to the Design tab. | Lesson 21: MacrosA macro is essentially a shortcut; a way to automate regularly used tasks or routines. | Lesson 22: Printing and Exporting ReportsThere are many new ways to print and export reports in Access 2010. In this lesson, we'll introduce you to them, and show you how to do them. | Lesson 23: Importing and Exporting DataIn this lesson, we're going to learn the multiple ways that you can import and export data to/from Access. |
Additional Information | Course Title | : | Microsoft Access 2010 | | CEU Value | : | | | Standard | : | Course Adheres to the ANSI/IACET 1-2007 Standard | | Accreditation | : | | | Languages | : | English - United States, Canada, United Kingdom, Australia, New Zealand, and other English speaking countries | | Course Number | : | 8900072 | | Course Type | : | Computer Skill | | Course URL | : | | | Course Rating | : |  | | Instructor | : | | | Syllabus | : | | | Grading Policy | : | Earn a final grade of 70% or higher to receive a CEU Certificate documenting CEUs earned | | Assessment Method | : | Lesson assignments and review exams | | Duration | : | Continuous: Enroll anytime! | | Requirements | : | View Technical Requirements | | Course Fee | : | Basic Course: $50.00 (no CEU Certificate) | | | | | NOT FOR COLLEGE CREDIT This is a non-credit course, and is provided for your personal enrichment.
This course is not intended to be a substitute for any state, government, licensing, certification or educational requirements.
Choose from 5 Secured Payment Methods |  | Credit Card Online | | Credit Card through FAX | | Check/Money Order through Mail | | Credit Card over the Phone | | PayPal | | | | To use any of these methods you must press the "Join this Course" button on this screen and go through the online registration process in order to generate the correct order form and correctly process your enrollment. All financial information is secured and encrypted using Verisign-approved SSL during transmission. |
Other Related Classes in Computer Training - MS Office 2007: Word, Excel, PowerPoint and Outlook MS Office 2007 will provide a comprehensive tutorial of these programs- Word, Excel, PowerPoint, and Outlook. MS Word 2007 It doesn't matter if you're new to MS Word or an experienced user, this comprehensive course teaches the most basic features as w...
- Quickbooks 101 QuickBooks 101 is a course geared for the small business and the small business owner. It contains the features that you loved in Quicken, then goes a step further to give small businesses the accounting software they need to take their numbers from an e...
- Adobe Photoshop 101 Adobe Photoshop is a complex graphics and image editing software and paint program. Chances are, you've heard of Photoshop frequently in the past even if this will be the very first time that you use the program. Adobe's Photoshop program has become a ...
- Excel 2010 Most computer-savvy people out there today know that MS Excel 2010 is a spreadsheet program that you can use to record data, create charts, and utilize mathematical equations. However, most people who are familiar with Excel aren't fully aware of all t...
- Office 2010: Word, Excel, PowerPoint and Outlook @import url(https://tools.universalclass.com/editor_uc/CuteEditor_Files/Style/SyntaxHighlighter.css); @import url(/graphics_uc/css/default04.css); This all-in-one training course provides comprehensive instruction on four popular MS Office programs: MS W...
- Photoshop Elements 101 The Photoshop Elements software package is a condensed version of the popular Adobe Photoshop. As the lesser priced version of Adobe's Photoshop, Elements offers all the same features, but just with less options. However, don't let that scare you away fr...
- Microsoft Project 2007 Microsoft Project 2007 is a project management software that helps project managers better structure, organize, and plan for all their projects. This includes budgets, tasks, resources, assignments, and everything in between. It can create critical pat...
- MS Publisher 2010 Microsoft Publisher 2010 is a desktop publishing software program that comes with the Microsoft Office suite. While Microsoft Word is a word processing program, Microsoft Publisher is used for page layout and design. You can use Publisher to create brochu...
- Word 2010 Microsoft Word 2010 is the newest update to their popular word processing software. Looking a lot like their 2007 version, Word 2010 continues utilizing the ribbon to make accessing features and toolbars a lot quicker and easier than before. When you fac...
- Outlook 2010 Outlook 2010 is a personal information software program that's available with the Microsoft Office Suite. Although it's mostly used as an email client, it can also be used for managing tasks, keeping your calendar, managing contacts, taking notes, journa...
- Adobe Flash 101 Adobe Flash CS4 can be a complex program to use and understand, even if you already have basic knowledge. It's very easy to get lost in the interface and confused by the many features it offers. This course was designed to solve the mysteries of Adob...
| | | |
| |
| |
