Introduction to Microsoft Access Training'

Training Provided by Webucator This Microsoft Access training course is designed for students new to working with Microsoft Access. Students will learn to get data out of existing databases and to create their own new databases.

Introduction to Microsoft Access Training' Course Outline

• Introduction to Relational Databases and Microsoft Access
  • The Basics
    • What Is a Relational Database
    • What Types of Things Can I Do with Microsoft Access
    • Starting Microsoft Access
    • Opening an Existing Database
    • The Access Desktop
    • The Database Window
    • A Preview of the Database Components
    • Closing an Access Database
    • Viewing and Navigating Table Data
• Working with Existing Microsoft Access Databases and Objects
  • Working with an Existing Table
    • Edit Table Data
    • Add Records to a Table
    • Delete Records from a Table
    • Find and Replace Text in a Table
    • Filter Table Data
    • Modify the Appearance of a Datasheet
    • Spell-Check Your Data
    • Using the AutoCorrect Feature
  • Working with an Existing Query
    • Open a Query in Datasheet View
    • Open a Query in Design View
    • Add Fields to a Query
    • Order a Query Result
    • Refine a Query with Criteria
    • Save a Query
    • Print a Query Result
    • Close a Query
  • Working with an Existing Form
    • Open a Form
    • Work with Data
    • Find Data
    • Replace Data
    • Sort Data
    • Filter Data
    • Close a Form
    • Highlight Important Data with Conditional Formatting
  • Working with an Existing Report
    • Open and View a Report
    • Move From Page to Page
    • Zoom In and Out
    • View Multiple Pages
    • Print a Report
    • Close a Report
    • Print Database Objects
• Creating Microsoft Access Databases and Objects
  • Use Wizards to Create a Database
    • Use a Database Template to Create a Database
    • Create a New Empty Database
    • Create a Table Using the Table Wizard
    • Create a Query Using the Query Wizard
    • Create a Form Using the Form Wizard
    • Create a Report Using the Report Wizard
  • Design and Create Your Own Tables
    • About Task Analysis
    • About Database Analysis and Design
    • About Relational Database Design
    • About the Application Development Process
    • Build a New Table
    • About Selecting the Appropriate Field Type for Your Data
    • Set a Primary Key
  • Create Your Own Relationships
    • About the Types of Relationships
    • Establish Relationships
    • Establish Referential Integrity
  • Create Your Own Queries
    • Create Queries
    • Order a Query Result
    • About Refining a Query with Advanced Criteria
    • Update Query Results
    • About Building Queries Based on Multiple Tables
    • Create Calculated Fields
    • Get Help from the Expression Builder
  • Create Your Own Forms
    • Create a Form in Design View
    • Add Controls
    • About Selecting Controls
    • Move, Size, and Delete Controls
    • Align Controls
    • About Selecting the Correct Control
    • Change the Tab Order of Controls
    • About Form Properties
    • Work with Combo Boxes and List Boxes
  • Create Your Own Reports
    • Create a Report in Design View
    • About Working with Report Sections
    • About Working with Controls
    • Create Groups and Totals Reports
    • About Working with Report Properties
    • Create Reports Based on Multiple Tables

About The Training Provider: Webucator

More Access Training from Webucator

• Advanced Microsoft Access Training