Course Description
A relational database application such as Microsoft Access can help you and your organization collect and manage large amounts of data. You can use Microsoft Access as a personal data management tool, or you can use it as a construction set to develop applications for an entire department or organization. In the Microsoft Access Introduction Training course, you will learn how to use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Objectives
Upon successful completion of the Microsoft Access Introduction Training course, you will learn to:
• 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.
Agenda
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