This course covers data import/export, advanced table properties, advanced queries and basic SQL,
designing forms and reports from scratch, macros to automate database tasks, and creating a menu-driven application.
On successful completion you will be able to apply these new skills:
- Manage data and object import/export features in MS Access.
- Create sophisticated tables using customized formats, input masks, and validation rules.
- Design and create advanced queries (advanced Select, Crosstab, Action, SQL, and SQL Subquery).
- Create forms and reports using all types of controls including ActiveX controls.
- Build macros for data validation and database automation.
- Create a menu-driven application containing all objects into a mini application.
Prerequisites: Successful completion of Beginning Microsoft Access, or basic skills in database and table design,
queries (Select, Total, Parameter queries), forms and reports and simple functions (IIF, Left, Right, InStr, Mid).
Class Syllabus
In-class Practice Problems
Homework Assignments
Database Solution Files
Download Class Database Files: Access 2000 Access 97