Access 2000-2003
Home Up Outloook 2007 Word 2007 PPT 2007 Tech Notes Excel 2007 Access 2007 Internet Explorer Windows Vista About Us

Access Table of Contents

Planning and Designing Databases
Creating a blank database in Office 2000   
Creating a blank database in Office XP 
Creating a drop-down list
Copy a database design
Defining data types
Input mask for dates
Input mask for telephone numbers
Understanding field properties

Working in Datasheet View
Get familiar with datasheet view
Editing records
Copying Records
Deleting records 
Finding records

Formatting Cells
Changing column width
Working with effects and display
Adjusting row height

Applying Filtering Techniques
Filtering by form
Filtering by selection
Filtering by advanced sort

Sorting Mechanisms
Sorting dates using Like
Sorting dates using Between
Sorting records using Like
Sorting records in alphabetical order

Formulating Queries
Create a query using the Wizard
Using values and operators in a query

Working with Columns
Hide and unhide columns
Moving columns
Renaming columns
Freeze and unfreeze columns

Working with Forms
Creating a form using the Form Wizard
Customize form sections in design view
Copy previous data into next record    
Editing memo or note fields
Realigning the tab order
Working with the Report Function
Designing a report using the Report Wizard

Importing Data in Different Formats
Importing data files   

Software
Viewers and Converters

Updated :  May 21, 2008

Sr. Arlene Callahan
Training Manager
Rivier College
420 Main Street
Nashua, NH 03060-5086
Phone : 603.897.8660
E-mail: acallahan@rivier.edu