MS Access Course

 Contents

· Module 1    :     INTRODUCTION

· Module 2    :     DATA TYPE

· Module 3    :     TABLES

· Module 4    :     QUERY

· Module 5    :     FORMS

· Module 6    :     REPORTS

· Module 7    :     LABELS

· Module 8    :     MACRO

· Module 9    :     EXTERNAL DATA

· Module 10  :   RELATIONSHIP

Introduction

• Introduction
• Interface
• Tabs and Ribbons
• Document Windows
• Navigation Tips
• Office Button and Save

DATA TYPE

• Data Type Property uses & Settings-

• Text
• Memo
• Number
• Date /Time
• Currency
• AutoNumber
• Yes/No
• OLE Object
• Hyperlink
• Attachment
• Lookup Wizard.

TABLES

Datasheet View

Design View

• Create Table
• Templates
• Contacts
• Tasks
• Issues
• Events
• Assets

QUERY

Query Wizard

• Simple Query Wizard
• Crosstab Query Wizard
• Find Duplicates Query Wizard
• Find Unmatched Query Wizard

Query Design

• Create Query 

FORMS

Form Wizard

• Columnar
• Tabular
• Datasheet
• Justified

Form Design

• Split Form
• Multiple Items
• Design View
• Layout View

REPORTS

Report Wizard

• Columnar
• Tabular
• Justified

Report Design

• Blank Report
• Design View
• Layout View

LABELS

Label Wizard

• Create Label

Macros

Create Macro

• Macro Name
• Action
• Arguments
• Table / Query / Form /Report Name
• View-Datasheet, Design, Print Preview
• Mode- Add, Edit, Read Only

External Data

Import

• Import Access Database
• Import Excel Spreadsheet
• Import Text File
• Import HTML Document

Export

• Export to Excel Spreadsheet
• Export to RTF File
• Export to Text File
• Export to Access Database
• Export to HTML Document

RELATIONSHIP

• One-to-One Relationship
• One-to-Many Relationship
• Many-to-Many Relationship