Microsoft Access 365 Part 1

In this course, students will learn how to get started with Microsoft Access, along with the components that are included in a database.

In this course you will learn about:

• What Microsoft Access is
• The components that are included in a database
• Creating a simple database
• Creating a simple form

Course Topics:

Lesson 1: Getting Started

TOPIC A: What is Microsoft Access?

• About Microsoft Access
• What’s New in Microsoft Access?
• Navigating the Microsoft Access Interface
• Working with Microsoft Access Files
• Using the Tell Me Box
• Access Advanced Help
• Activity 1-1: Getting Help in Access

TOPIC B: Components of a Database

• What are Tables?
• What are Fields?
• What are Records?
• What are Forms and Views?
• What are Queries?
• What are Reports?
• Activity 1-2: Navigating Database Components

TOPIC C: Create a Simple Database

• Database Templates
• Working with Tables
• Object Naming Conventions
• Saving a Database
• Activity 1-3: Creating a Simple Access Database

TOPIC D: Creating a Simple Form

• Ways to Create a Form
• Using the Three Form Views
• About Form Sections
• Saving a Form
• Deleting a Form
• Activity 1-4: Creating a Simple Form
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 1-1
• Course Completion

Lesson 2: Generate Reports

TOPIC A: Create a Report

• Report Creation Tools
• Using the Report Wizard
• Using Report Views
• Saving a Report
• Deleting a Report
• Activity 5-1: Creating a Report

TOPIC B: Add Controls to a Report

• What are Report Sections?
• Adding Controls
• Modifying Control Properties
• Adding Images
• Adding Charts
• Activity 5-2: Adding Controls to a Report

TOPIC C: Advanced Reporting

• Format Reports
• Add Calculated Fields
• Add a Subreport to an Existing Report
• Adding a Header/Footer
• Organize Report Information
• Publish a Report as a PDF
• Activity 5-3: Organizing Report Information
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 5-1
• Course Completion

Lesson 3: Importing and Exporting Data

TOPIC A: Import Data into Access

• Types of Data Imports
• Using the Get External Data Wizard
• About Delimiters
• Activity 8-1: Importing Data into Access

TOPIC B: Export Data

• Export Access Data
• Export Data to Excel
• Activity 8-2: Exporting Data to Excel

TOPIC C: Create a Mail Merge

• What is the Microsoft Word Mail Merge Wizard?
• Merge Fields
• About the Mail Merge Task Pane
• Activity 8-3: Creating a Mail Merge
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 8-1
• Course Completion

Lesson 4: Joining Tables

TOPIC A: Create Query Joins

• What are Joins?
• Creating an Inner Join
• Creating an Outer Join
• Self-joins and the Table Alias Property
• The Join Properties Dialog Box
• Activity 7-1: Creating Query Joins

TOPIC B: Working with Subdatasheets and Subqueries

• About Subdatasheets
• About Subqueries
• Activity 7-2: Working with Subdatasheets
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 7-1
• Lesson Lab 7-2
• Course Completion

Lesson 5: Query a Database

TOPIC A: Use a Query to View Data from Multiple Tables

• What are the Types of Queries?
• Using the Simple Query Wizard
• Using Query Views
• Run a Query
• Use Design View
• Saving a Query
• Deleting a Query
• Renaming a Query
• Activity 3-1: Creating a Query

TOPIC B: Sort and Filter Data in a Query

• Choosing Query Criteria
• Using Comparison Operators
• Using Logical Operators
• Sorting Query Results
• Grouping Query Results
• Formatting Query Fields
• The Zoom Dialog Box
• Activity 3-2: Sorting and Filtering Data in a Query

TOPIC C: Perform Calculations in a Query

• The Arithmetic Operators
• How to Add Calculated Fields
• How to Add Conditional Logic
• Activity 3-3: Performing Calculations in a Query
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 3-1
• Course Completion

Lesson 6: Working with Table Data

TOPIC A: Work with Table Data

• Using AutoCorrect
• Commit, Save, and Undo
• Running a Quick Search
• Using Find and Replace
• Using Datasheet Totals
• Activity 2-1: Modifying Table Data

TOPIC B: Work with Records

• Adding New Records
• Navigating Records
• Updating Records Using a Query
• Using Append Queries
• Activity 2-2: Working with Records

TOPIC C: Sort and Filter Records

• Sorting Records
• Filtering Records
• Other Filter Options
• Grouping Records
• Activity 2-3: Sorting and Filtering Records

TOPIC D: Create Lookups and Relationships

• Using Lookup Fields
• Table Relationships
• Using the Relationship View
• Using the Property Sheet Pane
• Activity 2-4: Creating Lookups
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 2-1
• Course Completion