MS Access Training Class

Validating Data

Access is a relational database. So tables in the application can have relationships. These relationships can prevent redundant, stale and inaccurate data. In this class, students learn how to enforce and establish relationships between tables using tools available in Access such as the Table Analyzer Wizard, Lookup Wizard and AutoLookup Form.

Enhancing Select Queries

Select queries are used to display data from tables or to display tables based on specific criteria. Using select queries, database administrators and designers can perform various data operations, like math-related operators and string operations. Students learn how to perform these and how to use the application’s Expression Builder, Parameter Query and Crosstab Query Wizard.

Running Action Queries

Students, from time-to-time, may want to perform an action on many records at once without manually editing each. In this class, students learn how to create action queries to modify multiple table records, append records to an existing table or delete records from a table that meets a particular condition.

Creating Advanced Reports

Access has built-in functionality to help database administrators create professional looking reports using charts. In this class, students learn how to add various types of charts available and ways to enhance chart esthetics by, for example, changing colors or adding gridlines.

Creating Multi-Table Forms

A single form is sometimes ill-suited to display the data at hand. When this happens, students need additional forms embedded inside the main one. For instance, forms may designate city areas, with each area holding multiple real estate listings. To do this, programmers use a master form to display the area and sub-forms to display each real-estate listing. In this class, students learn how to add forms both manually, to gain the greatest control, and via the application’s wizard. We also show you how to modify the form data source and how to set tab order for form controls.

Prerequisites:

• A solid understanding of Windows’ file management, the concepts of right-clicking and selecting object properties
• Successful completion of Access Intro class or equivalent experience providing a basic understanding of tables, queries, forms and reports

Related MS Office Classes in Sacramento:

• Access Training Intro
• Excel Training Intro
• Excel Training Intermediate
• Excel Training Advanced
• PowerPoint Training Intro
• PowerPoint Training Intermediate
• Word Training Intro
• Word Training Intermediate