Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


In this course, you will examine the basic database concepts, by working with and modifying databases and their various objects using the Microsoft Office Access 2010 relational database application.

  • Course Start Date: Oct. 3
  • Location: Winnipeg (Map)
  • Time: 8:30 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: 1 Day
  • 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.
  • Discount Seats Available:Please call to get on waiting list
  • Category:Microsoft Access Training Seminars and Courses

 
Course Outline
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, by working with and modifying databases and their various objects using the Microsoft Office Access 2010 relational database application.

Course Objective:
You will create and modify new databases and their various objects.

Target Student:
This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2010 can also take this course.

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Course Content
Getting Started with Access Databases

  • Identify the Elements of the Access 2010 Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process
Building the Structure of a Database
  • Create a New Database
  • Create a Table Using the Design View
  • Manage Tables
  • Establish Table Relationships
Managing Data in a Table
  • Modify Table Data
  • Work with Subdatasheets          
Querying a Database
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
Designing Forms
  • Create a Form
  • Modify the Design of a Form
  • View and Edit Data Using an Access Form
Generating Reports
  • Create a Report
  • Add a Control to a Report
  • Format the Controls in a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print 

Prerequisites & Certificates
Pre-Requisites

Students should have completed the following courses or possess equivalent knowledge before starting this course:
Windows XP: Introduction
Windows XP: Level 1
Windows XP: Level 2
Windows 7

Certificates offered

Certificate of Completion


Cancellation Policy
Cancellation Policy & Satisfaction Guarantee
You may cancel or reschedule your registration without penalty up to 5 business days before your class date.

F.A.Q's...
Training Details
ASAP Training Ltd. is located at 950 - 167 Lombard Avenue, in Exchange District. A training manual is provided. We encourage all students to bring in a USB stick for student files as we no longer hand out course files on a CD.

Finding Us
ASAP Training Ltd. is located in the picturesque downtown Exchange District at 950-167 Lombard Avenue, in the Grain Exchange Building, you can access the building from Rorie Street and Lombard Avenue.

Class Times and Other Details
ASAP Training Ltd. classes begin promptly at 8:30 am and end around 4:00 pm. Our doors open at 8:00 am. Coffee and tea are provided for students. We have a kitchen with a microwave and refrigerator available for student use if they wish to bring their own lunch. Lunch break is one hour from approximately 11:30 to 12:30. A telephone and sitting area are available for student use. Our office is a non-smoking facility and is wheelchair accessible.

Restaurants
There are many restaurants available within walking distance of the school.

Parking
For your convenience, we have also provided a map of the available Parking Lots in proximity to the Grain Exchange Building, indoor and outdoor parking.
http://www.grainexchangebuilding.com/leasing/parking.html
Map & Reviews
ASAP Training.ca
[ View Provider's Profile ]

ASAP - New Location
950 167 Lombard Avenue
Winnipeg, MB
Canada   R3B 0V3


Reviews
 
Require more time, I suggest this training to be 2 days instead of one. Overall I learned a lot and it was very interesting and informative.
Reviewed by 2015
the more hands on an attendee can do - the easier it is to learn
Reviewed by 2015
I was the only person in the course so the instructor was able to customize the class for my exact needs - it was better than I hoped. Thanks for not cancelling it due to low enrollment!!
Reviewed by 2015
The only negative things were the initial room was chilly and there was a problem with their new server. We were able to switch rooms which was better. They managed to rectify the problem with the server enough so we finished the course content - a little rushed at the end. But they do offer a 6 month reset where you can go back and take the course for free (when it is offered)if you are having problems.
Reviewed by 2014

 

This course has no remaining discount seats

This course may be available on a different date listed below.
 

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 29 times.