We may earn an affiliate commission when you visit our partners.
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”!
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.)
Register for this course and see more details by visiting:
OpenCourser.com/course/wjpa5y/access
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
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
Controlling Data Entry
Using Calculations in Queries
Refining Query Results and Creating Advanced Queries
Managing Data with Action Queries and Types of Field Controls
Working with Form and Report Controls
Formatting Your Forms and Reports
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save Access 2019 Pro to your list so you can find it easily later:
Save
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 Pro with these
activities:
Organize and compile your course notes, assignments, and other materials
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Organize and compile your course notes, assignments, and other materials
Show steps
Improves your ability to locate and review relevant information
Show steps
Show steps
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
Show steps
Solidify your foundations and refresh your memory on the fundamentals of databases.
Browse courses on
Database Concepts
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
Provides you with a comprehensive guide to advanced Access 2019 topics
View
MOS Study Guide for Microsoft Word Expert Exam...
on Amazon
Show steps
Show steps
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
Show steps
Provides comprehensive and authoritative information on Access 2019 features
Show steps
Show steps
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
Show steps
Supplement the course material with guided tutorials to reinforce the concepts and techniques covered in the course.
Browse courses on
Access 2019
Show steps
Show steps
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
Show steps
Provides step-by-step instructions and demonstrations of complex tasks
Browse courses on
Access 2019
Show steps
Show steps
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
Show steps
Reinforces your understanding of key concepts and techniques
Browse courses on
Access 2019
Show steps
Show steps
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
Show steps
Engages you in active learning and provides diverse perspectives
Show steps
Show steps
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
Show steps
Provides expert instruction and hands-on practice
Show steps
Show steps
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
Show steps
Provides practical experience in database design and development
Browse courses on
Access 2019
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
Provides real-world experience in collaborative development
Show steps
Show steps
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 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.
Data Architect
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.
Information Systems Manager
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.
Data Analyst
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.
Software Engineer
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.
Database Administrator
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.
Business Analyst
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.
IT Consultant
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.
Systems Analyst
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.
Operations Research 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.
Information Architect
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.
Data Scientist
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.
Computer 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.
Software Developer
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.
Project Manager
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.
For more career information including salaries, visit:
OpenCourser.com/course/wjpa5y/access
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.
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.
Save
Provides a comprehensive guide to advanced SQL topics, such as subqueries, set operators, and window functions.
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.
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.
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.
Provides a practical guide to database design. It covers all the essential topics, from data modeling to normalization.
Provides a practical guide to writing SQL queries. It covers all the essential topics, from basic SELECT statements to complex JOINs.
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/wjpa5y/access
Share
Similar courses
Here are nine courses similar to
Access 2019 Pro.
Word 2019 Pro
OpenCourser.com/course/df9fru/word
Word 2019 Pro
Most relevant
Access 2019 Power Users
OpenCourser.com/course/5v8qjc/access
Access 2019 Power Users
Most relevant
Excel 2019 Pro
OpenCourser.com/course/f3lzx4/excel
Excel 2019 Pro
Most relevant
Access 2019 Essentials
OpenCourser.com/course/ioh2me/access
Access 2019 Essentials
Excel 2019 Power Users
OpenCourser.com/course/ncsrxi/excel
Excel 2019 Power Users
Managing Relational Databases
OpenCourser.com/course/dhv4t2/managing
Managing Relational Databases
Visio 2019 Power Users
OpenCourser.com/course/tm2f74/visio
Visio 2019 Power Users
PowerPoint 2019 Pro
OpenCourser.com/course/3kbtnj/powerpoint
PowerPoint 2019 Pro
Architecting Data Warehousing Solutions Using Google BigQuery
OpenCourser.com/course/3divne/architecting
Architecting Data Warehousing Solutions Using Google...
Time
190 hours
Level
Advanced
Via
Pluralsight
Instructor
Shari Oswald
Language
English
Good to know
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
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 - 2024 OpenCourser