Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


Microsoft Access is a very powerful tool for storing & analyzing lists of information, but that power comes at the cost of being trickier to learn than the other parts of MS Office. This course will get you over that hurdle. You'll begin learning how you


 
Course Outline
Microsoft Access is a very powerful tool for storing and analyzing lists of information, but that power comes at the cost of being trickier to learn than the other parts of MS Office. This course will get you over that hurdle. You€'ll begin learning how your company database works by creating a simple one of your own. Then students will be taught how to pull information from databases, create forms for displaying old data on the screen as well as adding new data, and produce professional-looking printed reports.

This course is classroom style instruction: Instructor-led, hands-on training.

Overview
What is a Database?
Database Objects in Access
Creating / Opening Databases

Tables (Design View)

Creating a Table

Adding Fields

Field Data Types

Saving

Insert Fields

Moving Fields

Change Field Name

Change Field Data Type

Working with Attachments

Calculated Fields (2010/2013)

Field Size

Format & Decimal Places

Default Value

Caption

Validation Rule/Text

Required

Allow Zero Length

Indexed

Input Mask
 

Tables (Datasheet View)

Entering Data

Adding Pictures

Zoom and Line Breaks

Column Widths/Row Height

Navigating Records

Formatting Cells

Hiding Columns

Freezing Columns

Cut, Copy & Paste

Deleting Records

AutoNumbers

Sorting

Finding

Filter by Selection

Text Filters, Number Filters, Data Filters

Filter by Form

Save Filter as Query
 

Queries

Creating Queries

Adding Fields to Grid

Entering Criteria

Running a Query

Sorting and Hiding

Saving a Query

Moving Columns

Performing Calculations

Formatting Columns

Parameter Queries

Totals Queries
 

Forms

AutoForms

Split Forms

Using the Form Wizard

Design & Form Views

Layout View

Moving/Sizing Controls

Applying AutoFormat/Theme

Edit Text Labels

The Form Header/Footer

Entering Data in the Form

 

Reports

AutoReports

Using the Report Wizard
Different Views of Reports

Report Bands

Adjusting Controls

Merging Fields

Previewing and Printing

 

Working in the Navigation Pane

Rename Objects

Making a Copy

Deleting Objects
Object Properties


Prerequisites & Certificates
Pre-Requisites

Knowledge of Windows Introduction topics and ability to use keyboard and mouse. Use of one or more other programs, such as Excel or Word is recommended.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion


Cancellation Policy
A full 5 business days notice is required to change or cancel any course date.

Once payment has been received, a credit will be held in your account if we have received sufficient notice of your cancellation or date change (we do not provide refunds). If insufficient notice is received, the entire fee or Tickets for that course date will be charged.

There is no charge for substitutions. If you cannot attend your course and cannot provide the 3 business days notice, you can send someone else in your place with no penalty.

Course Retake

If you cannot provide 5 business days notice of cancellation, you may take the course at a later date at no further charge with the following conditions.

1. You must take the course within 6 months of the original course date (no exceptions). After that time, the full course fee will be charged again.

2. Registration is on a stand-by basis only. If the course date you select becomes fully booked you will be asked to choose another date, which must be within 6 months of the original course date.

3. If you need to change or cancel your free re-take course, we must receive a full 5 business days notice of the change. If insufficient notice is received, this offer no longer applies and the full course fee will be charged again, should you choose to book another date.

4. This course is not transferable to another person. It must be taken by the same person who was scheduled for the original course.

5. This offer applies to the same course only (same software program, same course level and the same software version as was originally booked).
Map & Reviews
Excel Training Toronto
[ View Provider's Profile ]

Reviews
 
Donna was an excellent trainer. She took the time to determine each person's needs and desires of why they were attending the course. She was then able to apply training towards each attendees specific needs.
Reviewed by 2013
The breaks were way to long and the course material was streched out and thus way more could of been covered in 2 days than what was covered.
Reviewed by 2013
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 2792 times.