Course Offerings - Microsoft Access

Access –Access Versus Excel

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Basic comfort level with Excel.

Course Description:
This course allows the user to compare and contrast Excel and Access.

Attend this course if you want to:
  • Understand the differences between the 2 programs.
  • Understand the advantages of using a database program,
  • Learn to evaluate which tool is a better fit for your needs.
  • Learn the basic objects and their purpose in Access.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access –Understanding Tables

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Access versus Excel course or equivalent knowledge.

Course Description:
This course allows the user to understand the role of tables within Access.

Attend this course if you want to:
  • Review an existing database.
  • Learn about tables.
  • Create a table using various methods.
  • Understand the primary key
  • Explore data types.
  • Add, modify and delete data in a table.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access –More Tables and Relationships

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Access Understanding Tables course or equivalent knowledge.

Course Description:
This course further explores tables and how they relate to one another using a relational database concept.

Attend this course if you want to:
  • Explore data properties within a table.
  • Learn to relate tables to each other.
  • Understand relationships in Access.
  • Create, modify and view relationships in Access.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access –Query Basics

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Basic understanding of Tables in Access.

Course Description:
This course allows the user to create a basic query using criteria to filter and sort the results.

Attend this course if you want to:
  • Understand how to work with data in tables.
  • Create a query.
  • Understand sorting and filtering in a query.
  • Use criteria to filter a query.
  • Create calculations in a query.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access –Advanced Queries

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Basic understanding of Queries in Access.

Course Description:
This course allows the user to further explore queries in Access using some of the additional query types.

Attend this course if you want to:
  • Create and use action queries.
  • Create a crosstab query.
  • Create a parameter query.
  • Use a multi-table query.
  • Use the totals row in a query.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access –Designing Forms

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Basic understanding of Tables in Access.

Course Description:
This course allows the user to understand forms and how to create them in Access.

Attend this course if you want to:
  • Learn about what forms are used for.
  • Create a form using various methods.
  • Modify an existing form.
  • View data in a form.
  • Create a switchboard form.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access - Designing Reports

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Basic understanding of Tables in Access.

Course Description:
This course allows the user to explore creating reports in Access.

Attend this course if you want to:
  • Learn about reports.
  • Create a report using various methods.
  • Format and modify an existing report.
  • Save a report in Word or Excel.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access - Maximizing Reports

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Basic understanding of Reports in Access.

Course Description:
This course allows the user to further their knowledge about reports in Access.

Attend this course if you want to:
  • Sort and group data in a report.
  • Create built-in expressions in a report.
  • Use subreports and subforms.
  • Create multiple column reports.
  • Create report snapshots.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access - Maximizing Forms

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Basic understanding of Forms in Access.

Course Description:
This course allows the user to further knowledge about forms in Access.

Attend this course if you want to:
  • Adding combo boxes and option boxes to a form.
  • Create a multiple page form.
  • Work with tab order.
  • Work with subforms.
  • Using the toolbox.
  • Create lookup forms.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access -Writing a Macro

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Thorough understanding of Tables in Access.

Course Description:
This course exposes the user to macros in Access.

Attend this course if you want to:
  • Learn how macros are used in Access.
  • Create a macro in Access.
  • Assign macros to controls.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Access Using Access as an Application

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Thorough understanding of all objects in Access.

Course Description:
This course allows the user to look at access as an application where it is full functioning program for multiple users.

Attend this course if you want to:
  • Learn how to create a navigational user interface.
  • Learn how to automate tasks.
  • Learn to use the autoexec macro.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom