Microsoft Access 2010 - Level 1

Unlock the power of data management with our Microsoft Access 2010 Level 1 course, crafted for professionals eager to master database creation, management, and reporting.

Course Thumbnail

Essential Skills Gained

Checkmark

Identify components of the Access 2010 environment.

Checkmark

Organize and manage data in tables.

Checkmark

Query databases effectively.

Checkmark

Design forms and generate insightful reports.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Database Designers
  • Data Management Professionals
  • Business Analysts
  • IT Staff

Description

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

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Lesson 1: Getting Started with Access 2010

  1. Identify the Elements of the User Interface

  2. Identify the Tabs and Commands on the Ribbon

  3. Obtain Help in Access

Lesson 2: Identifying the Components of a Database

  1. Define Database Concepts

  2. Identify the Components of a Database

  3. Examine the Relational Database Design Process

Lesson 3: Organizing Data in Tables

  1. Create a Table

  2. Modify Table Data and Properties

  3. Create a Table Relationship

Lesson 4: Viewing Data in Tables

  1. Sort Records

  2. Filter Records

  3. View Data from Related Tables

Lesson 5: 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 6: Designing Forms

  1. Create a Form

  2. View Data Using an Access Form

  3. Modify a Form

Lesson 7: Generating Reports

  1. View an Access Report

  2. Create a Report

  3. Add a Calculated Field to a Report

  4. Format the Controls in a Report

  5. Apply a Theme to a Report

  6. Prepare a Report for Print

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.