Microsoft Access 2013: Level 1

Length: 1 day(s) | Audience: Information Worker | Level: 1

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.

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

 

To ensure success, students should be familiar with using personal computers, and should have experience using a keyboard and mouse. Students should be comfortable in the Windows® 8 environment, and be able to use Windows 8 to manage information on their computers. Specific tasks the students should be able to

Perform include: launching and closing applications, navigating basic file structures, and managing files and folders. To

meet this prerequisite, you can take any one or more of the following Logical Operations courses:

  • Using Microsoft® Windows® 8
  • Microsoft® Windows® 8 Transition from Windows 7