microsoft access online training

Access Training
Info and Order

Here are the online courses we offer:

After completing courses, the user should be able to:

• Identify appropriate input and output for a database
• Plan a database
• Create a database with and without the wizard
• Select and print database objects
• Explain the structure of a table, the data types used in the table, and the function of primary keys
• Create a table using the wizard
• Enter records into the table through a form or datasheet
• Insert and delete records and fields
• Modify the appearance and structure of the table in Design View
• Change the size, format, and default value of fields
• Use the Lookup and Input Mask wizards
• Sort records
• Create advanced sorts
• Search for records
• Apply and remove filters
• Define table relationships
• Display related records
• Specify query criteria
• Create calculated fields
• Create and modify multi-table queries
• Create a form
• Edit the form in design view
• Add and modify controls
• Create and use calculated controls
• Describe the components of reports
• Create a report using the Report wizard.
• Edit the report in design view
• Add and modify controls in a report
• Create and use calculated controls in a report
• Import data into a table
• Save an object as a Web page
• Add hyperlinks to an object
• Back up restore and compact a database

A typical course has the following features:

• Exercises that allow users to practice
• A file containing the text of the exercises
• Simulations that allow users to practice course skills
• A course index
• A glossary
• A Skill Assessment