Access 2007:
Basic
Topic-Level
Outline
Days: 1
Prerequisites: Microsoft
Windows XP: Basic or Microsoft Windows Vista: Basic, or equivalent
experience
Unit 1 : Getting started
Topic A:0 Database concepts
A-1: Identifying database components
A-2: Identifying the advantages of relational databases
Topic B:0 Exploring the Access environment
B-1: Starting Access and examining the Access window
B-2: Opening a database
B-3: Using the Navigation Pane
B-4: Examining a database table
Topic C:0 Getting help
C-1: Using Help
Unit 2 : Databases and tables
Topic A:0 Planning and designing databases
A-1: Planning a database
A-2: Creating a database from a template
A-3: Creating a blank database
Topic B:0 Exploring tables
B-1: Discussing views
B-2: Examining a table in Datasheet view
B-3: Navigating in a table in Datasheet view
B-4: Examining a table in Design view
Topic C:0 Creating tables
C-1: Creating a table by using the table templates
C-2: Creating a table in Design view
C-3: Adding fields and descriptions to a table
C-4: Setting the primary key
C-5: Saving the table
C-6: Adding a record
C-7: Copying, modifying, and deleting a table
C-8: Creating a composite key
Unit 3 : Fields and records
Topic A:0 Changing the design of a table
A-1: Modifying field names
A-2: Deleting and inserting fields
A-3: Moving a field
A-4: Using the Attachment data type
A-5: Adding a total row
Topic B:0 Finding and editing records
B-1: Finding and replacing a value
B-2: Undoing changes
Topic C:0 Organizing records
C-1: Sorting records by a single field
C-2: Sorting records by multiple fields
C-3: Using Filter By Selection
C-4: Using Filter By Form
C-5: Using Filter Excluding Selection
C-6: Using Advanced Filter/Sort
C-7: Deleting a record
Unit 4 : Data entry rules
Topic A:0 Setting field properties
A-1: Setting the Required property
A-2: Using the Allow Zero Length property
A-3: Setting the Field Size property
A-4: Setting the Append Only property
Topic B:0 Working with input masks
B-1: Creating an input mask
B-2: Working with the Input Mask Wizard
Topic C:0 Setting validation rules
C-1: Creating validation rules
C-2: Setting validation text
Unit 5 : Basic queries
Topic A:0 Creating and using queries
A-1: Planning a query
A-2: Using the Query Wizard
A-3: Creating a query in Design view
A-4: Saving and running the query
A-5: Sorting query results
A-6: Filtering a query by adding criteria
A-7: Creating a query from a filter
Topic B:0 Modifying query results and queries
B-1: Editing query results
B-2: Adding fields to a query
B-3: Finding records with empty fields
Topic C:0 Performing operations in queries
C-1: Using comparison operators
C-2: Using the OR condition
C-3: Using the AND condition
C-4: Using the * wildcard
C-5: Using calculations in a query
C-6: Totaling a group of records
C-7: Using the Avg and Count functions
C-8: Using the Min and Max functions
Unit 6 : Using forms
Topic A:0 Creating forms
A-1: Examining a form
A-2: Creating a basic form
A-3: Creating a form using the Form Wizard
Topic B:0 Using Design view
B-1: Creating a form in Design view
B-2: Adding controls
B-3: Modifying properties
B-4: Applying conditional formatting
Topic C:0 Sorting and filtering records
C-1: Using a form to sort records
C-2: Using a form to filter records
Unit 7 : Working with reports
Topic A:0 Reports
A-1: Examining a report
A-2: Creating a basic report
A-3: Creating a report using the Report Wizard
A-4: Creating a report using Design view
Topic B:0 Modifying and printing reports
B-1: Modifying a report in Design view
B-2: Modifying a report in Layout view
B-3: Grouping, sorting, and filtering a report
B-4: Adding summary fields using the Report Wizard
B-5: Modifying the layout and style of a report
B-6: Printing a report