How To Take This Class

Course Overview

In this Microsoft Access 2013 Advanced Training course, students will learn how to write and execute SQL statements from an Access database, how to use advanced crosstab, parameter and action queries in Microsoft Access and how to automate an Access database using macros. Students will also learn how to import, export and link objects in Access. Finally students will see how to maintain their Access database using security and optimization tools.

Course Prerequisites

Students should have completed, or be familiar with the topics covered in the Microsoft Access 2013 Introduction Class.

Course Audience

This course is designed for individuals who are interested in creating more complex database solutions using SQL statements, advanced queries and macros.

What You'll Learn

After successful completion of this course, students will be able to:
  • Use SQL statements in Access; create aliases for fields; write SQL statements to create queries; and attach a SQL statement to a command button.
  • Create crosstab queries to summarize grouped data; create parameter queries to view results based on specified criteria; and create action queries to add, delete, and modify data in tables and to make new tables.
  • Create and run macros to automate tasks; and attach macros to the events of database objects.
  • Create data validation and data entry macros; create macros that run parameter queries; create AutoKeys and AutoExec macros; and create macros to import and export database objects.
  • Import Access objects from another Access database, from Excel, and from a CSV file; export objects from one database to another; export and import XML documents; save objects as XPS files; link Access objects between databases and to Excel workbooks; and create hyperlink fields.
  • Save databases in file formats for previous versions of Access; use the Performance Analyzer; split, compact, repair, and back up databases; encrypt and password-protect database files; configure Access Options; and populate database file properties.

Course Duration

1 Day

Course Outline

  1. Querying with SQL
    • SQL and Access
    • Writing SQL statements
    • Attaching SQL queries to controls
  2. Advanced queries
    • Creating crosstab queries
    • Creating parameter queries
    • Using action queries
  3. Macros
    • Creating, running, and modifying macros
    • Attaching macros to the events of database objects
  4. Advanced macros
    • Creating macros to provide user interaction
    • Creating macros that require user input
    • Creating AutoKeys and AutoExec macros
    • Creating macros for data transfer
  5. Importing, exporting, and linking objects
    • Importing objects
    • Exporting objects
    • Working with XML documents
    • Linking Access objects
    • Using hyperlink fields
  6. Database management
    • Optimizing resources
    • Protecting databases
    • Setting options and properties

What Students Receive

Each student will receive:
  • A printed courseware manual with examples and hands-on exercises for use during and after class.
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Access 2013 Training Class
  • A course completion certificate upon successful completion of your Microsoft Access 2013 Training course
  • Six months of post-class live, online chat support from a Microsoft Access Instructor