Custom Search
Provided by: Last Minute Training

Access 2007 Introduction 2 Days

Access

Last Minute Training
Training Provided by Last Minute Training This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. 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:basic
Duration:2 days
Training Presented in:English
Access 2007 Introduction 2 Days 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
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
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
Design & Form Views
Moving/ Sizing Controls
Edit Text Labels
The Form Header/ Footer
Entering Data in the Form

Reports
AutoReports
Report Bands
Adjusting Controls
Merging Fields
Previewing and Printing

Database Objects
Rename Objects
Making a Copy
Deleting Objects
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...
Sell microsoft access training?
tcw11-gfc-v396M-11/06/09-21:58:04-()[B]-[A]-[A] -07:53:44