Custom Search
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Access 2003 Intermediate Level 1 (3 Days)
Provided by: Last Minute Training

Access 2003 Intermediate Level 1 (3 Days)

Access

 Last Minute Training
Training Provided by Last Minute Training 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.
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:intermediate
Duration:3 days
Training Presented in:English
Access 2003 Intermediate Level 1 (3 Days) 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
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Click here for more information or to take this course
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Access 2003 Intermediate Level 1 (3 Days)
Advertise With Us
Want to Sell More microsoft office access 2003 training?
This page was last updated on sb5- 10/10/08 at 14:15:06 - 12:00:03