Microsoft Access 2007 Outline (Class room base teaching)

Access Chapter One: The Fundamentals

• Introduction to Databases
• Starting Access 2007
• The Getting Started Page and Opening a Database
• What´s New in Access 2007
• Understanding the Access Program Screen
• Understanding the Ribbon
• Using the Office Button and Quick Access Toolbar
• Using Keyboard Commands
• Using Contextual Menus
• Using Help

Access Chapter Two: Database Basics

• Working with Database Objects
• Tour of a Table
• Adding, Editing and Deleting Records
• Tour of a Form
• Tour of a Query
• Tour of a Report
• Previewing and Printing a Database Object
• Selecting Data
• Cutting, Copying and Pasting Data
• Using Undo and Redo
• Checking Your Spelling
• Using the Zoom Box
• Exiting Access 2007

Access Chapter Three:
Creating and Working with a Database

• Planning a Database
• Creating a New Database
• Creating a Table
• Modifying a Table
• Creating a Query
• Sorting a Query
• Using AND & OR Operators in a Query
• Creating a Form with the Form Wizard
• Creating a Report with the Report Wizard
• Creating Mailing Labels with the Label Wizard
• Converting an Access Database

Access Chapter Four:
Finding, Filtering, and Formatting Data

• Finding and Replacing Data
• Sorting Records
• Using Common Filters
• Filtering by Selection
• Filtering by Form
• Creating an  Filter
• Adjusting and Rearranging Rows and Columns
• Changing Gridline and Cell Effects
• Changing the Datasheet Font
• Freezing a Column
• Hiding a Column

Access Chapter Five:
Working with Tables and Fields

• Understanding Field Properties
• Indexing a Field
• Adding a Primary Key to a Table
• Inserting, Deleting, and Reordering Fields
• Adding Field Descriptions and Captions
• Changing the Field Size
• Formatting Number, Currency, and Date/Time Fields
• Formatting Number, Currency, and Date/Time Fields by Hand
• Formatting Text Fields
• Setting a Default Value
• Requiring Data Entry
• Validating Data
• Creating an Input Mask
• Creating a Lookup Field
• Creating a Value List
• Modifying a Lookup List

Access Chapter Six:
Creating Relational Databases

• Understanding Table Relationships
• Creating Relationships between Tables
• Enforcing Referential Integrity
• Printing and Deleting Table Relationships
• Understanding of Relationship Types

Access Chapter Seven:
Working with Queries

• Understanding the Different Types of Queries
• Creating a Multiple Table Query
• Creating a Calculated Field
• Working with Expressions and the Expression Builder
• Using an IIF Function
• Summarizing Groups of Records
• Display Top or Bottom Values
• Parameter Queries
• Finding Duplicate Records
• Finding Unmatched Records
• Crosstab Queries
• Delete Queries
• Append Queries
• Make Table Queries
• Update Queries

Access Chapter Eight:
Working with Forms

• Creating and Using a Form
• Understanding Form Views
• Modifying a Form in Layout View
• Form Design View Basics
• Changing Tab Order
• Working with Control Properties
• Control Property Reference
• Working with Form Properties
• Form Property Reference
• Changing a Control´s Data Source
• Creating a Calculated Control
• Changing a Control´s Default Value
• Creating a Sub-form

• Modifying and Working with Sub-forms

Access Chapter Nine:
Working with Reports

• Creating a Report
• Working in Layout View
• Adding a Logo
• Working in Design View
• Adjusting Page Margins and Orientation
• Adding Page Numbers and Dates
• Grouping and Sorting
• Summarize Data using Totals
• Using Report Sections

Access Chapter Ten:
Formatting Forms and Reports

• Formatting Fonts
• Changing Text Alignment
• Changing Colours
• Applying Special Effects
• Using Conditional Formatting
• Adding Pictures, Lines and Gridlines
• Working with Number Formatting
• Using AutoFormat

Access Chapter Eleven:
Working with Macros

• Creating and Running a Macro
• Editing a Macro
• Working with Macro Groups
• Assigning a Macro to an Event
• Creating Conditional Expressions
• Assigning a Macro to a Keystroke Combination
• Macro Action Reference
  

Access Chapter Twelve:
Topics

• Importing Information
• Exporting Information
• Linking Information from an External Source
• Using Hyperlink Fields
• Displaying Database Object Dependencies
• Setting a Password in Access
• Compacting and Repairing a Database