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: New Experience

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
Microsoft® Teams® for Business Users

Course Objectives: In this course, you will use Microsoft Teams to communicate and collaborate with your colleagues. You will: Send messages to colleagues using Teams. Call and meet with people in Teams. Lead a meeting. Configure your Teams environment. Share files and app content. Create and configure Teams.

More Information
Microsoft® SharePoint® Modern Experience: Site Basics

Course Objectives: In this course, you will use a typical SharePoint team site to work collaboratively with other team members. You will: Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site.

More Information
Adobe Illustrator CC: Part 2

In this course, you will draw complex illustrations, enhance artwork by using painting tools, customize colors and swatches, format type. Enhance the appearance of artwork, prepare content for deployment, and set up project requirements.

More Information
Adobe InDesign CC: Part 2

Upon successful completion of this course, you will be able to use Adobe InDesign CC to create and deliver professional looking printed and interactive documents.

More Information
Getting the Most from Your Spreadsheets with GenAI

In this course, you will use generative AI to assist you as you work with spreadsheets.

More Information
Programming and Data Wrangling with VBA and Excel

In this course, you will develop and deploy VBA modules to solve business problems.

More Information

Press enter to see more results