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

                      No comments:

                      Post a Comment