Access 2007

CBIT Canadian Beaver Training Ottawa
Ottawa, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' Module 0: Prerequisites
| Ability To Create Folder
Save a File To Folder
Efficient Use of Mouse and Keyboard


| Module 1: Exploring Access
| What Is Ms Access
Opening Access
How To Plan and Design Access Database
What Is Normalization
Interface Overview
Understanding Access Objects
Navigating Access


| Module 2: Getting Help
| Using the Online Help
Using the F1 Key


| Module 3: Using the Trust Center
| What Are Warnings
Enable Content
About Digital Signatures
About Trust Locations
Open the Trust Center
Assign a Password To the Database


| Module 4: Using the Getting Started Window
| Exploring the Window
Creating a Database From a Template
Creating a Blank Database


| Module 5: Working with Tables
| Using Datasheet View
Navigating Fields in Tables
Adding Records
Selecting Records
Editing Records
Deleting Records


| Module 6: Editing Tables
| Changing the Row Height and Column Width
Changing Format
Selecting, Moving and Hiding Columns
Freezing Columns


| Module 7: Creating Tables
| Creating a New Database
Adding a Field Description
Setting a Primary Key
Using the Table Wizard
Normalizing Tables
Designing Tables
Creating a Table in Design View
Using Design View
Adding Field Names
Using Prefixes
Assigning Data Types


| Module 8: Setting Field Properties
| Using Field Properties
Limiting Field Size
Setting Number Formats
Setting Date/time Formats
Setting Yes/no Formats
Setting Default Values
Setting Validation Rules
Creating An Input Mask


| Module 9: Creating Relationships
| Creating a Relationship Between Tables
Rules for Setting Referential Integrity
Exploring Cascading Update and Delete Options
Deleting a Relationship


| Module 10: Importing and Exporting Data
| Exporting Data To An Excel Workbook
Dragging and Dropping Data Into Excel
Creating Excel Workbooks - Office Links
Creating Word Documents - Office Links
Importing Data in Access
Linking From An Other Application


| Module 11: Finding and Filtering Data
| Sorting Records
Finding Specific Records
Finding Records Using Wildcards
Using Replace
Using Filter By Selection
Applying/removing a Filter
Using Filter Excluding Selection
Using Filter For
Using Filter By Form


| Module 12: Using Simple Queries
| Using the Select Query Wizard
Creating a Query in Design View
Understanding the Qbe Grid
Hiding a Field in a Query
Adding a Table To a Query
Joining Tables in a Query
View a Select Query
Using Totaling Queries (s
Add a Calculated Field


| Module 13: Modifying Query Results
| Sorting a Query
Adding Criteria To a Query
Printing a Query


| Module 14: Using Operators in Queries
| Using Comparison Operators
Using An And Condition
Using An Or Condition
Using the Between and Operator
Using a Wildcard Character


| Module 15: Creating Basic Forms
| Creating Forms
Using Autoform, Using the Form Wizard and Manual Forms
Navigating in Forms
Viewing Records in a Form
Printing Records in a Form
Adding a Record Using a Form
Creating Basic Reports


| Module 16: Using Reports
| Using Autoreport, Using the Report Wizard and Manual Reports
Using Print Preview - Reports
Printing Pages of a Report
Basing a Report On a Query

...''

Elements of this syllabus are subject to change.

Phone:613 742-6800

School Address/Venue(s):

CBIT Canadian Beaver Training Ottawa
214 Montreal Rd
Suite 100
Ottawa, Ontario
K1L 8L8
Canada

Jobs & Resumes: Ottawa
Houses & Roommates: Ottawa
Travel Agencies: Ottawa

Search other schools for Access 2007 training resources.

Corel Knockout
Corel Painter
Corel Presentations
Corel Ventura
Corel Wordperfect
Crystal Reports
Approach Millennium
Lotus 123
Lotus Freelance Graphics Millennium
Lotus Wordpro
Excel 2007
Infopath 2007
Project 2007
Onenote 2007
Outlook 2007
Powerpoint 2007
Publisher 2007
Visio 2007

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.