Microsoft Access 2013: 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. 

Learn how to create a variety of data tables and forms, analyze the data, and write reports. In Level 1 examine basic database concepts, create and modify databases, and be introduced to basic concepts of performing queries and building reports. 

Previous knowledge or experience: Understanding of the basics of Windows 

Target Student: 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. 

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. 

Course Objectives: 

In this course, you will learn to create and manage a fundamental Access 2013 database. You will:  

• Navigate within the Microsoft Access application environment and create a simple database. 
• Organize and manage data stored within Access tables. 
• Use queries to join, sort, and filter data from different tables. Create advanced queries, including action queries and parameter queries. 
• Create and format custom reports. 
• Customize Access configuration options. 

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