« Back to Programs

Access - Basic Intermediate 10 Hours

Microsoft Access is the Office application for creating a variety small business databases and is a good introduction to database technology.  A key feature of Access is concurrent access - the ability for multiple users to use the database at the same time.  Access databases are built using Objects which include Tables, Forms, Reports and Queries.  We will explore all of these features in this course.  Course topics include the following:

1. Database Concepts

• Exploring Access Objects
• Tables, Forms, Queries and Reports
• Creating a New Access Desktop Database

1. Tables

• Creating Table columns and rows
• Refining Table structure
• Defining relationships between Tables
• Maintaining Data Integrity
• Data Validation
• Sorting and Filtering

1. Forms

• The Form tool, Form Design and the Form Wizard
• Formatting Forms
• Arranging the layout of Forms
• Entering Data into Forms

1. Queries

• The Queries Wizard
• Creating Queries manually
• Summarizing data by using Queries

1. Reports

• The Report Wizard
• Modifying report design
• Previewing and printing reports

Instructor : Frank Asciutto
Dates : 07/11/16 to 07/20/16
Days : Mon,Weds
From : 5:30pm - 8:00pm
Fee : $ 225.00
Course Number : T116B

Class is unavailable at this time please call 973-720-2354 for more information or other course options

« Back to Programs