Microsoft Access, Level 1

Session Detail:    Classroom, Virtual 2013, 2016, Office 365 1 Day

Session Detail:

Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user.

This course is intended to help all novice computer users get up to speed quickly. It will also help more experienced users who have little to no experience with Microsoft Access and databases in general.

What You’ll Learn

  • Getting Started with Access
  • Working with Table Data
  • Querying a Database
  • Creating Advanced Queries
  • Generating Reports
  • Customizing the Access Environment
  • Designing a Relational Database
  • Joining Tables

Session Outline

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Work with Records

Topic C: Sort and Filter Records

Topic D: Create Lookups

Lesson 3: Querying a Database

Topic A: Join Data from Different Tables in a Query

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Create Action Queries

Topic C: Create Find Duplicate and Find Unmatched Queries

Topic D: Summarize Data

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Lesson 6: Customizing the Access Environment

Topic A: The Access Options Dialog Box

Lesson 7: Designing a Relational Database

Topic A: Relational Database Design

Topic B: Create a Table

Topic C: Modify a Table and Fields

Topic D: Create Table Relationships

Lesson 8: Joining Tables

Topic A: Create Query Joins

Topic B: Join Tables That Have No Common Fields

Topic C: Relate Data within a Table

Topic D: Work with Subdatasheets

Topic E: Create Subqueries

Lesson 9: Organizing a Database for Efficiency

Topic A: Data Normalization

Topic B: Create a Junction Table

Lesson 10: Sharing Data Across Applications

Topic A: Import Data into Access

Topic B: Export Data to Text File Formats

Topic C: Export Access Data to Excel

Topic D: Create a Mail Merge

Lesson 11: Advanced Reporting

Topic A: Organize Report Information

Topic B: Format Reports

Topic C: Include Charts in a Report

Topic D: Add a Calculated Field to a Report

Topic E: Add a Subreport to an Existing Report

Lesson 12: Additional Reporting Options

Topic A: Create a Mailing Label Report

Topic B: Publish a Report as PDF

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Call Back
reCAPTCHA
DateTimeTypePriceAdd To Cart
Dec 13, 20199:00AM-4:00PM ESTClassroom$265.00
Dec 13, 20199:00AM-4:00PM ESTVirtual$265.00

Microsoft Access, Level 1

1 Day
Classroom, Virtual

$265.00

Clear

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now