Intermediate MS Access Class Syllabus

Intermediate MS Access
Class Syllabus

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

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

Relational Database Theory and Importing, Linking, Exporting
Overview of Relational Database Theory
Introduction to Application Development.
Importing, Exporting, and Linking Data.
Customer Formats, Advanced Select Queries
User-Defined Data Formats (Input Mask, Format)
Introduction to Class Databases.
Review of Select, Paramter, and Total Queries.
Advanced Select Queries.
Crosstab Queries.

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

Join Properties,SQL,Action Queries, and Subqueries
Multiple Table Queries (Join Types)
SQL Queries.
Action Queries.
SQL Subqueries Creating Forms, Part I
Overview of the Form Design Interface.
Form Controls.
The Text Box Control.
List/Combo Box Controls.

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

Creating Forms, Part II, Overview of Reports
Option and Checkboxes
Image Controls
Command Buttons
AciveX Controls
Sub Form Controls
Overview of Reports, Report Properties. Creating Reports and Introduction to Macros
Building Reports from Scratch.
Using Report Tools and Report Controls.
Sorting and Grouping.
Using Expressions in Reports.
Overview of Macros.
Macro Names and Macro Conditions.

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

Macros for Forms and Reports
Using Macros to Change Form Properties.
Using Macros to Implement Form Navigation.
Using Macros to Validate Data.
Using Macros to Change Report Properties. Creating an Application
Class Project: Building a Sample Application.
MS Access Startup Options.
MS Access Switchboard.
MS Office Menubar and Toolbars.
Database Maintenance: Repairing, Compacting, and Backups.

1. Class, 8:30am - 11:30am	2. Class, 12:30pm - 3:30pm
Relational Database Theory and Importing, Linking, Exporting Overview of Relational Database Theory Introduction to Application Development. Importing, Exporting, and Linking Data.	Customer Formats, Advanced Select Queries User-Defined Data Formats (Input Mask, Format) Introduction to Class Databases. Review of Select, Paramter, and Total Queries. Advanced Select Queries. Crosstab Queries.
3. Class, 8:30am - 11:30am	4. Class, 12:30pm - 3:30pm
Join Properties,SQL,Action Queries, and Subqueries Multiple Table Queries (Join Types) SQL Queries. Action Queries. SQL Subqueries	Creating Forms, Part I Overview of the Form Design Interface. Form Controls. The Text Box Control. List/Combo Box Controls.
5. Class, 8:30am - 11:30am	6. Class, 12:30pm - 3:30pm
Creating Forms, Part II, Overview of Reports Option and Checkboxes Image Controls Command Buttons AciveX Controls Sub Form Controls Overview of Reports, Report Properties.	Creating Reports and Introduction to Macros Building Reports from Scratch. Using Report Tools and Report Controls. Sorting and Grouping. Using Expressions in Reports. Overview of Macros. Macro Names and Macro Conditions.
7. Class, 8:30am - 11:30am	8. Class, 12:30pm - 3:30pm
Macros for Forms and Reports Using Macros to Change Form Properties. Using Macros to Implement Form Navigation. Using Macros to Validate Data. Using Macros to Change Report Properties.	Creating an Application Class Project: Building a Sample Application. MS Access Startup Options. MS Access Switchboard. MS Office Menubar and Toolbars. Database Maintenance: Repairing, Compacting, and Backups.