Access Beginning Objectives

Upon the completion of the Beginning Access class participants will be able to:

·    Start Microsoft Access and create a new blank database or open previously prepared database.

·    Identify the menu, task panes, toolbars and objects of the MS Access window.

·    Create a Table using both the wizard and the design view.

·    Given a Table be able to add and change the primary key.

·    Add a field to a Table and change the properties of a previously created field.

·    Modify the column widths and row heights of a given Table.

·    Add new records and modify old records in a given Table.

·    Add an input mask to a field.

·    Insert an OLE object into a table.

·    Given a prepared Table sort the data.

·    Use a wizard to create a form to enter data in a given Table.

·    Filter data by Selection and Form in a given Table.

·    Filter data by Form with more than one variable in a given Table.

·    Create a Query using a wizard for a given Table.

·    Create a Query in the design view for a given Table.

·    Add a calculation field to a Query in the design view.

·    Given a prepared database establish a relationship between two Tables.

·    Given a prepared database create a Query between multiple Tables for a Report.

·    Given a prepared database create a report using the wizard from both a Query and a Table.

·    Create a form with a Combo Box.

·    Format a form in the design view by adding a title and moving various controls.

·    Modify labels in a form using the properties window.

 

Access Intermediate Objectives

Upon the completion of the Intermediate Access class participants will be able to:

·    Create and Run a Macro to that will run a report.

·    Create a Macro with a filter.

·    Create and apply an input mask to a field in a given table.

·    Add a switchboard, to a given database, with buttons to various switchboard pages.

·    Given a database with more than two tables create a form with a sub-form using the wizard.

·    Given a database create a pivot table for a table.

·    Given a database create a pivot chart for a table.

·    Prepare data in an Excel worksheet to be imported into an Access database.

·    Export contacts from MS Outlook into an access database file.

·    Import from a MS Access table to MS Outlook contacts.

·    Create an Access Page from a given table.

 

Access Advanced Objectives

Upon the completion of the Advanced Access class participants will be able to:

·    Define the components of a MS Access expression.

·    Use the Expression Builder to create an expression.

·    Build an expression in a table of a given Access database.

·    Build an expression in a control box of a Report of a given Access database.

·    Build and use an expression in the criteria box of a Query.

·    Add an expression to a field portion of a Query.

·    Use an expression in the validation rule of a Table in a given Access database.

·    Use an expression in the validation rule in the property of a control of a Form of a given Access database.

·    Define bound, unbound and calculated controls in Forms and Reports of a given Access database.

·    Given a scenario and some data in an excel workbook design a simple Access database that will solve the problems put forth in the scenario.