Microsoft Office Access Level 1
Course Description
| Lesson 1: Getting Started with Access 2010 |
| Identify the Elements of the Access 2010 Interface Identify the Components of a Database Examine the Relational Database Design Process |
| Lesson 2: Building The Structure of a Database |
| New Database Create a Table Manage Tables Establish Table Relationships |
| Lesson 3: Managing Data in a Table |
| Modify Table Data Sort and Filter Records Work with Subdatasheets |
| Lesson 4: 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 5: Designing Forms |
| Create a Form Modify the Design of a Form View and Add Data Using an Access Form |
| Lesson 6: Generating Reports |
| Create a Report Add a Control to a Report Format the Controls in a Report Enhance the Appearance of a Report Prepare a Report for Print |
| Lesson 7: Controlling Data Entry |
| Constrain Data Entry Using Field Properties Establish Data Entry Formats for Entering Field Values Create a List of Values for a Field |
| Lesson 8: Joining Tables |
| Create Query Joins Join Tables That Have No Common Fields Relate Data Within a Table |
| Lesson 9: Creating Flexible Queries |
| Set the Select Query Properties Retrieve Records Based on Input Criteria Create Action Queries |
| Lesson 10: Improving Forms |
| Restrict Data Entry in Forms Organize Information with Tab Pages Add a Command Button to a Form Create a Subform Display a Summary of Data in a Form Change the Display of Data Conditionally |
| Lesson 11: Customizing Reports |
| Organize Report Information Format Reports Control Report Pagination Add a Calculated Field to a Report Add a Subreport to an Existing Report Create a Mailing Label Report |
| Lesson 12: Sharing Data Across Applications |
| Import Data into Access Export Data to Text File Formats Export Access Data to Excel Create a Mail Merge |