Microsoft Access 2 Courseware
Foundation Level IT Training Course

   Training Course Outline

1. Database design and table creation

• Design and document your database
• Questions to ask yourself
• Define your needs
• Basic design rules
• Determine relationships
• Creating a database
• Using the table wizard
• Adding fields from the wizard
• Creating a table without a wizard
• Adding fields to a new table
• Using the field builder
• Defining field (data) types
• Field properties
• The input mask property
• Setting a primary key
• Adding records to a table datasheet

2. Formatting a table

• Editing records
• Selecting techniques
• Deleting records and fields
• Changing the look of the datasheet
• The datasheet grid

3. Relationships

• Defining relationships
• Opening the relationship window
• Adding tables to the relationship window
• Making relationships
• Referential integrity
• Editing relationships

4. Locating and replacing information

• Finding and replacing information
• A simple search
• The find dialog box
• Wildcards
• Finding specific values
• Find and replace
• Quicksorting records
• Sorting records on more than one field
• What is a filter?
• Filtering records
• Applying and saving filters
• Removing a filter

5. Creating simple queries

• Types of query
• The query wizard
• Creating queries
• The query window
• Adding fields to the query
• Setting simple criteria
• Logical operators in search expressions
• Applying queries

6. Creating calculated fields

• Creating calculated fields
• The expression builder window
• Calculated fields - an example
• Combining fields in a query
• Combining fields - an example
• Using wildcard characters

7. Parameter, action and crosstab queries

• Parameter queries
• Creating a single parameter query
• Creating a multiple parameter query
• Action queries
• Crosstab queries

8. Introducing forms

• Creating a form with forms wizard
• Opening the properties dialog box

9. Creating forms

• Form design
• Manipulating controls
• Types of control
• The toolbox
• Creating text box controls
• Creating controls with the toolbox
• Calculated controls
• Changing properties
• Forms and subforms

10. Creating forms for data input

• Controlling data input
• Adding a list box or combo box with a wizard
• Adding check boxes, option buttons and toggle buttons
• Adding an option group
• Adding command buttons
• Adding page breaks

11. Reports

• Basic report structure
• Previewing and navigating reports
• Printing reports
• Creating a report with a wizard
• Sorting and grouping
• Creating reports
• Grouping reports
• Setting properties

Microsoft Office 2007 Courseware materials

• Microsoft Access 2007 foundation courseware materials
• Microsoft Access 2007 intermediate courseware materials
• Microsoft Access 2007 advanced courseware materials
• Microsoft Excel 2007 foundation courseware materials
• Microsoft Excel 2007 intermediate courseware materials
• Microsoft Excel 2007 advanced courseware materials
• Microsoft Outlook 2007 foundation courseware materials
• Microsoft PowerPoint 2007 foundation courseware materials
• Microsoft PowerPoint 2007 intermediate courseware materials
• Microsoft PowerPoint 2007 advanced courseware materials
• Microsoft Word 2007 foundation courseware materials
• Microsoft Word 2007 intermediate courseware materials
• Microsoft Word 2007 advanced courseware materials
• Microsoft Publisher 2007 foundation courseware materials
• Microsoft Project 2007 foundation courseware materials
• Microsoft Visio 2007 foundation courseware materials
• Microsoft Expression Web 1 foundation courseware materials