|
CompuEase ~ Microsoft & Adobe Software Training Ottawa Cancellation Policy
Description: 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:
THE BASICS
Database Concepts and Terminology
Creating a Database
Converting Access Files
Working with Objects
TABLE DATA
Table Concepts
Viewing Data in a Table
Changing the Datasheet Appearance
Entering and Editing Data
Applying a Filter
TABLE DESIGN
The Table Wizard
Changing the Table Design
Creating a Table in Design View
DATA ENTRY
Data Entry Concepts
Data Formats
Adding records
RELATIONSHIPS
Understanding Relationships and the primary key
CREATING AND USING FORMS
Creating and Opening Forms
Changing a Form Design
QUERIES
Building Queries
Selecting and Sorting in a Query
REPORTS
Creating and Previewing Reports
Modifying Report Design
PRINTING
Printing Objects
Page Setup Options
Pre-Requisites: Participants should have basic knowledge of Windows, keyboard and mouse operations.
Certificates offered: Certificate of completion
Duration Details: 2 days
9:00am - 4:00pm
Facility Location: CompuEase Training Classroom
124 O'Connor, Suite 204
Ottawa
ON
Canada
K1P 5M9
|
