Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Access 2019/2021: Part 1

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.

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® Office 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.

Course Content

Lesson 1: Getting Started with Access 2019
  • Launch Access and Open a Database
  • Use Tables to Store Data
  • Use Queries to Combine, Find, Filter, and Sort Data
  • Use Forms to View, Add, and Update Data
  • Use Reports to Present Data
  • Get Help and Configure Options in Microsoft Access
Lesson 2: Creating Tables
  • Plan an Access Database
  • Start a New Access Database
  • Create a New Table
  • Establish Table Relationships
Lesson 3: Creating Queries
  • Create Basic Queries
  • Perform Calculations in a Query
  • Sort and Filter Data in a Query
Lesson 4: Creating Forms
  • Start a New Form
  • Enhance a Form
Lesson 5: Creating Reports
  • Start a New Report
  • Enhance Report Layout

Similar courses

Introduction to DAX for Power BI

Using Data Analysis Expressions to solve common business problems in Power BI

More Information
Microsoft Excel for Office 365/2019: Part 2

Start down the road to creating advanced workbooks and worksheets to help deepen understanding of organizational intelligence

More Information
Microsoft Excel for Office 365/2019: Part 3

Put the full power of Excel right at your fingertips: collaborate, automate, and use conditional logic to construct and apply elaborate formulas and functions

More Information
Microsoft Excel for Office 365/2019: Part 1

Provides a foundation for Excel knowledge and skills

More Information
Microsoft Outlook for Office 365/2019: Part 2

Builds upon the foundational knowledge presented in the Microsoft Outlook for Office 365/2019: Part 1 course and will help you customize a communication system well-suited to your work style

More Information
Microsoft Access 2019/2021: Part 2

Expand basic database management skills

More Information
Microsoft Word for Office 365/2019: Part 2

Tackle more advanced features of Word

More Information
Microsoft Power BI: Data Analysis Practitioner

Analyze business data, visualize insights, and share those insights across the enterprise

More Information
Microsoft Project 2019/2021: Part 2

This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment

More Information
Microsoft Project 2019/2021: Part 1

Use Microsoft Project effectively and efficiently in a real-world environment.

More Information
Microsoft Excel for Office 365/2021: Data Analysis with Power Pivot

Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data

More Information
Microsoft Excel for Office 365/2021: Data Analysis with PivotTables

Use the advanced PivotTable functionality in Excel to analyze your raw data

More Information
Microsoft PowerPoint for Office 365/2019: Part 2

Create presentations that not only stand out from the crowd, but also don't consume all of your available time

More Information
Microsoft PowerPoint for Office 365/2019: Part 1

How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® PowerPoint® can help you do.

More Information
Microsoft SharePoint for Site Owners (Modern)

SharePoint provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location

More Information
Tableau Part 2

In this course, you will perform advanced data visualization and data blending with Tableau.

More Information
Microsoft Word for Office 365/2019: Part 3

Includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

More Information
Microsoft Word for Office 365/2019: Part 1

You will learn fundamental Word skills

More Information
Microsoft Outlook for Office 365/2019: Part 1

Use Outlook to compose and handle your email communications and to manage your calendar, contacts, and tasks.

More Information
Adobe Photoshop CC - Part 1

This course will prepare you to use the most common basic features of Adobe Photoshop

More Information
Adobe Acrobat Pro DC: Introduction

This course is for individuals who are new to Adobe Acrobat Pro DC, but need to create and share PDF files and PDF portfolios

More Information
PL-400T00 Microsoft Power Platform Developer

The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes.

More Information
Adobe Illustrator CC - Part 1

Upon successful completion of this course, you will be able to use Adobe Illustrator CC to create illustrations that include graphics and text.

More Information
Adobe InDesign CC: Part 1

In this course, you will use Adobe InDesign to create and deliver professional looking printed and interactive documents.

More Information
Formatting Technical Documents

Work with formatting options such as styles and section breaks to automate and troubleshoot document content including table of contents, list of figures, and more.

More Information

Press enter to see more results