Access 2013 - Part 1

Course details

In this course, students will learn how to use Access 2013 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data

Lessons

Lesson 1: Getting Started with Access

• Orientation to Microsoft Access 
• Create a Simple Access Database 
• Get Help in Microsoft Access

Lesson 2: Working with Table Data

• Modify Table Data 
• Sort and Filter Records 
• Create Lookups 

Lesson 3: Querying a Database

• Join Data from Different Tables in a Query 
• Sort and Filter Data in a Query 
• Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

• Create Parameter Queries 
• Create Action Queries 
• Create Unmatched and Duplicate Queries 
• Summarize Data

Lesson 5: Generating Reports

• Create a Report 
• Add Controls to a Report 
• Enhance the Appearance of a Report 
• Prepare a Report for Print

Lesson 6: Customizing the Access Environment

• The Access Options Dialog Box 

Lesson 7: Designing a Relational Database

• Relational Database Design 
• Create a Table 
• Create Table Relationships

Lesson 8: Joining Tables

• Create Query Joins 
• Join Tables That Have No Common Fields 
• Relate Data within a Table 
• Work with Subdatasheets 
• Create Subqueries 

Lesson 9: Organizing a Database for Efficiency

• Data Normalization 
• Create a Junction Table 
• Improve Table Structure

Lesson 10: Sharing Data Across Applications

• Import Data into Access 
• Export Data to Text File Formats 
• Export Access Data to Excel 
• Create a Mail Merge

Lesson 11: Advanced Reporting

• Organize Report Information 
• Format Reports 
• Include Control Formatting in a Report 
• Add a Calculated Field to a Report 
• Add a Subreport to an Existing Report