MS Access Database Course

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:

• 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

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

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

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

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

Related MS Office Training classes in San Francisco:

Access Intro Training Access VBA Training Excel Intro Training Excel Intermediate Training Excel Advanced Training Excel VBA Training

PowerPoint Intro Training PowerPoint Intermediate Training PowerPoint Advanced Training Project Intro Training Word Intro Training Word Intermediate Training