Microsoft Access Courses

Microsoft Access

Gloria K offers both beginning and intermediate/ advanced courses in Microsoft Access. These courses may be taken individually, but many of our students take both levels.

We offer group as well as one-on-one training. Class sizes are small (usually 5 or 6 students). Our facility is located in Lake Success, New York.

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 or techniques can be improved from taking 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: