Provided by: Last Minute Training

Access 2003 Introduction 2 Days

Access

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
Course Level:introductory
Duration:2 days
Training Presented in:English
Training Provided by Last Minute Training
  • V asked: What route in training provides developmental proficiency in Access.
  • C asked: Would you please give me details of this course: where it is held: the cost of the course.
  • D asked: how to implement Access in the Business environment effectively.
Access 2003 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...
Want to market your access training?
Custom Search
tcw11-v473M-08/23/11-03:37:10-()[A]-[A]-[A] -11:04:39