OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course Discontinued We've found some alternatives for you:

Top Active Alternatives

Access 2019 Pro is no longer accepting new enrollments. We've matched the highest-rated active courses in this subject:

Read Reviews → Enroll Active
Read Reviews → Enroll Active
Read Reviews → Enroll Active
Pluralsight logo

Access 2019 Pro

Shari Oswald

In Access 2019 Pro you’ll learn the deepest aspects of working with Access 2019, including a greater understanding of key fields, relationships, advanced queries, forms, reports, and more. You’ll become a true Access 2019 “pro”!

Read more

In Access 2019 Pro you’ll learn the deepest aspects of working with Access 2019, including a greater understanding of key fields, relationships, advanced queries, forms, reports, and more. You’ll become a true Access 2019 “pro”!

This course will move you to the deepest levels of the world of Access 2019. You’ll continue to explore what it takes to manage databases and work with key fields. Then you’ll begin learning about the relationship window and working with relationships. You’ll learn more about external sources, controlling data entry, advanced queries, form and report controls, and more. When you’re finished with this course, you will have the skills and knowledge of an Access 2019 pro needed to expand your development (and complete your preparation for the Microsoft Office exams.)

This course is no longer available. Find something similar by browsing:
Microsoft Access 2019 Database Management SQL Data Manipulation Data Analysis Report Generation Form Design

What's inside

Syllabus

Managing Databases and Working with Key Fields
Using the Relationships Window and Managing Table Relationships
Working with External Sources and Advanced Field Properties
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Suitable for learners interested in taking the Microsoft Office exam
Applies the key principles of database management that are transferable to other databases
Explores the nuances of Access 2019 beyond the basics
Taught by a recognized instructor in the Access 2019 field
Focuses on improving students' data management and manipulation skills
May require prior understanding of database management concepts

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Mastering advanced access 2019 database skills

According to students, Access 2019 Pro is a highly effective course for deepening understanding of Microsoft Access. Many appreciate the clear explanations of complex topics like database relationships and advanced queries, often citing the instructor's teaching style as a key strength. The course is seen as beneficial for career development and preparation for Microsoft Office exams, providing invaluable hands-on exercises for practical application. However, some learners caution that the course assumes significant prior Access knowledge, making it potentially challenging for true intermediates. A few also noted inconsistent pacing and occasional outdated examples or technical issues like audio quality.
Equips learners with applicable skills and aids in Microsoft Office exam preparation.
"The hands-on exercises are invaluable for practical application. I feel much more confident in handling databases now. Highly recommend for those preparing for the M.O. exam!"
"This course significantly boosted my skills for my job. A must-have for Access users."
"Prepared me well for advanced database tasks."
"It genuinely helped me prepare for the exam."
Offers comprehensive and clear explanations for complex Access functionalities.
"Excellent course for mastering Access 2019. The instructor explains complex concepts with great clarity..."
"Truly a 'Pro' course! The depth on relationships and external data sources was fantastic."
"The explanations of key fields and action queries were incredibly clear. I learned so many new tricks."
"The detailed explanations of data entry control and form/report management are excellent."
Occasional issues with audio/video quality or slightly outdated examples.
"The audio quality on some lectures was poor."
"A few examples seemed slightly out of date with current Access behavior, which was a bit confusing."
"The only downside was occasionally fuzzy audio in older lectures."
"Some minor technical glitches with video playback, but overall good value."
Some sections feel rushed or slow, affecting the overall learning flow.
"Some parts felt a bit rushed, especially the form/report controls, and I had to re-watch lectures to fully grasp them."
"The content is comprehensive, but the pacing can be inconsistent. Sometimes it moves too fast, sometimes too slow."
"I felt the course was a bit rushed towards the end, especially with the formatting sections."
Requires a solid foundational understanding of Access, not ideal for beginners.
"I found it very difficult to follow without strong prior Access knowledge, even though it's marketed as 'Pro'. The instructor assumes too much."
"Not for me. The course assumes you're already an expert. I was constantly lost."
"Definitely not for intermediate users looking to become 'Pro'. Needs more foundational review or clearer prerequisites."

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 Pro with these activities:
Organize and compile your course notes, assignments, and other materials
Improves your ability to locate and review relevant information
Show steps
  • Gather all course materials
  • Create a system for organizing the materials
  • Store the materials in a convenient and accessible location
Review the Basics of Databases
Solidify your foundations and refresh your memory on the fundamentals of databases.
Browse courses on Database Concepts
Show steps
  • Review the concepts of data organization, storage, and retrieval.
  • Explore different data models, such as relational, hierarchical, and network models.
Review Microsoft Office
Solidify existing knowledge of Microsoft Office prior to taking the Access 2019 Pro course to ensure a strong foundation.
Browse courses on Microsoft Office Suite
Show steps
  • Review using Microsoft Office applications such as Word, Excel, PowerPoint, and Access.
  • Practice creating and editing documents, spreadsheets, presentations, and databases.
  • Explore online tutorials or resources to refresh your memory on specific features or functions.
Ten other activities
Expand to see all activities and additional details
Show all 13 activities
Read "Access 2019 Expert Techniques" by Paul McFedries
Provides you with a comprehensive guide to advanced Access 2019 topics
View MOS Study Guide for Microsoft Word Expert Exam... on Amazon
Show steps
  • Acquire a copy of the book
  • Read and take notes on the first three chapters
  • Complete the practice exercises in the book
Read the Microsoft documentation for Access 2019
Provides comprehensive and authoritative information on Access 2019 features
Show steps
  • Access the Microsoft documentation online
  • Identify relevant sections for your learning objectives
  • Read and take notes on the selected sections
Follow Access 2019 Tutorials
Supplement the course material with guided tutorials to reinforce the concepts and techniques covered in the course.
Browse courses on Access 2019
Show steps
  • Search for online tutorials or guided walkthroughs related to Access 2019.
  • Follow the tutorials step-by-step, practicing the creation and manipulation of databases.
  • Experiment with different features and functions to gain hands-on experience.
Follow tutorials on YouTube or Udemy to learn advanced Access 2019 techniques
Provides step-by-step instructions and demonstrations of complex tasks
Browse courses on Access 2019
Show steps
  • Search for a relevant tutorial on YouTube or Udemy
  • Watch the tutorial and take notes
  • Repeat the steps demonstrated in the tutorial to practice the technique
Complete online Access 2019 practice drills
Reinforces your understanding of key concepts and techniques
Browse courses on Access 2019
Show steps
  • Identify a reputable online practice platform
  • Select a practice drill that aligns with your learning objectives
  • Complete the practice drill
  • Review the results and identify areas for improvement
Participate in a peer study group or online forum to discuss Access 2019 concepts
Engages you in active learning and provides diverse perspectives
Show steps
  • Find or create a peer study group
  • Attend regular meetings or engage in online discussions
  • Contribute to the group by sharing your knowledge and asking questions
Attend a workshop on advanced Access 2019 topics
Provides expert instruction and hands-on practice
Show steps
  • Identify a reputable workshop provider
  • Register for a workshop that aligns with your learning goals
  • Attend the workshop and actively participate
Develop an Access 2019 database for a real-world scenario
Provides practical experience in database design and development
Browse courses on Access 2019
Show steps
  • Identify a real-world scenario that requires a database solution
  • Design the database schema and create the tables
  • Populate the database with data
  • Create queries, forms, and reports to interact with the data
Build a Personal Database
Apply the skills acquired in the course to create a personal database project, fostering practical application and retention.
Browse courses on Database Creation
Show steps
  • Identify a personal data management need (e.g., tracking expenses, managing contacts).
  • Design the database structure, including tables, fields, and relationships.
  • Create the database using Access 2019 and populate it with relevant data.
  • Develop queries, forms, and reports to access and present the data effectively.
Contribute to an open-source Access 2019 project on GitHub
Provides real-world experience in collaborative development
Show steps
  • Identify an open-source Access 2019 project on GitHub
  • Review the project documentation and identify areas for contribution
  • Fork the project and make your changes
  • Submit a pull request to contribute your changes to the project

Career center

Learners who complete Access 2019 Pro will develop knowledge and skills that may be useful to these careers:
Database Designer
Database Designers are responsible for the design and development of databases that meet the needs of an organization. Access 2019 Pro offers advanced training that can help you develop the foundational skills you need to be a Database Designer. Through the course, you will gain proficiency in database management, data modeling, and query optimization techniques, which are essential skills for the role. This course will help you develop the skills and knowledge you'll need to succeed as a Database Designer.
See salaries and explore the career path for Database Designer
Data Architect
Data Architects design and build the architectures for data systems. Access 2019 Pro will provide you with an in-depth understanding of database management and data analysis, which are crucial for Data Architects. This course emphasizes topics such as data modeling, database design, and advanced query optimization. By developing expertise in these areas, you will be equipped to make informed decisions about the design and implementation of data systems.
See salaries and explore the career path for Data Architect
Information Systems Manager
Information Systems Managers plan, implement, and manage an organization's information systems. Access 2019 Pro can provide you with the skills and knowledge needed to succeed in this role. Through this course, you will gain a comprehensive understanding of database management, data analysis, and systems design. By developing proficiency in these areas, you will be well-equipped to make strategic decisions about the implementation and management of information systems within an organization.
See salaries and explore the career path for Information Systems Manager
Data Analyst
Data Analysts help organizations turn collected data into actionable insights. They use analytic techniques, software, and programming tools to examine large volumes of data and search for patterns to help organizations understand their current practices and make data-driven decisions. Acquiring proficiency with SQL and database analysis will make you a more effective and well-rounded Data Analyst. Access 2019 Pro can provide this proficiency. This course will help you build a foundation in essential data analysis skills, providing you with a competitive edge in the field.
See salaries and explore the career path for Data Analyst
Software Engineer
Software Engineers design, develop, and maintain software systems. Access 2019 Pro can provide you with valuable skills in database management and data analysis. Through this course, you will learn advanced query optimization, data modeling, and database design techniques which are useful in software development. By developing a practical understanding of these topics, you will become a more well-rounded Software Engineer.
See salaries and explore the career path for Software Engineer
Database Administrator
A Database Administrator manages the day-to-day operations of an organization's databases. They monitor performance, prepare backups, tune queries, and ensure that data is always available and secure. Access 2019 Pro will help you develop the core skills you'll need to become an effective Database Administrator, from table relationships and data control to form and report design and advanced query techniques. Organizations large and small rely on access to data and a well-managed database is key to their success. This role requires highly skilled people to ensure quality.
See salaries and explore the career path for Database Administrator
Business Analyst
Business Analysts identify business needs and determine solutions to help organizations. They fill the gap between business and IT. Access 2019 Pro can give you skills in data management and analysis that are essential to the job. By deepening your understanding of databases, you can more effectively translate business requirements into technical solutions, facilitating the successful implementation of new systems and processes. With strong communication skills and technical knowledge, a Business Analyst is an important asset to any organization.
See salaries and explore the career path for Business Analyst
IT Consultant
IT Consultants provide expert advice and support to organizations on their IT systems. Access 2019 Pro can help you develop foundational skills in database management and data analysis, which are essential for IT Consultants. This course will provide you with a practical understanding of data modeling, database design, and advanced query optimization techniques. By becoming proficient in these areas, you will be better equipped to provide effective solutions to clients' IT challenges.
See salaries and explore the career path for IT Consultant
Systems Analyst
Systems Analysts study existing systems and design new systems to improve efficiency and productivity. Access 2019 Pro can help you build a strong foundation in data management and analysis, which is important for Systems Analysts. Through this course, you will become familiar with database design, data modeling, and query optimization techniques. These skills are key to understanding the needs of different systems and developing effective solutions. Access 2019 Pro can be a valuable asset in your pursuit of a career as a Systems Analyst.
See salaries and explore the career path for Systems Analyst
Operations Research Analyst
Operations Research Analysts use mathematical and analytical techniques to help organizations make better decisions. These professionals use data to build models that can be used to simulate different scenarios and predict outcomes. Access 2019 Pro may be useful to you in developing your analytical and data management skills. By learning advanced query optimization and data modeling techniques, you will be better equipped to analyze large datasets and build effective models. This course can be a useful tool in your pursuit of a career as an Operations Research Analyst.
See salaries and explore the career path for Operations Research Analyst
Information Architect
Information Architects design and maintain the structure and organization of websites, intranets, and other information systems. Access 2019 Pro can be useful in developing your understanding of data organization and management. This course will teach you to identify relationships between different types of data. This skill will translate directly to the work of an Information Architect, as organizing data is central to the role. Familiarity with database management is highly advantageous for an Information Architect, and Access 2019 Pro can help you build this skill.
See salaries and explore the career path for Information Architect
Data Scientist
Data Scientists analyze large amounts of data to extract meaningful insights and predict future trends. In the current economy, Data Scientists are in high demand as businesses seek to gain a competitive edge through effective data analysis. Access 2019 Pro may be helpful to you in building a foundation in database management, allowing you to gain proficiency with this key tool. Data Scientists use SQL and databases in their work, so having practical experience with this tool will support your development as a Data Scientist.
See salaries and explore the career path for Data Scientist
Computer Scientist
Computer Scientists research and develop the theoretical foundations of computing. They work on topics like algorithms, data structures, and programming languages. Access 2019 Pro may not directly align with the research-driven work of Computer Scientists, but it can help you develop foundational skills in data management and analysis, which are useful in many areas of Computer Science. By learning advanced query optimization, data modeling, and database design techniques, you can develop a more comprehensive understanding of data structures and algorithms.
See salaries and explore the career path for Computer Scientist
Software Developer
Software Developers build and maintain computer programs and applications. With the widespread impact of databases even on small businesses, the need for qualified developers is constantly growing. Access 2019 Pro can equip you with the skills to write, design, and manage databases, which are in high demand in many industries and sectors. Given the many types of software, a developer with proficiency in databases will have a competitive edge in the job market. Access 2019 Pro may help you develop as a Software Engineer, laying the groundwork for your career trajectory.
See salaries and explore the career path for Software Developer
Project Manager
Project Managers plan, organize, and execute projects to achieve specific goals. While Access 2019 Pro may not directly translate to the skills and knowledge needed to be a Project Manager, it can help you develop foundational skills in data management and analysis, which are useful in many project management methodologies. The course covers topics like data organization and analysis, which are essential to project planning and execution. Access 2019 Pro can make you a more well-rounded Project Manager.
See salaries and explore the career path for Project Manager

Reading list

We've selected eight 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 Pro.
Cover image
Access 2019 Bible
Save
This comprehensive guide to Microsoft Access 2019 covers everything from basic to advanced topics, making it a valuable resource for both beginners and experienced users.
Access 2019 Bible
Paperback
Check
Access 2019 Bible
Kindle Edition
Check
Cover image
Querying XML
Save
Provides a comprehensive guide to advanced SQL topics, such as subqueries, set operators, and window functions.
Querying XML, : XQuery, XPath, and SQL/XML in...
Paperback
$$$
Querying XML: XQuery, XPath, and SQL/XML in context...
Kindle Edition
$$$
Cover image
Essential Introduction to Computers
Save
This comprehensive guide to Access 2019 valuable resource for both beginners and experienced users. It covers everything from basic to advanced topics, and is packed with helpful examples and exercises.
Essential Introduction to Computers
Paperback
Check
Essential Introduction to Computers
Kindle Edition
Check
Cover image
Excel VBA Programming For Dummies
Save
This step-by-step guide is perfect for beginners who want to learn the basics of Access 2019. It covers all the essential topics, from creating and managing databases to designing forms and reports.
Excel VBA Programming For Dummies 5th Edition (For...
Paperback
$$
Cover image
Database Systems
Save
This textbook provides a comprehensive overview of database systems, including topics such as data modeling, database design, and database management. It valuable resource for anyone who wants to learn more about the fundamentals of database systems.
Database Principles: Fundamentals of Design,...
Paperback
$$$
Cover image
Database Design for Mere Mortals
Save
Provides a practical guide to database design. It covers all the essential topics, from data modeling to normalization.
Database Design for Mere Mortals: 25th Anniversary...
Paperback
$$
Database Design for Mere Mortals: A Hands-On Guide...
Kindle Edition
$$
Database Design for Mere Mortals: A Hands-On Guide...
Paperback
$$
Database Design for Mere Mortals: A Hands-On Guide...
Paperback
$$
Database Design for Mere Mortals(r)...
Hardcover
$$
Cover image
SQL Queries for Mere Mortals
Save
Provides a practical guide to writing SQL queries. It covers all the essential topics, from basic SELECT statements to complex JOINs.
SQL Queries for Mere Mortals: A Hands-On Guide to...
Kindle Edition
$$
SQL Queries for Mere Mortals: A Hands-On Guide to...
Paperback
$$
SQL Queries for Mere Mortals: A Hands-on Guide to...
Paperback
$$
SQL Queries for Mere Mortals: A Hands-On Guide to...
Paperback
$$
Cover image
Lonely Planet England
Save
Is designed for complete beginners who have no prior experience with Access. It provides clear and concise instructions on how to create and manage databases, design forms and reports, and perform basic queries.
Lonely Planet England
Paperback
Check
Lonely Planet England
Kindle Edition
Check

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Access 2019 Pro.
Understanding Basic SQL Syntax
Most relevant
SQL for Data Science with R
Most relevant
Data Analysis Using SQL
Most relevant
Learn SQL with Databricks
Most relevant
Microsoft Azure Relational Databases
Most relevant
The Ultimate SQL Bootcamp: Zero to Hero in 9 Hours
Most relevant
Practical SQL Masterclass - Learn MySQL - Beginner to Guru
Most relevant
SQL-MySQL: 2021 Complete Master Bootcamp | Beginner-Expert
Most relevant
Building a Company’s database using MySQL and SQL
Most relevant

Pluralsight Buyer Protection & Guarantee

Verified partner policies & purchase protections

Enterprise Technology Platform
Free Trial & Audit

10-Day Free Trial

10-day free trial (up to 200 minutes of content) with access to the Skills video library and skill assessments. Cancel before day 10 to avoid automatic conversion.

Return & Refund Policy

Cancel Anytime (Non-Refundable Once Billed)

Cancel easily online anytime before the 10-day trial expires to prevent billing. Once subscription fees are paid, individual subscriptions are non-refundable (cancellation stops future renewals).

Buyer Protections

Verified Academic & Industry Partner

Skill IQ and Role IQ diagnostic benchmark assessments, hands-on lab environments, and curated learning paths designed by technology leaders.

Key Purchase Protections
10-day free trial on individual Skills plans
Skill IQ assessments to benchmark proficiency
Cancel anytime online before trial ends without fees
Hands-on interactive labs and enterprise-grade tech content
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Time
190 hours
Level
Advanced
Via
Pluralsight
Instructor
Shari Oswald
Language
English
Access 2019 Pro belongs to the following collections:
  1. Using Access 2019
  2. Using Microsoft Office 2019
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Suitable for learners interested in taking the Microsoft Office exam
Applies the key principles of database management that are transferable to other databases
Explores the nuances of Access 2019 beyond the basics
Taught by a recognized instructor in the Access 2019 field
Focuses on improving students' data management and manipulation skills
May require prior understanding of database management concepts
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
This course is currently discontinued or unavailable. See active alternatives above.
Course Unavailable
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser