Microsoft Access

Microsoft Access

Microsoft AccessIn our classes, you get hands-on Access experience with expert instructors to guide you at every step. Combine the three Access class levels for maximum skills, or take a single class to move your talent up a notch. Keep your instruction manual as a reference, and refresh your new skills with online tutorials. Access gives you the power to collect and manage large amounts of data.

$159 / course

8:30 am - 4:30 pm

Discount Information

Refund Policy

PART 1 - Basics Course

In this course, you will use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help and Configure Options in Microsoft Access
  • Modify Table Data
  • Sort and Filter Records
  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query
  • Create Basic Access Forms
  • Work with Data on Access Forms
  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports

Appendix A: Microsoft Office Access Exam 770730
Appendix B: Microsoft Access Common Keyboard Shortcuts

Course Preview 0:31

Part 1 Schedule

Sep 18, 2020

Global Campus Rogers, Suite 402


PART 2 - Intermediate Course

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports.

  • Relational Database Design
  • Create a Table
  • Create Table Relationship
  • Create Query Joins
  • Relate Data within a Table
  • Work with Subdatasheets
  • Use Field Validation
  • Use Form and Record Validation
  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

Appendix A: Microsoft Office Access Exam 77-730
Appendix B: Microsoft Access Common Keyboard Shortcuts

Course Preview 0:30

To get the most from the intermediate class, you should already know how to:

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options
  • Organize and manage data stored within Access tables
  • Use queries to join, sort, and filter data from different tables
  • Use forms to make it easier to view, access, and input data
  • Create and format custom reports

Part 2 Schedule

Oct 23, 2020

Global Campus Rogers, Suite 402


PART 3 - Advanced Course

Build on your knowledge from the first two classes. With advanced Access skills, you can wield the full power of Access. Advanced skills allow you to use advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more.

  • Add Controls to Forms
  • Enhance Navigation and Organization of Forms
  • Apply Conditional Formatting
  • Import Data into Access
  • Export Access Data
  • Link Tables to External Data Sources
  • Create a Mail Merge
  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Getting Started with VBA
  • Enhance Access Using VBA
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Split a Database for Multiple User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

To get the most from the advanced class, you should already know how to:

  • Design a relational database
  • Join tables to retrieve data from unrelated tables
  • Validate data entered into a database
  • Use advanced queries to manipulate your data
  • Organize a database for efficiency and performance, and to maintain data integrity
  • Customize reports to organize the displayed information and produce specific print layouts.

Part 3 Schedule

Dec 11, 2020

Global Campus Rogers, Suite 402