Microsoft Office Access (COCR1024)

Aim

To teach you what a relational database is and what it can do for you in the workplace. To help you to learn to use Access 2007 to make more informed business decisions by effectively tracking, reporting, and sharing information.

Objectives

At the end of the class you will be able to do the following:

• Introduced to the concept of the relational database and the Microsoft Access 2007 relational database application and its information management tools.
• Able to design and create a new Access database
• Able to customize database components
• Able to share Access data with other applications.

Prerequisites

Computer Literacy which includes: keystroking ability and mouse techniques; ability to:- Open, Close, Save and Find documents and Create New Folders.

Exam Skill Standards

Below are the tasks you’ll be expected to be able to perform in order to pass the Using Microsoft Office Access 2007 Application Specialist exam. You can use this as a study checklist.

1. Structuring a Database
   • Define data needs and types
   • Define and print table relationships
   • Add, set, change, or remove primary keys
   • Split databases
2. Creating and Formatting Database Elements
   • Define data needs and types
   • Define and print table relationships
   • Create databases
   • Create tables
   • Modify tables
   • Create fields and modify field properties
   • Create forms
   • Create reports
   • Modify the design of reports and forms
3. Entering and Modifying Data
   • Enter, edit, and delete records
   • Navigate among records
   • Find and replace data
   • Attach documents to and detach from records
   • Import data
4. Create and modify queries
   • Create queries
   • Modify queries
5. Presenting and Sharing Data
   • Enter, edit, and delete records
   • Navigate among records
   • Find and replace data
   • Attach documents to and detach from records
   • Import data
6. Create and modify queries
   • Sort data
   • Filter data
   • Create and modify charts
   • Export data
   • Save database objects as other file types
   • Print database objects
7. Managing and Maintaining Databases
   • Perform routine database operations
   • Manage databases

 Assessment – Access (COCR1024)

• Each of the six exam skills is equally weighted
• Maximum score is 1000
• Passing score is 670

Required Text

Title: Microsoft Office Access 2007 Step by Step.

Author: Lambert, Steve

Publisher: Microsoft Press

ISBN: 978-0-7356-2303-3