Houston | The Woodlands
(832) 693-9785
Excel Training Houston on Facebook Houston Excel Training on LinkedIn Excel Training Houston on Twitter Houston VBA Training on Google+ Excel VBA Houston Email
  • Microsoft Access: Level 1 - Beginner

  • Course length:

    1.0 day

    Course Objective:

    You will create and modify new databases and their various objects.

    Target Student:

    This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.

    Certification:

    This course is one of a series of courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft Excel-Add-In.

    Course Objectives:

    Upon successful completion of this course, students will be able to:
    • identify the basic components of an Access database
    • build the structure of a database
    • manage data in tables
    • query a database
    • design forms
    • generate reports.
  • Course Content

    Lesson 1: Getting Started with Access Databases

    1. Identify the Elements of the Access 2010 Interface
    2. Identify the Components of a Database
    3. Examine the Relational Database Design Process

    Lesson 2: Building the Structure of a Database

    1. Create a New Database
    2. Create a Table
    3. Manage Tables
    4. Establish Table Relationships

    Lesson 3: Managing Data in a Table

    1. Modify Table Data
    2. Sort and Filter Records
    3. Work with Subdatasheets

    Lesson 4: Querying a Database

    1. Create a Query
    2. Add Criteria to a Query
    3. Add a Calculated Field to a Query
    4. Perform Calculations on a Record Grouping

    Lesson 5: Designing Forms

    1. Create a Form
    2. Modify the Design of a Form
    3. View and Edit Data Using an Access Form

    Lesson 6: Generating Reports

    1. Create a Report
    2. Add a Control to a Report
    3. Format the Controls in a Report
    4. Enhance the Appearance of a Report
    5. Prepare a Report for Print

    Appendix A: Microsoft Office Access 2010 Exam 77–885