Objective

This class covers advanced concepts in Microsoft Access and is designed for students with significant experience using Access who would like to take their database skills to the next level. ​

Prerequisites

Familiarity with creating databases in Microsoft Access.

Outline

Querying with SQL

 

  • ​SQL and Access
  • Writing SQL statements
  • Attaching SQL queries to controls​

Advanced Queries

  • Creating Crosstab queries
  • Creating parameter queries
  • Using Action queries

Macros

  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects

Advanced Macros

  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating the AutoKeys and AutoExec macros
  • Creating macros for data transfer

Importing, Exporting, and Linking

  • Importing objects
  • Exporting objects
  • Interacting with XML documents
  • Linking Access objects
  • Working with Windows SharePoint Services

Database Management

  • Optimizing resources
  • Protecting databases
  • Setting options and properties

Internet Integration

  • Hyperlink fields
  • Working with Outlook 2007

 

 

Credits

0.70 Continuing Education Units
Course ID #TECH250



Class Details

Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:03/06/2019
Time:8:00 am to 4:00 pm
List Price:$405.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:09/20/2019
Time:8:00 am to 4:00 pm
List Price:$405.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:05/06/2019
Time:8:00 am to 4:00 pm
List Price:$405.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:10/28/2019
Time:8:00 am to 4:00 pm
List Price:$405.00

Don't see what you are looking for?

Contact Us