Ardito Corporate Training

Duration: 1.5 days | Book this course
Cost: $550.00 + GST

Course Description

This class is designed to cover creating and using advanced query wizards, working with action queries, and working with specialized queries. Students will learn how to create and use Access pages, and learn database management techniques. The course will cover managing table and query properties, and creating macros and macro groups. Students will learn how to customize menus and toolbars, use Web features, and build an automated form using macros.

Prerequisites
Participants should have completed the Access Fundamentals level or have equivalent experience. If you are unsure, you may phone our Booking Administrator on (07) 857.0770 or (09) 630.1220 to request for a Training Needs Assessment form.

Who Should Take This Course
Users of Access, with an intermediate knowledge of the software's features, who want to learn the advanced end-user functions and features.

Course Objectives

Upon completing this course, you will have learned how to:

1. Use advanced query wizards.
2. Work with action queries.
3. Work with specialized queries.
4. Manage databases.
5. Manage table and query properties.
6. Create macros and macro groups.
7. Build an automated form with macros.
8. Customize menus and toolbars.
9. Use web features.
   
   

Course Outline

Using Advanced Query Wizards
Creating CrossTab Queries
Creating a CrossTab Query
Using Advanced Query Wizards
Finding Duplicate Values
Finding Unmatched Records

Working with Action Queries
Creating a New Table from Query Results
Creating a Make-Table Query
Running the Make-Table Query Again
Updating Records Using an Action Query
Appending Records Using an Action Query
Deleting Records Using an Action Query

Working with Specialized Queries
Working with Parameter Queries
Creating a Parameter Query
Creating Advanced Parameter Queries
Using Queries to Create Forms and Reports
Creating Total Queries
Creating an AutoLookup Query
Using Joins in Queries
Understanding Joins
Creating an Outer Join Query
Creating a Self-Join Query

Database Management
Managing Database Objects
Copying a Database Object
Deleting a Database Object
Managing Database Files
Compacting and Repairing a Database File
Converting a Database File
Optimizing Database Performance
Using the Table Analyzer
Using the Performance Analyzer
Using the Database Documenter

Managing Table and Query Properties
Understanding Field Properties of Tables
Using Validation Rules
Setting the Validation Rule Property
Requiring Data Entry
Allowing Zero-Length Data Entry
Indexing Fields
Setting the Indexed Property
Using the Indexes Window
Creating a Multiple Field Index
Changing the Decimal Places Property
Working with the Input Mask
Using the Input Mask Wizard with a Text Field
Using the Input Mask Wizard with a Date/Time Field
Creating an Input Mask Manually
Working with the Display Control Property
Setting and Changing Table Properties
Setting the Description Property
Setting the Validation Rule and Validation Text Properties
Setting the Filter Property
Setting the Order By Property
Working with Properties in Queries
Working with Field Properties in Queries

Creating Macros and Macro Groups
Understanding Macros
Macro Categories
Creating a Macro
Executing a Macro
Debugging a Macro
Creating Macro Groups
Running Macros in Macro Groups
Assigning Macros to Keys and the Toolbar
Assigning a Macro to a Key
Assigning a Macro to a Toolbar
Creating a Macro that Runs Automatically

Building an Automated Form with Macros
Understanding Form Events
Working with the Open Event
Working with the Click Event
Setting the Command Button Control with the Wizard
Setting the Command Button Control Manually
Using a Conditional Macro with an Exit Event
Creating a Conditional Macro
Setting the On Exit Event Property
Setting a Control's Value After an Exit Event
Working with the Mouse Event
Actions in the TipOn Macro
Actions in the TipOff Macro
Error Trapping with a Click Event
Actions in the Next Macro
Summarizing Events and Macro Actions
Events and Event Properties Summary
Macro Actions Summary

Customizing Menus and Toolbars
Creating a Custom Menu
Adding Macro Groups to Toolbars and Menus
Understanding the Regions Macro Group

Using Web Features
Creating Hyperlinks
Understanding Hyperlinks
Creating a Hyperlink
Exporting a Database for the Web
Understanding the World Wide Web
Exporting a Database Object to HTML Format
Exporting a Database Using the Web
Publishing Wizard

Appendix: Using the Expression builder