MS Access - Level 3, CMP963
Build on the skills acquired in MS Access II. Learn how to query with SQL; create crosstab, parameters, and action queries, create macros, import, export, and link database objects. Work with XML documents and use hyperlink fields. Learn database management by optimizing resources and protecting databases. This course follows curriculum for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, you should complete MS Access Level I, II, and III.
Prerequisites: Prerequisite: MS Access--Level I & II or equivalent experience.
Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook, bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
Classroom Hours: 10
-
Table Of Contents:
Unit 1: Querying with SQL
Topic A: SQL and Access
Topic B: Writing SQL statements
Topic C: Attaching SQL queries to controls
Unit 2: Advanced queries
Topic A: Creating crosstab queries
Topic B: Creating parameter queries
Topic C: Using action queries
Unit 3: Macros
Topic A: Creating, running, and modifying macros
Topic B: Attaching macros to the events of database objects
Unit 4: Advanced macros
Topic A: Creating macros to provide user interaction
Topic B: Creating macros that require user input
Topic C: Creating AutoKeys and AutoExec macros
Topic D: Creating macros for data transfer
Unit 5: Importing, exporting, and linking objects
Topic A: Importing objects
Topic B: Exporting objects
Topic C: Working with XML documents
Topic D: Linking Access objects
Topic E: Using hyperlink fields
Unit 6: Database management
Topic A: Optimizing resources
Topic B: Protecting databases
Topic C: Setting options and properties