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