Testimonials
Collette McBride
Date: Feb 04, 2010
Wil is very receptive to questions and willing to meet needs of group
|
|
Register | Course Schedule | Course Outline | Instructors | FAQ | OnSite Training
Details |
|
|
Duration
1 Day |
|
Class Size
~15 |
 |
Times
9:00-4:00 |
 |
Computer
Provided |
 |
Training Manual
Included |
 |
Price
$235.00 + GST |
|
Course Description Many of today’s companies rely on the ability to track and manage their important data and to be able to report on it and share it in a controlled environment. The Microsoft Access course is designed to introduce students to the world of relational databases inside of Microsoft Office Access. The course will provide student with the knowledge necessary to track and manage that data both effectively and efficiently. Target Audience This course is ideal for people new to Access who need to manage, sort and view large amounts of data. The course will provide the necessary skills to become proficient in the basics of the program. No prior knowledge of Microsoft Access is required, however a general understanding of computers and Windows is beneficial. Learning Objectives Upon successful completion of this Access training course students will be able to:
- Understand the fundamental terminology of the program
- Be able to find help in the program and other important product information
- Understand Relational databases
- Open and Navigate the Microsoft Access program
- Add and Manage Data in an Access database.
- Examine existing Table relationships.
- Understand and write a Database Query
- Create and Customize Forms
- Create and Modify reports
|
|
|
|
Upcoming Classes |
|
|
|
|
Course Outline |
Morning Introduction to Access
- Understanding the Terminology
- Understand the Layout of Access
- Menus, Buttons & Using the Ribbon
- Understanding Tables & Forms
- How to Style your Databases
Going deeper into Access
- Examine an Access Database
- Create Tables and Forms
- Create & Edit a Database
- Saving your work
- Import/Export
- Create Relationships
- Create and Use Macros
Using Templates
- Create from a template
- Edit a template
- Create and Save your own template
Creating Records
- Adding information manually
- Importing from other Office Programs
|
Afternoon More Access Tools
- Using the Navigation Pane
- Inserting Forms & Tables
- Backup and Restore Databases
- Form Design
Review, Report & Compare
- Spell check your work
- Use the Thesaurus
- Create Reports Manually and Automatically
Protect & Share your work
- Watermarking
- Protecting a Document
- Encrypting your Databases
- Publish, Print, and Share
Create Your Own Project Students will create an Access Project based on their own choice of template. It is suggested it be based on work or home to benefit the students understanding of Access. |
|
Instructors |
 |
Wil Cleland is a young entrepreneur and computer technician who draws on over 8 years of computer repair and consulting experience. As a Registered Microsoft Partner he has had the opportunity to utilize the training offered to enable him to understand Microsoft Products from the ground up. As an owner and administrator of his own small business he understands the importance of professional training when it comes to efficiently producing high quality reports within the office.
Through Primer Business Solutions, Mr. Cleland will share his knowledge and experience within the Microsoft Office Suite. His passion for computers and his love of teaching, enable students to gain an in depth understanding for how to use Microsoft products productively and efficiently. Mr. Cleland’s offers a wealth of knowledge and personal experience for his students to draw on and grow from.
|
|
//
Register OnlineTo begin registration, please select the date you would like to attend.
|
|
