Access

Access

AC00 – All Modules (1- 4)                                                                               $329

AC01 – Module 1 Access                                                                               $148

The Fundamentals

• Starting and exiting Access
• Giving commands and learning about tables, queries, forms, reports and macros
• Opening and modifying a database object
• Working with multiple windows
• Adding, editing and deleting records in a table or form
• Previewing and printing a database object

Creating and Working with a Database

• Create a database from scratch and use the Database Wizard
• Create a table from scratch and use the Table Wizard
• Understand field data types
• Create and modify a query
• Create queries that sort and filter database information
• Create a form using the Form Wizard
• Create reports and mailing labels using the Report Wizard

Finding, Filtering and Formatting Data

• Find and replace database information
• Sort table information in ascending or descending order
• Filter information by selection, by form
• Create an advanced filter
• Adjust the row height and column width in a datasheet
• Freeze and hide a datasheet’s columns
• Change the appearance of a datasheet

Working with Tables and Fields

• Understand and modify a table’s field properties
• Index a field and add a primary key to the table
• Change a field’s data type
• Format how information is displayed in a field
• Specify data validation options for a field
• Create a lookup field that lets you pick a field’s entry from a list of values

AC02 – Module 2 Access                                                                               $112

Creating Relational Databases

• Understand table relationships
• Create a relationship between two tables
• Understand referential integrity

Working with Queries

• Understand the various types of queries and their purposes
• Create queries based on more than one table
• Create queries that calculate and summarise information
• Use the Expression Builder to create expressions
• Create parameter queries that prompt the user for information
• Create queries that find duplicate and unmatched records
• Create action queries that delete, update, append and export information

AC03 – Module 3 Access                                                                               $108

Working with Forms

• Create and modify a form
• Add, delete, move and size controls
• Change a form’s tab order
• Work with control and form properties and settings
• Use the Control Wizard to create interactive forms
• Create subforms to display information from a one-to-many relationship

Working with Reports

• Create and modify a report
• Add, delete, move and size controls
• Adjust page margins and orientation, add page numbers and dates
• Create and work with report sections
• Use reports to group and sort records
• Add a chart to a report

Formatting Forms and Reports

• Format fonts using the Formatting toolbar
• Change text alignment
• Use Autoformat to quickly format forms and reports
• Change the colour of text, objects and borders
• Apply 3-D effects to the controls on forms and reports
• Use the Format Painter to copy control formatting options
• Add pictures and lines to forms and reports
• Align controls with one another
• Format a control by changing its Formatting Properties

AC04 – Module 4 Access                                                                               $108

Working with Macros

• Create and run a macro
• Create a collection of macros in a single macro group
• Assign a macro to a button on a form
• Assign a macro keystroke combination
• Create a conditional IF/THEN expression

Advanced Topics

• Import information from an external file
• Export information to an external data file
• Import objects from another Access database
• Link tables from an external database
• Export information to an Excel worksheet
• Export records to a Word table
• Mail merge records to Word
• Create and work with hyperlink and OLE object fields