Microsoft Access Courses

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. Our facility is located in Great Neck, NY.

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
• Add Records to a Table
• 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
• 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
• 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

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

If you are interested in our Microsoft Access courses you can call the school directly at 516-482-2323 or
718-423-4444.

If you would like to view our other offerings, we have provided a listing and descriptions for our other courses.

Our class sizes are small, usually no more than eight students per class. Each student will work on their own computer in a comfortable environment.

All of our instructors are experienced and licensed by the New York State Education Department. The school is also licensed by New York State.

We offer flexible schedules, including day, evening and Saturdays.

So contact us today so that you can be prepared for the future!