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