Microsoft Access Level 2
 
 
Course Number:           Duration: 24 hours
 
Objectives
This course will introduce existing Microsoft Access (Latest Version) users to administrative functions of the application, along with the techniques required to create a fully-functioning, automated RDBMS. By the end of the course you will have confidence in your ability to design and build robust databases that provide a consistent and clear interface to your users.
Target Audience This course will benefit existing users of Microsoft Access who want to customize databases using macros and gain knowledge of the more advanced tools.
Topics Exporting and Analyzing Access Data, Action Queries, Database Management Tools, Multi-User Databases, Using Macros in a Database Application, Designing an Access Application, Database Design, Importing and Linking Data, Referential Integrity, Business Rules, Advanced Query Design, Advanced Form Design, Advanced Report Design, Data Access Pages.
Prerequisites Completion of Microsoft Access Level 1 or equivalent knowledge.