Microsoft Access Courses

Microsoft Access

GK Corporate Computer Training offers both beginning and intermediate/advanced programs in Microsoft Access.

Suggested topics are offered below. Your company may combine topics for full or half day training sessions

We offer group as well as one-on-one training. We will come to your facility.

Microsoft Access Beginning

This course is designed for those that want to learn Access from the start or refresh a basic knowledge of the program. Even with some familiarity with Microsoft Access, there is always something new to be learned from our Access Beginning course.

Course Outline:

Create a New Blank Database (more)

Add Records to a Table (more)

Rename Table Fields in Datasheet View

Modify the Design of a Table

Add a Second Table to a Database

Create and Use a Query, Form, and Report (more)

Create a Database Using a Template

Organize Database Objects in the Navigation Pane

View a Report and Print a Table in a Database Created with a Template

Create Table Relationships (more)

Sort Records in a Table

Create a Query in Design View

Create a New Query from an Existing Query

Sort Query Results

Specify Criteria in a Query

Importing an Excel Spreadsheet

Specify Numeric Criteria in a Query

Use Compound Criteria

Create a Query Based on More Than One Table

Use Wildcards in a Query

Use Calculated Fields in a Query

Group Data and Calculate Statistics in a Query

Create a Form

Use a Form to Add and Delete Records

Create a Form by Using the Form Wizard

Modify a Form in Design View and in Layout View

Filter Records

Create a Report by Using the Report Tool , Blank Report tool and Wizard

Modify the Design of a Report

Print a Report and Keep Data Together

Microsoft Access Intermediate/Advanced

This course is for students that are already comfortable with their basic knowledge of Access and want to take their knowledge to the next level.

Course Outline:

• Customize Table Fields
• Structure Data Input
• Validate Data Input
• Create Indexes and Change Sort Order
• Create Relationships between Tables
• Create Forms and Reports with Related Tables
• Create Forms with Subforms
• Create Forms with Special Views
• Build a Form in Design View
• Use Advanced Formatting Tools
• Build Reports Based on Queries
• Export a Report and Create a Labels Report
• Create a Subreport Using Design Tools
• Summarize Report Data
• Create a Report with an Interactive Filter

Fill out the form below and click submit

First Name:

Last Name:

City/Town:

Contact Phone:

E-mail:

Best time to be contacted:

For Access training, you can call us directly at 516-482-2323 or fill out the form above.