Access 2007: Basic

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