Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 5


This Course is designed for participants who have little or no knowledge of MS Access.

  • Course Start Date: Sep. 13
  • Location: Ottawa (Map)
  • Time: 9:00 am - 4:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 2 Days
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Seats Available: YES
  • Category:Microsoft Access Training Seminars and Courses

 
Course Outline
This Course is designed for participants who have little or no knowledge of MS Access.

Course Length: 12hrs (2 Days)
 
Access is a relational database program which enables you to design and create tables to form a logical database. With Access, you can build simple queries, create forms and design basic reports from your tables. Access makes data easy to use, find and display. 
 
Learning Objectives:
In this course, you will design and create tables, queries, forms and reports. You will:
- Gain understanding on the concept of a relational database
- Use design properties to create tables
- Use tables to create queries
- Use tables and queries to generate forms and reports
- Print tables, forms and reports
 
Target Student:
This course is for individuals who are new to the concept of database design and use. Students should have basic computer skills (typing). Previous use of data arrangement, i.e. tables in Word or columns and rows in Excel is useful but not required. 
 
Course Outline:
DAY 1
Section 1: Getting Started
Lesson 1.1: Starting Out
Lesson 1.2: Interface Basics
Lesson 1.3: Database Security
Lesson 1.4: Getting Help
 
Section 2: The New Interface
Lesson 2.1: The Quick Access Toolbar
Lesson 2.2: Basics of Tabs
Lesson 2.3: The Home Tab
Lesson 2.4: The Create Tab
Lesson 2.5: The External Data Tab
Lesson 2.6: The Database Tools Tab
 
Section 3: Creating a Database
Lesson 3.1: First Steps
Lesson 3.2: About Records
Lesson 3.3: Creating a Table
Lesson 3.4: Formatting Text
 
Section 4: Doing More with Your Database
Lesson 4.1: Creating and Using Forms
Lesson 4.2: Creating and Using Queries
Lesson 4.3: Creating and Using Reports
Lesson 4.4: Sorting and Filtering Data
Lesson 4.5: Viewing Data
Lesson 4.6: Printing a Database Object
 
 DAY 2
Section 1: Advanced File Tasks
Lesson 1.1: Using Windows Explorer within Access
Lesson 1.2: Database Management
Lesson 1.3: Saving Your Files
Lesson 1.4: Exporting Files
Lesson 1.5: Linking Files
 
Section 2: Working with Tables
Lesson 2.1: Customizing Tables
Lesson 2.2: Formatting Tables
Lesson 2.3: Controlling Table Data Entry
Lesson 2.4: Managing Table Data Entry
 
Section 3: Working with Forms
Lesson 3.1: Basic Form Controls
Lesson 3.2: Advanced Form Controls
Lesson 3.3: Formatting Your Form
Lesson 3.4: Formatting Controls
Lesson 3.5: Using Themes
 
Section 4: Working with Reports
Lesson 4.1: Organizing Report Data
Lesson 4.2: Formatting Reports
Lesson 4.3: Common Report Tasks
 
Section 5: Working with Queries
Lesson 5.1: Basic Queries
Lesson 5.2: Doing More with Queries
Lesson 5.3: Creating Advanced Queries
Lesson 5.4: Creating Management (Action) Queries

Prerequisites & Certificates
Pre-Requisites

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

Certificates offered

Training includes 1 course manual, a Certificate of completion, and a voucher for 30 days of After Training Support


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 ]

CompuEase Training Classroom
130 Albert Street
Suite 801

Ottawa, ON
Canada   K1P 5G4


Reviews
 
Introduce a two-hour free exercises. I like to explore and them ask questions if needed.
Reviewed by 2014
no
Reviewed by 2013
13-September-2017 $635 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:

This page has been viewed 25 times.