MICROSOFT ACCESS ADVANCED

Program Details Program Code:
School: Macmillian Institute of Applied Health Sciences
Credential:Ontario College Certificate
Program Type:
Program Length:
Location: College Campus/Online
Email: macmillianinstitute@gmail.com
Telephone:647-219-4887

DURATION: 14 WEEKS (45 Hrs)

COST:$ 1400

Overview: 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

NEXT COURSE START DATES:

Start DateEnd DateTimeDay’sTotal Hrs.
     

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

Quick Contact