Course Catalog

Introduction to Access 2003

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 a new database, 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 file
• Creating a form/modifying and manipulating data
• reopening a database file/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
• copying, renaming and deleting database objects
• compacting and repairing a database, backing up a database
• importing spreadsheet data into an Access table
• importing text into an Access table

Course Length

For More Information

Other Access 2003 Courses: