Microsoft Access 2007 Expert
Courseware Training Materials
Part of the Computer Expert Series

Intermediate / Advanced level computer training materials for delivering training to your students, staff or clients.  A courseware site licence allows you to train an unlimited number of people, at your training center using these teaching resources.

Training Course Outlines 

DATABASE TERMINOLOGY & THEORY

• What is a database?
• What is a table?
• What is a record?
• What is a field?
• What is meant by 'Field data types'?
• What are 'Field properties'?
• What is a primary key?
• Types of Database
• Database Design Stages
• Large scale database systems

TRUSTED LOCATIONS

• Allowing Access to your sample folder for this course

FIELDS

• What is a table lookup?
• Creating a lookup within a field.
• Modifying a lookup within a field.
• Deleting a lookup within a field.
• What is an input mask?
• Creating an input mask.
• Modifying an input mask.
• Deleting an input mask.
• What does data entry required/not required mean?
• Modifying a field to require data entry.
• Modifying a field so that it does not require data entry.

RELATIONSHIPS

• What is a one-to-one relationship?
• Creating a one-to-one relationship.
• Modifying a one-to-one table relationship
• Deleting a one-to-one table relationship
• What is a one-to-many table relationship?
• Creating a one-to-many relationship.
• Modifying a one-to-many relationship.
• Deleting a one-to-many relationship.
• What is a many-to-many relationship?
• Creating a many-to-many relationship using a junction table.
• Modifying a many-to-many relationship.
• What is referential integrity?
• Enforcing referential integrity.
• Applying automatic updating of related fields.
• Applying automatic deletion of related records.

JOINS

• Applying an inner join.
• Modifying an inner join.
• Applying an outer join.
• Modifying an outer join.
• Creating a subtract join.
• Modifying a subtract join.
• What is a self join?
• Applying a self join.

QUERIES

• About queries
• Creating and running an update query.
• Creating and running a delete query.
• Creating and running a Make Table query.
• Creating and running an Append query.
• Creating and running a crosstab query.
• Creating and running a Find Duplicates query.
• Creating and running a Find Unmatched Records query.
• What is a parameter query?
• Creating and running a one variable parameter query.
• Modifying a one variable parameter query.
• Creating and running a two variable parameter query.
• Modifying a two variable parameter query.
• Using wildcards in a query: Star
• Using wildcards in a query: Brackets and dash
• Using wildcards in a query: Exclamation Mark.
• Using wildcards in a query: Hash
• Showing Maximum or minimum values in a query.
• Using calculated fields that perform arithmetic calculations.
• Grouping information in a query using functions - sum.
• Grouping information in a query using functions - count.
• Grouping information in a query using functions - Average.
• Grouping information in a query using functions - Max & min.

FORMS

• Types of form controls
• Bound controls vs. unbound controls.
• Creating, modifying and deleting bound controls: text box.
• Creating, modifying and deleting bound controls: combo box.
• Creating modifying and deleting bound controls: list box.
• Creating bound controls: check box.
• Modifying and deleting bound controls: check box.
• Manipulating bound controls: option groups.
• Applying bound control properties: limit to list
• Applying bound control properties: distinct values.
• Manipulating unbound controls containing arithmetic expressions.
• Manipulating unbound controls containing logical expressions.
• Modifying the tab order within a form.
• What is a sub-form?
• Creating a sub-form.
• Linking a sub-form.

REPORTS

• Formatting arithmetic calculation controls to display a percentage
• Formatting arithmetic calculation controls to display currency.
• Formatting arithmetic calculation controls to display specific decimal places.
• Applying a running sum for a group or over all
• What is Concatenation?
• Concatenating fields within a report.
• Inserting a data field in a report group.
• Inserting a data field in a report page.
• Inserting a data field in report headers and footers.
• Sorting and grouping records in a report by field(s).
• Forcing page breaks for groups in a report.
• Creating a linked sub-report.

MACROS

• Macro to close an object and open another object.
• Macro to open and maximize an object.
• Macro to print and close an object.
• Assigning a macro to a command button.
• Assigning a macro to an object.
• Assigning a macro to a control.

LINKING DATA

• Linking external data in an Excel workbook to a database.
• Linking external text data in a TXT file to a database.
• Linking external text data in a CSV file to a database.
• Linking external data to a database using existing database files.

IMPORTING DATA

• Importing a spreadsheet file into a database.
• Importing a CSV text into a database.
• Importing a TXT file into a database.
• Importing an XML file into a database.
• Importing an existing database file into a database.