Microsoft Access 2000 Courseware 
Foundation Level Training Materials

Courseware Training Manual

1. Introduction to database concepts

• What is a database?
• Tables and relationships
• The Access application window

2. Database design and table creation

• Design and document your database
• Define your needs
• Basic design rules
• Determine relationships
• Creating a database
• Using the table wizard
• Adding fields using the table wizard
• Creating a table without a wizard
• Adding fields to a new table
• Field properties
• The input mask property
• Setting a primary key
• Adding records to a table datasheet

3. Formatting a table

• Editing records
• Selecting records, fields and columns
• Deleting records and fields
• Viewing or setting datasheet default values
• Re-ordering columns and fields
• Changing column width and row height
• Hiding and un-hiding columns
• Freezing columns
• Formatting datasheet cells
• Changing datasheet fonts
• Copying and moving fields and records
• Printing

4. Relationships

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

5. Locating and replacing information

• A simple search
• Wildcards
• Finding specific values
• Find and replace
• Sorting records
• What is a filter?
• Filtering records

6. Creating simple queries

• Opening an existing query
• Creating queries
• The query grid
• Logical operators in criteria
• Text in criteria - wildcards
• Multiple criteria and alternative criteria
• Calculated fields
• Summary queries
• Update queries
• Append queries
• Make-table queries

7. Creating calculated fields

• Creating calculated fields
• Using the expression builder

8. Introducing forms

• Basic form layout types
• Creating a form using autoform
• Creating a form using the form wizard
• Different ways of viewing forms

9. More about creating forms

• Creating forms without using the form wizard
• The form design view window
• Manipulating form design
• Types of control
• The toolbox
• Creating a combo box control
• Changing form properties
• Using forms with subforms
• Creating a form with a subform
• Controlling data input
• Changing tab order
• Adding command buttons
• Adding page breaks
• Switchboards

10. Reports

• Opening and viewing existing reports
• Printing reports
• Creating a report using autoreports
• Creating reports using the report wizard
• Using the label wizard
• Using the chart wizard
• Grouping levels in reports
• Creating a report without a wizard
• Creating controls
• Setting properties

Other Microsoft Office 2000 Courseware materials

• Microsoft Access 2000 Foundation Courseware materials
• Microsoft Excel 2000 Foundation Courseware materials
• Microsoft Excel 2000 Intermediate Courseware materials
• Microsoft Excel 2000 Advanced Courseware materials
• Microsoft FrontPage 2000 Foundation Courseware materials
• Microsoft Outlook 2000 Foundation Courseware materials
• Microsoft PowerPoint 2000 Foundation Courseware materials
• Microsoft PowerPoint 2000 Intermediate Courseware materials
• Microsoft Project 2000 Foundation Courseware materials
• Microsoft Publisher 2000 Foundation Courseware materials
• Microsoft Word 2000 Foundation Courseware materials
• Microsoft Word 2000 Intermediate Courseware materials
• Microsoft Word 2000 Advanced Courseware materials