Course Catalog

Introduction to Access 2002

Topics

• Introduction
• Getting Started
• what is Access? starting Access, the Access application window
• working with Access menus, basic Access terminology
• examining Access objects
• resetting the database folder, displaying help information
• exiting from Access
• Setting up a new database
• designing and creating a new database, creating a new table
• entering records in datasheet view
• printing the datasheet of a table
• navigating through records in datasheet view
• closing a table/closing a database
• Creating a form/modifying and manipulating data
• reopening a database/reopening a table
• creating a form
• navigating through records in form view/closing a form
• reopening a form
• switching between form view and datasheet view
• entering records in form view
• editing records in datasheet view and in form view
• using the find feature
• deleting records in datasheet view and in form view
• modifying the datasheet view of a table
• sorting the records in a table
• Displaying selected data
• filtering the records in a table
• creating a simple query
• creating a query in design view
• modifying a query
• including a numeric condition in a query
• including a calculated field in a query
• Creating a report
• creating a simple tabular report
• creating a grouped tabular report, modifying a report
• Additional Access features
• using the spelling checker
• copying, renaming and deleting database objects
• importing spreadsheet data into an Access table
• Final case study

Course Length

For More Information

Other Access 2002 Courses: