Microsoft Access 2010

Course Content

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

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

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

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