Microsoft Access Advanced

Microsoft Access Advanced Courses, Training Classes

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 DATE END DATE DURATION DAY TIMING CAMPUS REGISTER

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
  • facebook icon
  • facebook icon
  • twitter icon
Duration 40 Hours
Course Fees Contact Us
Faculty IT
Course Level Advanced
Features In Class, Lab, Hands-on Training
Language English
Call Now

Quick Application Form









CIMT College - Mississauga, Brampton, Toronto, Scarborough - Celebrating 20 Years

Careers Start At Cimt College - Mississauga, Brampton, Toronto

AFFILIATED PARTNERS

Our Affiliated Partners