View ECDL/ICDL Site

Microsoft Access 2007 Training Courseware Materials
Foundation Level Teaching Materials

Training Course Outline.

A FIRST LOOK AT ACCESS 2007

• Creating and opening an Access database.
• Using views.
• Modifying settings within Access
• Using the Access Help facility

ACCESS 2007 DATABASE CONCEPTS

• What is a database?
• What is a relational database?
• Tables
• Records
• Fields
• Field data types
• Field properties
• Primary key
• Index
• Table relationships
• Setting rules to ensure valid relationships

ACCESS 2007 TABLES

• Creating and saving a table
• Specifying field data types.
• Adding and deleting records
• Adding fields
• Modifying data within a record.
• Navigating within a table
• Deleting a table.
• Defining Keys
• Defining a Primary key.
• Indexing a field with or without duplicates allowed.
• Changing field format attributes
• Simple validation rules
• Creating a one-to-one and a one-to-many relationship
• Deleting relationships
• Applying rules to relationships

ACCESS 2007 FORMS

• Creating, opening, saving deleting and closing forms.
• Navigating through records
• Form headers and footers.

ACCESS 2007 QUERIES

• Finding data within a field.
• Applying a filters
• Creating and saving a single table query
• Use two table querys
• Using operators within queries
• Editing, running and deleting a query.
• Saving and closing a query.
• Sorting records

ACCESS 2007 REPORTS

• Creating and saving a report
• Grouping data under a specific field
• Displaying fields in a grouped report
• Headers, Footers

ACCESS 2007 PRINTING ISSUES

• Previewing a table, form or report
• Changing orientation and paper size
• Printing options within Access

Other 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 Project 2007 foundation courseware materials
• Microsoft Publisher 2007 foundation courseware materials
• Microsoft Visio Web 2007 foundation courseware materials
• Microsoft Expression Web 1 foundation courseware materials