Objective

Students leave this class feeling confident with the advanced features in Microsoft Access and be able to develop complex detailed databases. ​

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