Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


This three-day course takes an in-depth look at three topics: relating tables, creating forms and creating reports. We look at relating tables, then how to create queries, forms and reports that are based on related tables.


 
Course Outline

 

This course builds on the two-day Introduction course.  The objective is to learn enough about Access to start developing databases.  The Introduction course begins this process by seeing how to create tables and queries.  This course illustrates how to create a relational database and how to design forms and reports.

 

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

Create an Employee Form without the Wizard
Add Controls
Move Controls
View Records
Select & Align
Fonts & Size
Size Controls
Save Form
Undo Changes
Change Label Text
Text Alignment
Control Properties
 Format
 Status Bar Text
 Control Tip Text
 Validation Rule
 Input Mask
Adding Text Labels
Adding Formulas
Creating Combo Boxes
Form Header / Footer
Adding Command Buttons
Form Properties
Lines & Rectangles
Tab Control
Using a Form
Sorting Records

Customers & Contacts
Creating a Contacts Table
Viewing the Customer Table
Creating an Append Query
Setting a Primary Key
Relating Two Tables
Referential Integrity
Cascade Update/Delete
Testing the Relationship
Creating a Contacts Sub Form
Creating a Customer Main Form
Adding a Sub Form to a Main Form
Testing the Completed Form

Entering / Viewing Sales Orders
Determining the Tables Needed
Adding Primary Keys to Tables
Creating Additional Tables
Relating the Tables
Creating a Sub Form for Orders
Creating a Main Form for Orders
Adding a Sub Form to a Main Form
Setting a Form Record Source
More Complex Combo Boxes
Form Header / Footer

Customers By Province Report
without the Wizard
Report Bands
Set Sorting & Grouping
Adding Fields
Aligning Controls
Counting Customers
Adding Lines
Changing Fonts
Page Setup (margins,etc.)

Sales by Customers Report
without the Wizard
Basing a Report on Multiple Tables
Sorting & Grouping
Adding Fields
Format & Align
Creating Formulas
Adding Lines
Formatting Controls
Changing Fonts
Changing Alignment

Creating Envelopes
Adding Fields
Setting the Paper Size
Setting Orientation
Setting Margins
Adding Fields
Merging Fields
Omitting Blanks
Adding Page Breaks

Creating Labels
Using the Wizard
Choosing Label type
Viewing Wizard Settings
Making Changes

Merging with Word
Sending Customer Data to Word
Creating a Word Main Document
Merging the Document

Import & Export
Import an Excel File
Link to an Excel File
Export a Table/Query to Excel

 

 
Prerequisites & Certificates
Pre-Requisites

Course Prerequisite: Required: Solid understanding of all Access Introduction topics.

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

Map & Reviews
Computer Help
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

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 334 times.