|
| Course Name |
| Access 2010 Essentials (Levels 1-2-3) |
Contact Hours: 24 |
|
| Course Description |
Not too long ago, databases were on mainframes and only skilled personnel were allowed to work with them. For most, that meant a lot of frustration both trying to communicate what was needed and then waiting to actually get it. Today, databases have come to the desktop so anyone with basic computing skills can organize, manage and retrieve their data. Doing so well and efficiently does require a basic understanding of what a relational database is and how to properly design and use one. In this series, we will investigate those essentials skills for Microsoft Access 2010. We will build a database from the ground up! You will learn the basics of design and then get right to work making tables, queries, forms and reports. When your done, you will not only be able to enter data and open reports in Access you will be able to design and structure it so it meets the needs of both you and your data, right from your desktop!
This training includes the program-specific features that are mapped to the Microsoft Office Specialist (MOS) certification exam for the corresponding product.
MOS certification validates proficiency for individuals who PASS the certification exam, and shows that they can meet globally recognized performance standards.
Bonus---1 Year Post Course Completion Access to Course. |
|
| Outcome |
The learner will be prepared to:
1. Learn database planning & design
2. Create quality tables
3. Discover and harness the power of queries
4. Create functional forms & reports
|
|
| Assessment |
This course allows for self-directed work and does not require that you take a test. Apply what you have learned to your own projects.
|
|
| Outline |
Chapter 1: GETTING TO KNOW ACCESS 2010
1. Relational Database Overview
2. Access Components
3. Planning a Database
4. Creating Our Database Plan
5. Naming Conventions
6. Creating a Database File
Chapter 2: CREATING ACCESS TABLES
1. Leveraging Application Parts
2. Building a Table in Design View & Data Types Explained
3. Applying Field Properties
4. Relationship Concepts
5. Establishing Relationships
6. Creating Lookup Fields
7. Entering Table Records
8. Using the Ribbon to Edit Records
9. Managing Subdatasheets
Chapter 3: HARNESSING THE POWER OF QUERIES
1. Creating a Basic Query
2. Filtering with Criteria
3. Working with Expressions
4. Working with Totals
5. Concatenating Text
6. Changing Joins in Queries
7. Creating a Price List Query
8. Creating a Class Schedule Query Using Expression Builder
9. Creating Action Queries
10. Creating Special Select Queries with Wizards
Chapter 4: CREATING FUNCTIONAL FORMS & REPORTS
1. Creating Forms Automatically & with the Forms Wizard
2. Creating Reports with the Report Wizard
3. The Design of Forms & Reports
4. Working with Data in Forms
5. Filtering & Sorting Records in Forms
6. Customizing Report Controls & Page Setup
7. Credits
|
|
|
|