This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, filters and queries, forms, and reports.

Prerequisites

A knowledge of personal computer fundamentals, experience in working within the Microsoft Windows environment, a reasonable degree of keyboard proficiency and experience in using a mouse.

---

Objectives

After completing this course, students will be able to:

• Start Access
• Display Help information
• Create a new database and a new table
• Enter records in Datasheet view
• Print the datasheet of a table
• Create a form
• Enter records in Form view
• Edit records in Datasheet view and in Form view
• Use the Find feature
• Delete records in Datasheet view and in Form view
• Modify the Datasheet view of a table
• Sort the records in a table
• Filter the records in a table
• Create a simple query
• Create a query in Design view
• Modify a query
• Create a simple tabular report
• Create a grouped tabular report
• Modify a report
• Copy, rename and delete database objects
• Compact and repair a database
• Import spreadsheet data into an Access table

---

Course Materials

The courseware (book) and student data files are included with the class. The courseware is Microsoft Approved Courseware. The courseware has been reviewed and approved to satisfy Microsoft Office Specialist certification exam standards.

[Part 1]  [Part 2]  [Part 3]

Top of Page