Basic Training Of Microsoft Office Access 2007

        Basic Training Of Microsoft Office Access 2007

Ø  Getting Started With Microsoft Office Access 2007

v Understanding Security

v To Enable A Database

v To Manipulate The Navigate Pane

v The Title Bar

v The Ribbon

v Access Objects

v Change Views

Ø  Creating Microsoft Access Tables
      v Understanding Tables

v To Add Fields To A Table

v Name And Save A Table

v Understanding Data Types

v To Assign A Data Type Or Format To A Field

v To Use Design View To Create A New Table

v To Set Field Properties

Ø  Create A Lookup Column

v To Use The Lookup Wizard To Create Lookup Column
v Open The Lookup Wizard

v Select Your Table Or Query

v Select Fields

v Sort Fields

v Adjust Column Widths

v Specify The Key Fields
vName The Column

Ø  Working With Microsoft Access Tables

v Enter Records

v To Enter Data Into An Auto Number Field  

v To Enter Data Into Field That Have A Lookup List

v To Enter Data Into YES/NO Field

Ø  Modify A Table

v Delete Columns

v Insert Column

Ø  Sorting ,Filtering And Creating Relationship

v Sort A Table

v To Add A Sort

v To Remove A Sort

Ø  Filter A Table

v To Apply A Filter
v To Remove A Filter

Ø  To Hide Column
v  To Create Relationship

Ø  Creating Microsoft Access Queries
v To Open A Table Or Query In QueryDesign View

Ø Display All Record And All Fields

v To Display All Record And All Fields

Ø  Change From Datasheet View To Query Design View

Ø  Retrieve A Single Column

Ø  Retrieve Multiple Column

Ø  Sort A Query

v To Perform A Sort

Ø  Sort Multiple Column In A Query

Ø  Create A Query That Uses Two Or More Tables

Ø  Save A Query

Ø  Create A Parameter Query

Ø  Creating Forms

Ø  Using Form Button

v To Create A Form

Ø  Create A Split Form

Ø  Create A Multiple Item Form

v To Change The View

Ø  Modify A Form

v To Change The Size Of Field

v To Move A Data Sheet

v To Resize A Data Sheet

v To Apply An Auto format

v To Change A Form Title

Ø  Creating Reports

Ø  Use The Report Button

If You Enjoyed This, Take 5 Seconds To Share It

• Facebook
• Twitter
• Google+
• StumbleUpon
• Digg
• Delicious
• LinkedIn
• Reddit
• Technorati