Beginning MS Access Class Syllabus

Beginning MS Access
Class Syllabus

[Home] --> [Beginning MS Access Home] -->[You are here: Beginning MS Access Class Syllabus]

1. Class, 8:30am - 11:30am 2. Class, 12:30pm - 3:30pm

What is a Database?
Why use a Relational Database?
Data Normalization(Determining tables, Determining Fields, Determining Relationships)
Integrity Rules (Primary/Foreign Key, One-to-Many, Many-to-Many, One-to-One)
Introduction to MS Access (Objects, Navigation) Create a Table in MS Access
Data Types, Field Properties
Data Formats and Input Masks
Data Entry
Setting up Relationships, Referential Integrity

3. Class, 8:30am - 11:30am 4. Class, 12:30pm - 3:30pm

Introduction to Queries
Types of Queries (Select, Total, Action, Crosstab, SQL)
Creating Select Queries in MS Access
Query By Example Interface (QBE)
Entering Expressions as Criteria
Using Wildcard Characters in Expressions Advanced Select Queries: Complex Criteria, Multi-table Queries, And/Or Operators, Creating Calculated Fields
Total Queries: Total Row Options
Group By, Record Limit, Expression, Aggregate Functions
Parameter Queries: Single/Multiple Parameters
Parameters and Wildcard Characters

5. Class, 8:30am - 11:30am 6. Class, 12:30pm - 3:30pm

Introduction to Forms
Types of Basic Forms: Columnar, Tabular, Datasheet, Main/Subforms, Graphs
Creating Forms using Forms Wizard
Making Simple Design Changes
Filter Records in Forms Introduction to Reports
Types of Basic Reports: Single Column, Groups/Total, Mailing Labels, Summary, Tabular Report
Creating Reports using Reports Wizard
Steps of Creating Reports: Layout, Data Model (Query), Report Generation
Grouping Levels in Reports

7. Class, 8:30am - 11:30am 8. Class, 12:30pm - 3:30pm

Advanced Forms and Reports(Charts)
MS Access Built-In Functions
Creating Switchboard Menus Lab Exercise
Design a relational database for student enrollments
Create Tables
Create Forms and Reports
Enter some data through forms (enrollments)
Create Switchboard Menu

1. Class, 8:30am - 11:30am	2. Class, 12:30pm - 3:30pm
What is a Database? Why use a Relational Database? Data Normalization(Determining tables, Determining Fields, Determining Relationships) Integrity Rules (Primary/Foreign Key, One-to-Many, Many-to-Many, One-to-One) Introduction to MS Access (Objects, Navigation)	Create a Table in MS Access Data Types, Field Properties Data Formats and Input Masks Data Entry Setting up Relationships, Referential Integrity
3. Class, 8:30am - 11:30am	4. Class, 12:30pm - 3:30pm
Introduction to Queries Types of Queries (Select, Total, Action, Crosstab, SQL) Creating Select Queries in MS Access Query By Example Interface (QBE) Entering Expressions as Criteria Using Wildcard Characters in Expressions	Advanced Select Queries: Complex Criteria, Multi-table Queries, And/Or Operators, Creating Calculated Fields Total Queries: Total Row Options Group By, Record Limit, Expression, Aggregate Functions Parameter Queries: Single/Multiple Parameters Parameters and Wildcard Characters
5. Class, 8:30am - 11:30am	6. Class, 12:30pm - 3:30pm
Introduction to Forms Types of Basic Forms: Columnar, Tabular, Datasheet, Main/Subforms, Graphs Creating Forms using Forms Wizard Making Simple Design Changes Filter Records in Forms	Introduction to Reports Types of Basic Reports: Single Column, Groups/Total, Mailing Labels, Summary, Tabular Report Creating Reports using Reports Wizard Steps of Creating Reports: Layout, Data Model (Query), Report Generation Grouping Levels in Reports
7. Class, 8:30am - 11:30am	8. Class, 12:30pm - 3:30pm
Advanced Forms and Reports(Charts) MS Access Built-In Functions Creating Switchboard Menus	Lab Exercise Design a relational database for student enrollments Create Tables Create Forms and Reports Enter some data through forms (enrollments) Create Switchboard Menu