Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


This course is designed for participants who have little or no knowledge of MS Access. On completion of course, participants will be able to design and modify tables, create relationships, use queries, design and modify forms and reports.


 
Course Outline

This course is designed for participants who have little or no knowledge of MS Access. Participants should have basic knowledge of Windows, keyboard and mouse operations.

Learning Objectives:
 
On completion of course, participants will be able to design and modify tables, create relationships, use queries, design and modify forms and reports.

Course Outline:

SECTION 1: Customizing Access

Lesson 1.1: Customizing Menus and Toolbars
Lesson 1.2: Setting Access Options, Part 1
Lesson 1.3: Setting Access Options, Part 2
Lesson 1.4: Creating Macros
Lesson 1.5: Advanced Macro Uses

SECTION 2: Advanced Data Tools
Lesson 2.1: Switchboards
Lesson 2.2: Creating Data Access Pages
Lesson 2.3: Modifying Data Access Pages
Lesson 2.4: Using Data Access Pages

SECTION 3: Advanced Queries
Lesson 3.1: Table Relationships
Lesson 3.2: Using CrossTab Queries
Lesson 3.3: Using Parameter Queries
Lesson 3.4: Advanced Reporting Features

SECTION 4: Pivot Tables and Pivot Charts
Lesson 4.1: Creating a PivotTable
Lesson 4.2: Using AutoForm and Creating PivotCharts
Lesson 4.3: Using PivotTables and PivotCharts

DAY 2

SECTION 1: Getting Started
Lesson 1.1: Starting Out
Lesson 1.2: Using the Access Interface
Lesson 1.3: Getting Help

SECTION 2: Creating a Database
Lesson 2.1: First Steps
Lesson 2.2: Records
Lesson 2.3: Creating a Table
Lesson 2.4: Formatting Text
Lesson 2.5: Formatting Controls

SECTION 3: Doing More with Your Database 
Lesson 3.1: Creating Forms
Lesson 3.2: Creating Queries
Lesson 3.3: Reports
Lesson 3.4: Sorting and Filtering Data

SECTION 4: Viewing and Printing Your Data 
Lesson 4.1: Formatting a Datasheet
Lesson 4.2: Viewing Data
Lesson 4.3: Printing a Database Object


Prerequisites & Certificates
Pre-Requisites

Participants should have basic knowledge of Windows, keyboard and mouse operations.

Certificates offered

Certificate of completion


Cancellation Policy

Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.


Map & Reviews
CompuEase
[ View Provider's Profile ]

Reviews
 
It was an excellent course, but I think it could be done in 1-day instead of 2-day course.
Reviewed by 2011
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 2577 times.