Lessons
|
Lesson 1
|
Getting Started with Access 2010
Identify Elements of the User Interface Work with the Ribbon Obtain Help
|
Lesson 2
|
Planning a Database
Introduce Database Concepts Understand the Relational Database Design Process
|
Lesson 3
|
Organize Data in Tables
Create a Table Modify Tables Create a Table Relationship Update a Table
|
Lesson 4
|
Viewing Data in Tables
Sort Records Filter Records View Data from Related Tables
|
Lesson 5
|
Querying a Database
Create a Query Add Criteria to a Query Add a Calculated Field to a Query Perform Calculations on a Record Grouping
|
Lesson 6
|
Designing Forms
View Data using a Form Create a Form Modify a Form
|
Lesson 7
|
Generating Reports
View an Access Report Create a Report Add a Calculated Field to a Report Format the Controls in a Report Apply a Theme to a Report Prepare a Report for Print
|