Introduction to Microsoft Access
*For students with no or limited use of Access
Course Outline
Exploring Access
Database concepts
The Ribbon
Define the Database Purpose
Describe the Relational Database Design Process
Describe the Objects in the Database
Designing a Database
Determine Fields
Determine Field Data Type
Determine Field Length
Group Fields into Records
Populate Records into Tables
Designate Primary and Foreign Keys
Determine Table Relationships
Building a Database
Create a New Database
Create a Table in Design View
Develop the Table Architecture (blueprint)
Populate the Table with Data
Create a Second Table
Create a Table Relationship
Establish Referential Integrity
Managing Data in a Table
Modify table data, add, delete, edit
Sort Records
Filter Records
Work with Subdatasheets
Querying a Database
Create a Query from Design View
Add Criteria
Run Wildcard, Text and Comparison Operator queries
Add a Calculated Field to a Query
Group Data with Calculations
Designing Forms
Create a Form
View Data Using an Access Form
Generating Reports
Create a Report
Sort Reports
View Report |
|