microsoft partner logo color
8390  Reviews star_rate star_rate star_rate star_rate star_half

Microsoft Access for Office 365: Part 1

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as...

Read More
By Request
Contact Us For Pricing
Duration 1 day
Course Code MSFT-ACCESS-PART1
Available Formats Classroom

Overview

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Access® can help you and your organization with this task.

This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

  • Microsoft® Access® for Office 365™: Part 1 (this course): Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
  • Microsoft® Access® for Office 365™: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.
  • Microsoft® Access® for Office 365™: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database.

Skills Gained

In this course, you will create and manage an Access database.

You will:

  • Navigate within the Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Who Can Benefit

This course is designed for students looking to establish a foundational understanding of Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

Course Details

Outline

Lesson 1: Working with an Access Database

  • Topic A: Launch Access and Open a Database
  • Topic B: Use Tables to Store Data
  • Topic C: Use Queries to Combine, Find, Filter, and Sort Data
  • Topic D: Use Forms to View, Add, and Update Data
  • Topic E: Use Reports to Present Data
  • Topic F: Get Help and Configure Options in Access

Lesson 2: Creating Tables

  • Topic A: Plan an Access Database
  • Topic B: Start a New Access Database
  • Topic C: Create a New Table
  • Topic D: Establish Table Relationships

Lesson 3: Creating Queries

  • Topic A: Create Basic Queries
  • Topic B: Add Calculated Columns in a Query
  • Topic C: Sort and Filter Data in a Query

Lesson 4: Creating Forms

  • Topic A: Start a New Form
  • Topic B: Enhance a Form

Lesson 5: Creating Reports

  • Topic A: Start a New Report
  • Topic B: Enhance Report Layout

Appendix A: Mapping Course Content to Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500

Appendix B: Microsoft® Access® Common Keyboard Shortcuts

Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

I found this course informative. It was easy to follow and provided some good information.

The platform is very intuitive and easy to navigate. Great tool for learning

Good Course. We covered a lot of material in a short amount of time. This course had useful labs that built upon each other.

I didn't have any problem navigating Exitcertified website or lab material at all.

I think the platform is very good and look forward to taking my next course in early October.