Last Minute Training – Discount prices for computer training and other training seminars.

LOG IN
Username:
Password:
Lost password?


	Search Training by Key Word and Region		Browse Training Category Lists

by Key Word

Narrow By Location

For better results use common search operators to refine your search
For example: +excel 2003 will give different results than excel 2003

MS Access Level 1 Training Seminar (2 Days)

Location: City of Mississauga Date: 2010-07-13
List Price: $495 Offered Price: $396.00
Seats Available: 2

TCET ~ Microsoft Training ~ Adobe Training ~ Macromedia Training Cancellation Policy

Description: This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other applications, modify table design to control data entry, find data, filters, queries, customize forms and reports, and create data access pages.

CORE TOPICS

An Overview of Access 2003	Managing Data
Understand relational databases Examine the Access environment Open the database environment Examine an Access table	Examine an Access form Add and delete records Sort records Display record sets Update records Run a report
Establishing Table Relationships	Querying the Database
Identify table relationships Identify primary and foreign keys in the relationships windows Work with subdatasheets	Create a select query Add criteria to a query Add a calculated field to a query Perform a calculation on a record grouping
Creating Flexible Queries	Designing Forms
Set select query properties Create parameter queries Create action queries	Examine form design guidelines Create a form using AutoForm Create a form using the Form Wizard Modify the Design of a Form
Producing Reports	Planning a Database
Create an AutoReport Create a report by using the Wizard Examine a report in Design View Add a calculated field to a report Modify the format properties of a control AutoFormat a report Adjust the width of a report	Design a relational database Identify database purpose Review existing data Determine fields Group fields Group fields into tables Normalize the data Designate primary and foreign keys
Building the Structure of a Database	Controlling Data Entry
Create a new database Create a table using a Wizard Create tables in Design View Create relationships between tables	Restrict data entry with field properties Create an input mask Create a lookup field
Finding and Joining Data	Improving Your Forms
Find data with filters Create query joins Join unrelated tables Relate data within a table	Enhance the appearance of a form Restrict data entry in forms Add command buttons Create a subform
Customizing Your Reports	Expanding the Reach of Your Data
Organize report information Set report control properties Control report pagination Summarize information Add a subreport to an existing report Create mailing labels	Publish Access data as a Word document Analyze Access data in Excel Merge Access data with a Word document

Pre-Requisites:

Computer Basics

Certificates offered:

Certificate of Completion

Duration Details:

2 Days
9:00am - 4:00pm

Facility Location:

HBI College
190 Robert Speck Parkway
Mississauga
Ontario
Canada
L4Z 3K3

Back to Search Results

This listing has been viewed 61 times.

For more information or to register call: 1-877-313-8881

	Need more information? Would you like assistance finding or booking a training course? Contact us at 416-628-8645 or at info@lastminutetraining.ca. About Us \| Member Benefits \| Vendor Benefits \| Articles \| Categories \| Association Directory \| Trainer Directory \| Training Seminar and Workshop Marketing and Promotion Services \| Training for Small Business \| How to Market Seminars \| Blog