Microsoft® Access® 2013: Level 1

Duration:

1 Day (6.5 instructional hours)

Access 2013

Course Number: 091004

Course Objective:

Upon successful completion of this course, you will be able to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Target Student:

This course is intended 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.

Course Objective:

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows 8 or 8.1 environment and be able to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders. To obtain this level of skill and knowledge, you can take any of the following courses:
 Using Microsoft Windows 8.1
 Introduction to Personal Computers

Course 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: 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