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