We may earn an affiliate commission when you visit our partners.

Access 2019 Essentials

In this course, you’ll learn the basics of working with Access 2019. You'll explore the Access user interface and begin the process of building working database solutions.

Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. In this course, Access 2019 Essentials, you will be will introduced to Access 2019, Microsoft’s application for creating working database solutions. First, you’ll begin with navigation lessons to help you find your way around the Access interface. Next, you will explore the basics of working with databases and tables. From there you’ll move into working with and sorting records, working with filters, forms, queries, and reporting. Finally, you'll explore and understand database objects. When you’re finished with this course, you will have the skills and knowledge of Access 2019 needed to begin development (and begin preparation for the Microsoft Office exams).

Enroll now

Or start your subscription today

And complete this course over a free trial

Here's a deal for you

We found an offer that may be relevant to this course.

Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid for a limited time only

Future-proof your career

Access O'Reilly books, live events, courses, and more. Save with an annual subscription.

Take

15%

off

What's inside

Syllabus

Getting Started with Microsoft Access

Working with Databases and Tables

Table Basics and Sorting Records

Working with Filters and Forms

The Basics of Queries and Reports

Working with Database Objects

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops foundational knowledge of Access 2019, which is standard in business environments

Taught by Shari Oswald, a recognized expert in Access database management

Provides a comprehensive overview of Access 2019, covering a wide range of topics essential for database management

Introduces key concepts of database design and management, including tables, queries, forms, and reports

Suitable for beginners seeking to build a strong foundation in Access database management

Course content is up-to-date, covering the latest features and functionalities of Access 2019

Save this course

Save Access 2019 Essentials to your list so you can find it easily later:

Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Access 2019 Essentials with these activities:

Review SQL tutorial

Show steps

Help you refresh your memory about the fundamentals of SQL before taking this course.

Browse courses on SQL

Show steps

Read through an online SQL tutorial
Complete the practice exercises provided in the tutorial
Take a quiz to test your understanding

Compile and review your course materials

Show steps

Give you a better understanding of the course content and identify areas where you need additional support

Show steps

Gather your notes, assignments, and quizzes
Review the materials and identify any areas where you need clarification
Make a list of questions to ask your instructor or classmates

Participate in a study group

Show steps

Allow you to collaborate with other students and learn from each other

Browse courses on Collaboration

Show steps

Form a study group with other students in your class
Meet regularly to discuss the course material
Work together on projects and assignments

Four other activities

Expand to see all activities and additional details

Show all seven activities

Follow a course on database normalization

Show steps

Help you understand the principles of database normalization and how to apply them to your own databases

Browse courses on Database Normalization

Show steps

Find a reputable online course or tutorial on database normalization
Follow the instructions in the course or tutorial
Complete the exercises and quizzes

Practice creating queries and reports

Show steps

Help you develop your skills in creating queries and reports in Access 2019

Browse courses on Queries

Show steps

Find a set of practice exercises or problems
Attempt to solve the exercises or problems on your own
Check your answers against the provided solutions

Read 'Access 2019 Bible'

Show steps

Provide you with a comprehensive overview of Access 2019 and its features

View Microsoft Excel 365 Bible on Amazon

Show steps

Read through the book
Complete the exercises at the end of each chapter
Use the book as a reference when working on your own Access 2019 projects

Help other students with their Access 2019 projects

Show steps

Allow you to share your knowledge and skills with others while solidifying your own understanding of Access 2019

Browse courses on Access 2019

Show steps

Join a study group or online forum
Offer to help other students with their projects
Provide feedback and guidance on their work

Career center

Learners who complete Access 2019 Essentials will develop knowledge and skills that may be useful to these careers:

Records Manager

Records Managers are responsible for the creation, maintenance, and disposition of records. They may also develop and implement records management systems. Access 2019 Essentials is a widely used tool for database management, so a course on this topic could be very helpful for aspiring Records Managers.

See salaries and explore the career path for Records Manager

Data Scientist

Data Scientists use scientific methods, processes, algorithms, and systems to extract knowledge and insights from data. You will benefit from an Access 2019 Essentials course in this career field. The course will teach you the basics of working with databases, tables, filters, and reports, which are all essential skills for a Data Scientist to have.

See salaries and explore the career path for Data Scientist

Information Architect

Information Architects design and maintain the structure of websites and applications. It requires an understanding of user needs and behavior as well as an ability to organize and categorize information. An Access 2019 Essentials course would be a good introduction to database management and could help you as you wish to enter this field.

See salaries and explore the career path for Information Architect

Knowledge Management Specialist

Knowledge Management Specialists capture, store, and share knowledge within an organization. They may also provide support to individuals and teams in accessing and using knowledge. An Access 2019 Essentials course can help you learn the basics of database management, which can be valuable for a Knowledge Management Specialist.

See salaries and explore the career path for Knowledge Management Specialist

Quality Assurance Analyst

A Quality Assurance Analyst is responsible for ensuring that products and services meet quality standards. They may also develop and implement quality control processes. An Access 2019 Essentials course can help you learn the basics of data management, which can be valuable for a Quality Assurance Analyst.

See salaries and explore the career path for Quality Assurance Analyst

Systems Analyst

Systems Analysts analyze and design computer systems. They may also develop and implement solutions to improve efficiency and productivity. An Access 2019 Essentials course may be useful to you in this career. The course will teach you the basics of systems analysis and design, which are essential skills for a Systems Analyst to have.

See salaries and explore the career path for Systems Analyst

Web Developer

Web Developers design and develop websites. They may also work on the maintenance and updating of websites. An Access 2019 Essentials course may be useful to you in this field. The course will help build a foundation in data management and analysis, which can be valuable for a Web Developer to have.

See salaries and explore the career path for Web Developer

Database Administrator

A Database Administrator ensures that database management systems operate efficiently and effectively. As a graduate of the Access 2019 Essentials course, you will have built a foundation for understanding relational databases. This will greatly assist you in understanding the tasks required of a DBA, such as setting up and maintaining databases, optimizing performance, and administering security.

See salaries and explore the career path for Database Administrator

Operations Research Analyst

An Operations Research Analyst uses mathematical and analytical techniques to solve business problems. They may also develop and implement solutions to improve efficiency and productivity. An Access 2019 Essentials course may be useful to you in this role. The course will teach you the basics of data management and analysis, which are essential skills for an Operations Research Analyst to have.

See salaries and explore the career path for Operations Research Analyst

Project Manager

A Project Manager is responsible for planning, executing, and completing projects. They may also work with stakeholders to ensure that projects meet their objectives. An Access 2019 Essentials course may be useful to you in this career. The course will teach you the basics of project management, which are essential skills for a Project Manager to have.

See salaries and explore the career path for Project Manager

Information Manager

An Information Manager is responsible for the organization and dissemination of information within an organization. They may also be responsible for developing and implementing information systems. Graduates of an Access 2019 Essentials course may be eligible for entry-level positions in this field or it may help you build upon your current knowledge.

See salaries and explore the career path for Information Manager

Market Researcher

Market Researchers study market conditions and trends in order to provide businesses with insights and help them make informed decisions. Taking an Access 2019 Essentials course is a good place to start in this field. The course will help build a foundation in data management and analysis.

See salaries and explore the career path for Market Researcher

Data Analyst

A Data Analyst collects, analyzes, and interprets data in order to provide insights and help organizations make informed decisions. Taking an Access 2019 Essentials course may be useful to you in this career. The course will help build a foundation in data management, analysis, and reporting.

See salaries and explore the career path for Data Analyst

Product Manager

Product Managers are responsible for the development and marketing of products. They may also work with customers to gather feedback and improve products. Graduates of Access 2019 Essentials courses may be eligible for entry-level positions in this field or it may help you build upon your current knowledge.

See salaries and explore the career path for Product Manager

Library Scientist

Library Scientists manage libraries and assist patrons with accessing and using information. An Access 2019 Essentials course may be helpful to you in this career. It will provide you with a foundation in database management, which is essential for organizing and managing information.

See salaries and explore the career path for Library Scientist

Reading list

We've selected 13 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Access 2019 Essentials.

Access 2019 Bible

Save

An update to the Access bible, this book common reference for both beginners and programmers. It is less useful for beginners than the beginner's guide, but has much more depth.

Access 2019 Essentials

Here's a deal for you

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses