Access 2013: Part 1

COURSE OUTLINE:

Description A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Audience
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2013, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

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: Sort and Filter Records
  • Topic C: 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 Unmatched and Duplicate 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