To access the old site click here! X

  • Course
  • Vendor

Learn to identify the components of a database, open a table & find information stored in it, create & customize table designs, enter data & validate using input validation formulas, create relationships between tables to ensure data accuracy....

  • Course Start Date: 2019-01-23
  • Time: 09:00:00 - 16:00:00
  • Duration: 2 Days
  • Location: Edmonton
  • Delivery Methods(s): Instructor Led
$300.00
January 23rd
2 seats left!
or make an offer

Course Outline

Pre-Requisites

Good understanding of Windows and Microsoft software.

Lessons

Students enrolled in this course will learn to identify the components of a database, open a table and find information stored in it, create and customize table designs, enter data and validate using input validation formulas, create relationships between tables to ensure data accuracy and deploy referential integrity. Other topics include creating forms for entering data into tables, creating, editing, running queries, creating, enhancing, and previewing reports, and importing/exporting data to and from various sources.

Course Content
The Basics
  • Database Concepts
  • Creating a Database
  • Converting Access Files
  • Working with Objects
  • Using Access 2010 Help
Table Data
  • Table Concepts
  • Viewing Data in a Table
  • Changing the Datasheet Appearance
  • Entering and Editing Data
  • Applying Filters
Table Design
  • Creating a Table
  • Changing the Table Design
Data Entry
  • Data Entry Concepts
  • Data Formats
  • Input Masks
  • Input Validation
  • Adding Records
Relationships
  • Relationships Between Tables
  • Creating a Relationship
  • Referential Integrity
  • Removing a Relationship
  • Printing Relationships
Creating and Using Forms
  • Creating a Form Using AutoForm
  • Creating a Form Using the Form Wizard
  • Creating a Form in Design View
  • Opening a Form
  • Changing a Form Design
  • Adding Controls
  • Placing Controls
  • Multiple-Choice Controls
  • Error Checking
Queries
  • Using the Query Wizard
  • Creating a Query in Design View
  • Selecting and Sorting in a Query
  • Calculations
  • Action Queries
  • Parameter Queries
Reports
  • Creating Reports
  • Using the Report Wizard
  • Previewing Reports
  • Creating Reports in Design View
  • Changing Report Design
  • Control Operations
  • Control Attributes
Importing and Exporting Data
  • Importing and Exporting
  • Importing a Text File
  • Importing Data from an Access Database
  • Exporting Data
  • Troubleshooting Importing and Exporting Problems
Printing
  • Printing Objects
  • Print Preview

Cancellation Policy

10 business days cancellation or full course fee will be charged

Training Location

TTC, B-11 Cameron Library
11320-89 Avenue, University of Alberta

Edmonton, Alberta
Canada   

About Technology Training Centre

x

Technology Training Centre is THE place for computer software training in Alberta.
This is where you come to learn how to get more from the computer or the mobile device in front of you.
Register for courses on Microsoft Office and the Adobe Creative Suite along with customized one on one or group training.
Come to the heart of the University of Alberta campus to learn from our instructors. These highly skilled professionals will also travel across the province to deliver exceptional training for you and your company.
We have your MS Office needs covered, including training on upgrading to a newer version of the software. We offer courses in Microsoft Word, Excel, PowerPoint, Access, SharePoint, Publisher, SQL, Visio, Project, Outlook, OneNote, and InfoPath.
Our graphic designers will train you in Adobe Photoshop, InDesign, Illustrator, Dreamweaver, Acrobat, Lightroom, and Visual Design. If you need training for your digital camera, we’ll provide that as well.

You will also receive:
•    6 months of email support on courses.
•    The option to retake courses within 6 months at no additional charge.
•    Training from instructors that use each of the software packages they teach and have the ability to go beyond what is covered in the outline.
 

Training Provider Rating

This vendor has an overall average rating of 4.38 out of 5 based on 195 reviews.

The course was excellent, the instructor Rachel was great.
No comment
No comment
Was a very informative course.
No comment
My payments were taken care of by last minute training with the University of Alberta. The teacher was good, the content was good.
I already completed a survey at the end of the course so not sure why I have to complete another survey on line? LOL
No comment
No comment
No comment
The information learned in this course will assist me in my current role. Enjoyed the class.
No comment
I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unf ... Read more
x

I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unfortunately all my notes are in the beginning of the book as we, only looked it once, when a student asked what page we were on.

No comment
More useful contents can be fit in and taught in this class definitely.
No comment
Worthwhile training that provided me with the skills needed to use Onenote.
No comment
No comment
I had a lot of knowledge on the course I took but I still learned a few new things which is really nice to come out of a course le ... Read more
x

I had a lot of knowledge on the course I took but I still learned a few new things which is really nice to come out of a course learning something. Thanks for the informative day. Doreen

Course Reviews

This course has an overall avarage rating of 4.25 out of 5 based on 3 reviews.

Previous

Aaron Campbell attended this course Feb 2015

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Becky Reynolds attended this course Aug 2013

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Jim Yarn attended this course Dec 2012

Facilities

Course Content

Delivery Structure

Instructor Ability

The course enlighted me on the basic structure of Access with tables, queries, & forms. However macros were not covered, which a large port... Read more
x

The course enlighted me on the basic structure of Access with tables, queries, & forms. However macros were not covered, which a large portion of our database. Perhaps they are covered on a subsequent course.

Next

More Courses from Technology Training Centre

TECHNOLOGY TRAINING CENTRE
2019-03-06
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-01-11
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-03-04
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-03-04
Edmonton

More Courses in 'Microsoft Access Training Seminars and Courses' Category

TECHNOLOGY TRAINING CENTRE
2019-02-25
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-02-07
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-02-07
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-01-23
Edmonton