eBSI Export Academy - Corona Virus - COVID-19 Response - Info Resources. Click to learn more...

Microsoft Access 365 Part 1 - eBSI Export Academy
Microsoft Access 365 Part 1 - eBSI Export Academy
Microsoft Access 365 Part 1 - eBSI Export Academy

Microsoft Access 365 Part 1

Vendor
eBSI Export Academy
Regular price
€40.00
Sale price
€40.00
Tax included. Shipping calculated at checkout.

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