Access 2003 Classes

Advanced Techniques of Database Design

Effective database organization and design ensures administrators gather the information they need and nothing more. In our comprehensive Intermediate Access training course, you’ll learn popular development techniques and practices that promote efficient administration and use saving both time and money.

This engaging and interactive seminar shows you how to easily add and create normalized databases. A normalized database eliminates redundant information, while ensuring all information conforms to normal forms rules. It also guarantees proper table linking. Our instructors walk you step-by-step through the process for adding and creating permanent relationships, removing duplicate information from your database for normalization and eliminating unmatched data for reference integrity.

Attendees then learn various types of joins including left, right, equi and self joins. You’ll find out why they’re important, what they’re used for and when to use which. Students receive hands-on experience in using the Access Table Analyzer Wizard to normalize data structure on imported data and identify repeated information. Students also learn how to employ another helpful tool, the Lookup Wizard, to enter a list of values or find a value from another query or table. Then, we explain the steps in creating an AutoLookup Form to, for example, automatically complete customer data after their CustomerID is entered.

Learn how to use Access to:

Add and Create Normalized Databases for Data Storage
Add and Create Permanent Relationships for Faster Access
Duplicate Data Removal for Normalization
Remove Unmatched Data for Referential Integrity
Create Left-, Right-, Equi- and Self- Joins
Use Table Analyzer Wizard on Imported Data
Use the Lookup Wizard
Create an AutoLookup Form For Simplified Administration

Enhancing Select Queries in Access

Queries simplify data retrieval based on certain criteria. When you use queries, you can sort, filter, or perform calculations on database records. Queries also help combine data across multiple tables within a database. In this part of the Access training class we show students how to use the database's built-in visual tools that simplify and expedite the entire data retrieval process. You’ll learn how to create queries using the Query Design window, how to specify data sources and fields, add criteria expressions and designate a sort order.

Students also learn how to use the Expression Builder to establish criteria from scratch or use built-in expressions to display page number, time and date. The Access Intermediate class then explores parameter and crosstab query creation, both in Design View and with the Wizard, simplifying presentation of extensive amounts of data. Finally, instructors show you how to incorporate math and date functions into your queries.

Lean how to:

Use the Query Design Window to Create Queries
Use the Expression Builder to Create Criteria
Create Parameter Queries
Create Crosstab Queries in Design View
Create Crosstab Queries with the Wizard to Streamline Data Analysis
Use Query Operator and Functions

Running Action Queries in Access

Database administrators use queries to modify vast amounts of records. These modifications range from updating values, copying or moving records, to appending and deleting them altogether.

In this section, participants gain practical skills in appending, removing and updating records using the Append, Delete and Update Query. Students also learn how to use the Make Table Query to move records into a new table.

Learn how to:

Append records using an Append Query
Remove records using the Delete Query
Update records using an Update Query
Move records into a new table using Make Table Query

Creating Advanced Reports with Access

The Change Chart Types feature in Access automatically summarizes table information including text and charts, professionally formatting everything for presentation. Students learn how to use this feature and regenerate their report at any time using up-to-date information.

This part of the training shows you how to design a summary report. It also explores the steps needed to modify a report by altering its properties. Students then create a running sum showing the cumulative total of any given field or report value.

Instructors bring each lesson into a practical context, discussing ways Parameter Queries are used in reports to, for example, let the user type in a month to see a data report for that month. They also show students how to add charts to reports or change chart types for more appealing presentations.

Learn how to:

Create Summary Reports For Analysis
Modify Report Formatting by Altering Report Properties
Create a Running Sum
Create Reports from Parameter Queries
Add Charts to Reports For Visual Impact

Access: Multi-Table Forms

While standard forms display single table records, multi-table forms also show related records in embedded sub-forms. This is extremely useful, for example, with retailers when a company displays customer orders. In this case, a shop can open a main form showing customer information and an embedded sub-form displaying all of the customer’s past orders.

Those who attend our popular Intermediate Access training course learn how to design forms with embedded sub-forms and change sub-form properties. They also learn how to use Wizards to create a new sub-form.

Students learn how to customize forms to suit user preferences by specifying tab-order of form objects. They also learn how to modify the Record Source Property, or the source data it displays in queries.

Learn how to:

Create Forms with Embedded Sub-forms
Change Sub-form Properties
Create Sub-forms using Wizards For Easier Data Analysis
Specify the Tab-order of Form Objects For Simplified Navigation
Modify the Record Source Property to Use Queries

Access 2003 classes offered at four locations::

Access 2003 Intermediate Class