microsoft partner logo color
8781  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
$675 USD
Duration 1 day
Course Code MSFT-ACCESS-PART1
Available Formats Classroom

Overview

Course Description

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.

Read Less

Course Details

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

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
Ascendient Learning would like to occasionally share news about our services and career opportunities via e-mail when we believe it would be relevant to you. Would you like to opt-in to these communications? You may withdraw your consent at any time using the opt-out/preferences link in the emails sent.

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase.

  • 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

Thank Tech Data for sponsoring this course you really take care of your partners.

The format of the class was concise. I learned new skills to use at my workplace.

Easy to work with. Learning material pdfs were able to be printed out in color which was very nice to write on.

Great instructor, clear and concise course. Labs were easy to follow and worked perfectly.

Thorough explanations by the instructor along guide and practical training sim of software.