MICROSOFT ACCESS ADVANCED

PROGRAM DETAILS
Program Code: IT
School: MacMillian Institute of Applied Health Sciences
Credential: Ontario College Certificate
Program Type:
Program Length:
Location: College Campus/Online
DURATION:14 WEEKS 45HRS
COST:$ 1500

OVERVEIW:
This course is a continuation from the Microsoft Access course which includes Basic and Intermediate training of the software.
Advanced: Students will learn how to query with SQL, create crosstab, parameter and action queries, create macros, import, export and link database objects, work with XML documents, work with Windows SharePoint Services, optimize databases, set Access options and properties, create hyperlink fields and use Outlook to update data.

PRE-REQUISITES: Microsoft Access Basic and Intermediate
COURSE OUTLINE
ADVANCED
Unit 1: Querying with SQL
SQL and Access
Writing SQL Statements and Attaching SQL Queries to Controls
Unit 2: Advanced Queries
Creating Crosstab Queries
Creating Parameter Queries and Using Action Queries
Unit 3: Macros
Creating, Running and Modifying Macros
Attaching Macros to the events of Database Objects
Unit 4: Advanced Macros
Creating Macros to provide user interaction
Creating Macros that require User Input
Creating the Auto Keys and Auto Exec Macros
Creating Macros for Data Transfer
Unit 5: Importing, Exporting and Linking
Importing and Exporting Objects
Interacting with XML Documents
Linking Access Objects
Using hyperlink fields
Unit 6: Database Management
Optimizing Resources, Protecting Databases and Setting Options and Properties