Microsoft Access 2003 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 

GETTING UP TO SPEED WITH MICROSOFT ACCESS 2003

• Help using Access.
• The ‘Security Warning’ dialog box.
• Selecting the required ‘object’ type
• Switching between views.
• Displaying the ‘Properties Box’ for a control.
• Displaying the ‘Toolbox’.
• Displaying the ‘Field List’.
• Forcing ‘Wizards’ to run automatically.
• Opening sample database files for use within this course.

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?
• The Flat Model Database model
• The ‘Relational’ database model
• The ‘Hierarchical’ database model.
• The ‘Object-Oriented’ database model.
• The life cycle stages of a database.
• Dynamic websites.
• Customer relationship management systems.
• Enterprise Resource Planning Systems.
• Website Content Management Systems (CMS).
• What is SQL (Structured Query Language)?

FIELDS

• Creating a lookup in a field.
• Modifying a lookup in a field.
• Deleting a lookup in a field.
• What is an Input Mask?
• Creating an Input Mask in a field.
• Modifying an Input Mask in a field.
• Deleting an Input Mask in a field.
• Setting data entry for a field as ‘Required’.
• Setting data entry for a field as ‘Not required’.

RELATIONSHIPS

• Creating a one-to-one relationship between tables.
• Modifying a one-to-one relationship between tables.
• Deleting a one-to-one relationship between tables.
• Creating a one-to-many relationship between tables.
• Modifying a one-to-many relationship between tables.
• Deleting a one-to-many relationship between tables.
• Creating a many-to-many relationship using a junction table.
• Modifying a many-to-many relationship using a junction table.
• Enforcing referential integrity between tables.
• Applying cascade update of related fields.
• Applying automatic deletion of related records.

JOINS

• What are joins?
• Applying an inner join.
• Modifying an inner join.
• Applying an outer join.
• Modifying an outer join.
• Creating and modifying a subtract join.
• Modifying a subtract joint
• What is a self join?
• Applying a self join.

QUERIES

• Creating and running a query to update data in a table.
• Creating and running a query to append records to a table.
• Creating and running a query to delete records in a table.
• Creating and running a query to save selected data as a new table.
• What is a crosstab query?
• Creating and running a crosstab query.
• Creating and running a query to show duplicated records within a table.
• Creating and running a query to show unmatched records in related tables.
• 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: *.
• Using wildcards in a query: [ - ] – Brackets and Dash
• Using wildcards in a query: !
• Using wildcards in a query: #.
• Showing highest or lowest range of values in a query.
• Creating and naming a calculated field that performs arithmetic calculations.
• Grouping information in a query using the ‘sum’ function.
• Grouping information in a query using the ‘average’ function.
• Grouping information in a query using the ‘max’ & ‘min’ functions.
• Grouping information in a query using the ‘count’ function.

FORMS

• Bound vs. unbound controls
• Creating, modifying and deleting a text box bound control.
• Creating, modifying and deleting a combo box bound control.
• Creating, modifying and deleting a list box bound control.
• Creating, modifying and deleting a check box bound control.
• Creating, modifying and deleting an option group bound control.
• Applying and removing ‘limit to list’ bound control properties.
• Applying and removing ‘distinct values’ bound control properties.
• Creating, modifying and deleting unbound controls containing arithmetic expressions.
• Creating, modifying and deleting unbound controls containing logical expressions.
• Modifying the sequential tab order of controls on a form.
• Creating a sub-form.
• Linking and deleting a sub-form.

REPORTS

• Formatting arithmetic calculation controls in a report: percentage.
• Formatting arithmetic calculation controls in a report: currency.
• Formatting arithmetic calculation controls in a report to a specific number of decimal places.
• Applying a running sum for a ‘group’ and also ‘over all’.
• Concatenating fields in a report.

CUSTOMIZING REPORTS

• Inserting and deleting a data field in group.
• Inserting and deleting a data field in page.
• Inserting and deleting a data field in report headers and footers.
• Sorting and grouping records in a report by field(s).
• Force page breaks for groups in a report.
• Creating, modifying and deleting a linked sub-report.

LINKING DATA

• Linking a workbook file to a database.
• Linking a text file (txt) to a database.
• Linking a CSV file to a database.
• Linking an external database file to a database.

IMPORTING DATA

• Importing a workbook file into a database.
• Importing a text file (txt) into a database.
• Importing a CSV file into a database.
• Importing an XML file into a database.
• Importing an existing database file into a database.

MACROS

• Creating a macro to close one object and open another object.
• Creating a macro to open and maximize an object.
• Creating a macro to open and minimize an object.
• Creating a 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.