MS Access Course

Introduction into Microsoft Access

Getting Started

• A few terms
• Getting started
• Starting Up Microsoft Access
• Blank Access database
• Access database wizards, pages, and projects
• Open an existing database
• Converting to Access 2003
• Creating New, and Opening Existing Databases
• Creating a database using a wizard
• Creating a database  without using a wizard
  

Screen Layouts

• Database window
• Design view
• Datasheet view

Creating Tables

• Introduction to tables
• Tables - What they are and how they work
• Create a table from scratch in Design view
• Field properties
• Primary keys
• Foreign keys
• Switching Views
• Indexes
• Field validation rules
• Entering Data
• Manipulating Data
• Advanced Table Feature Examples
  

Datasheet Records

• Adding records
• Editing records
• Deleting records
• Adding and deleting columns
• Resizing rows and columns
• Freezing columns
• Hiding columns
• Finding data in a table
• Replace
• Check spelling and AutoCorrect
• Print a datasheet

Importing and linking

Table Relationships

• Declaring table relationships
• Relationships - How to link multiple tables together
  

Sorting and Filtering

• Sorting
• Filter by selection
• Filter by form
• Saving a filter
• Remove a filter

Queries

• Introduction to queries
• Create a query in design view
• Query wizard
• Find duplicates query
• Delete a query

Forms

• Forms - What they are and how they work
• Create a form using the wizard
• Create a form in Design View
• Adding records using a form
• Editing forms

 
Form Controls

• List and combo boxes
• Check boxes and option buttons
• Command buttons

Subforms

• What is a subform?
• Create a form and subform at once
• Subform wizard
• Drag-and-drop method

More Forms

• Multiple-page forms using tabs
• Conditional formatting
• Password text fields
• Change control type
• Multiple primary keys

Reports

• Reports - What they are and how they work
• Creating A Report Using A Wizard
• Create in Design View
• Printing reports
• Creating Mail Merge Labels using aWizard
  

Importing, Exporting, Linking

• Importing
• Exporting
• Linking

Keyboard Shortcuts

ODBC

VB Scripting

Total duration of the course : 24 hours
3 Classes of 8 hours each.
9:00 - 17:00
Rs 8100 per participant.
Minimum 5 participants.