We may earn an affiliate commission when you visit our partners.
Shari Oswald
In this course, you’ll learn the deeper aspects of working with Access 2019. You will gain a greater understanding of databases, tables, queries, forms, and reports and move toward becoming a “power user” of Access.
Read more
In this course, you’ll learn the deeper aspects of working with Access 2019. You will gain a greater understanding of databases, tables, queries, forms, and reports and move toward becoming a “power user” of Access.
Read more
In this course, you’ll learn the deeper aspects of working with Access 2019. You will gain a greater understanding of databases, tables, queries, forms, and reports and move toward becoming a “power user” of Access.
In this course, Access 2019 Power Users, you will dive further into the world of Access 2019. First, you’ll continue your understanding of working with databases and tables. Then, you’ll begin learning about data types and learn how to work with fields. Finally, you’ll discover more about creating and managing queries, forms, and reports. When you’re finished with this course, you will have the skills and knowledge of Access 2019 needed to expand your development (and continue preparation for the Microsoft Office exams).
Register for this course and see more details by visiting:
OpenCourser.com/course/5v8qjc/access
What's inside
Syllabus
Working with Databases
Working with Tables
Understanding Data Types
Working with Fields and Datatypes
Read more
Syllabus
Working with Databases
Working with Tables
Understanding Data Types
Working with Fields and Datatypes
Read more
Creating and Managing Queries
Creating and Managing Forms
Creating and Managing Reports
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Teaches core concepts in database management systems, such as working with databases and tables
Builds a strong foundation in Access 2019, providing learners with the skills to become power users
Taught by Shari Oswald, an experienced instructor with extensive knowledge in Access and database management
Suitable for learners who want to enhance their skills in data manipulation, query creation, and report generation
Requires prior knowledge of database concepts and Access, making it suitable for intermediate learners
Focuses on Access 2019, which may not be the latest version available
Save this course
Save Access 2019 Power Users 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 Power Users with these
activities:
Review Data Types and Field Properties
Show steps
Refreshes students' understanding of data types and field properties, ensuring a solid foundation for working with Access databases.
Browse courses on
Data Types
Show steps
-
Review different data types supported by Access
-
Explore field properties such as field size, input mask, and validation rules
Organize Course Notes and Assignments
Show steps
Assists students in organizing their learning materials, promoting effective study habits and maximizing retention.
Show steps
-
Create a dedicated folder for course materials
-
File notes, assignments, and quizzes separately
-
Review and summarize key concepts regularly
Explore Access User Forums and Resources
Show steps
Guides students to online resources and community support, fostering self-reliance and knowledge expansion.
Show steps
-
Visit Microsoft Access user forums
-
Read technical articles and tutorials on Access
-
Join online Access communities
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice Creating Access Queries
Show steps
Helps students gain proficiency in creating Access queries, a fundamental skill for data retrieval and manipulation.
Browse courses on
Queries
Show steps
-
Use Query Wizard to create basic queries
-
Design queries manually in the Query Design view
-
Apply filter criteria to refine query results
Attend Study Group Meetings
Show steps
Encourages collaboration and peer learning, fostering a supportive environment for knowledge sharing and problem-solving.
Show steps
-
Find or form a study group with classmates
-
Set regular meeting times
-
Review course material, discuss concepts, and work on assignments together
Build an Access Database Application
Show steps
Challenges students to apply their learning by creating a functional Access database, reinforcing concepts and promoting problem-solving.
Show steps
-
Design the database schema
-
Create tables, forms, and reports
-
Implement data validation and business rules
-
Test and refine the application
Attend Access Development Workshop
Show steps
Provides an immersive learning experience, allowing students to develop practical skills and enhance their understanding of Access.
Show steps
-
Find a local or online Access development workshop
-
Attend the workshop and actively participate in exercises
-
Apply newly acquired skills to your own Access projects
Review Data Types and Field Properties
Show steps
Refreshes students' understanding of data types and field properties, ensuring a solid foundation for working with Access databases.
Browse courses on
Data Types
Show steps
Show steps
Show steps
- Review different data types supported by Access
- Explore field properties such as field size, input mask, and validation rules
Organize Course Notes and Assignments
Show steps
Assists students in organizing their learning materials, promoting effective study habits and maximizing retention.
Show steps
Show steps
Show steps
- Create a dedicated folder for course materials
- File notes, assignments, and quizzes separately
- Review and summarize key concepts regularly
Explore Access User Forums and Resources
Show steps
Guides students to online resources and community support, fostering self-reliance and knowledge expansion.
Show steps
Show steps
Show steps
- Visit Microsoft Access user forums
- Read technical articles and tutorials on Access
- Join online Access communities
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice Creating Access Queries
Show steps
Helps students gain proficiency in creating Access queries, a fundamental skill for data retrieval and manipulation.
Browse courses on
Queries
Show steps
Show steps
Show steps
- Use Query Wizard to create basic queries
- Design queries manually in the Query Design view
- Apply filter criteria to refine query results
Attend Study Group Meetings
Show steps
Encourages collaboration and peer learning, fostering a supportive environment for knowledge sharing and problem-solving.
Show steps
Show steps
Show steps
- Find or form a study group with classmates
- Set regular meeting times
- Review course material, discuss concepts, and work on assignments together
Build an Access Database Application
Show steps
Challenges students to apply their learning by creating a functional Access database, reinforcing concepts and promoting problem-solving.
Show steps
Show steps
Show steps
- Design the database schema
- Create tables, forms, and reports
- Implement data validation and business rules
- Test and refine the application
Attend Access Development Workshop
Show steps
Provides an immersive learning experience, allowing students to develop practical skills and enhance their understanding of Access.
Show steps
Show steps
Show steps
- Find a local or online Access development workshop
- Attend the workshop and actively participate in exercises
- Apply newly acquired skills to your own Access projects
Career center
Learners who complete Access 2019 Power Users will develop knowledge and skills
that may be useful to these careers:
Data Warehouse Architect
Data Warehouse Architect
A Data Warehouse Architect designs, develops, and maintains data warehouses. This course is a great fit for preparing for a career as a Data Warehouse Architect. Gaining a deeper understanding of databases, tables, queries, forms, and reports will help you excel in this role.
Database Developer
Database Developer
A Database Developer designs, develops, and maintains databases. This course is a great fit for preparing for a career as a Database Developer. Gaining a deeper understanding of databases, tables, queries, forms, and reports will help you excel in this role.
Data Architect
Data Architect
A Data Architect designs, develops, and maintains data architectures. This course is a great fit for preparing for a career as a Data Architect. Gaining a deeper understanding of databases, tables, queries, forms, and reports will help you excel in this role.
Database Administrator
Database Administrator
A Database Administrator designs, implements, and maintains databases. This course may be helpful for building a foundation in database management. Gaining a better understanding of databases, tables, queries, forms, and reports can help you in your work with data management.
Data Integration Architect
Data Integration Architect
A Data Integration Architect designs, develops, and maintains data integration systems. This course may be helpful for gaining a better understanding of the technical aspects of data integration. Gaining a better understanding of databases, tables, queries, forms, and reports can help you in your work with data integration systems.
Information Architect
Information Architect
An Information Architect designs and organizes information systems. This course may be helpful for building a foundation in information architecture. Gaining a better understanding of databases, tables, queries, forms, and reports can help you in your work with data organization.
Systems Analyst
Systems Analyst
A Systems Analyst analyzes and designs IT systems. This course may be helpful for building a foundation in systems analysis. Gaining a better understanding of databases, tables, queries, forms, and reports can help you in your work designing and analyzing IT systems.
Data Scientist
Data Scientist
A Data Scientist uses scientific methods to analyze data and extract meaningful insights. This course may be helpful for building a foundation in data science. Gaining a better understanding of data types, fields, and queries can help you in your work to manage and manipulate data more effectively.
Business Analyst
Business Analyst
A Business Analyst researches, analyzes, and interprets data to identify opportunities and solve problems. This course may be helpful for building a foundation in business analysis. Gaining a better understanding of data types, fields, and queries can help you in your work to manage and manipulate data more effectively.
Data Analyst
Data Analyst
A Data Analyst collects, analyzes, and interprets data to identify trends, patterns, and anomalies. This course may be helpful for building a foundation in data analysis. Gaining a better understanding of data types, fields, and queries can help you in your work to manage and manipulate data more effectively.
Computer Programmer
Computer Programmer
A Computer Programmer designs, develops, and tests computer programs. This course may be helpful for gaining a better understanding of the technical aspects of programming. Gaining a better understanding of databases, tables, queries, forms, and reports can help you in your work with data management in programming.
IT Manager
IT Manager
An IT Manager plans, implements, and maintains IT systems. This course may be helpful for gaining a better understanding of the technical aspects of IT management. Gaining a better understanding of databases, tables, queries, forms, and reports can help you in your work managing IT systems.
Web Developer
Web Developer
A Web Developer designs, develops, and maintains websites. This course may be helpful for gaining a better understanding of the technical aspects of web development. Gaining a better understanding of databases, tables, queries, forms, and reports can help you in your work with data management in web development.
Information Systems Manager
Information Systems Manager
An Information Systems Manager plans, implements, and maintains information systems. This course may be helpful for gaining a better understanding of the technical aspects of information systems management. Gaining a better understanding of databases, tables, queries, forms, and reports can help you in your work managing information systems.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software systems. This course may be helpful for gaining a better understanding of the technical aspects of software development. Gaining a better understanding of databases, tables, queries, forms, and reports can help you in your work with data management in software development.
For more career information including salaries, visit:
OpenCourser.com/course/5v8qjc/access
Reading list
We've selected seven 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 Power Users.
It provides in-depth coverage of Access 2019's new features and capabilities, and helps you maximize your productivity with Access 2019. A valuable learning resource for database creators and users of all experience levels.
Access 2019 Bible is your comprehensive reference to all things Access—with just enough theory to get you up to speed, and plenty of practical, hands-on examples to help you stay there.
Provides a solid foundation in Access 2019 for beginning and intermediate users, and includes many advanced topics that will also be valuable for database developers.
Valuable reference tool for experienced Access developers who want to learn about the new VBA features in Access 2019.
Save
Comprehensive guide to developing Access 2019 solutions. It is written in a clear and concise style, and includes many helpful examples and illustrations.
Valuable reference tool for experienced Access developers who want to learn about the new features and capabilities of Access 2019.
Gentle introduction to Access 2019. It is written in a clear and concise style, and includes many helpful examples and illustrations.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/5v8qjc/access
Share
Similar courses
Here are nine courses similar to
Access 2019 Power Users.
Access 2019 Pro
OpenCourser.com/course/wjpa5y/access
Access 2019 Pro
Most relevant
Access 2019 Essentials
OpenCourser.com/course/ioh2me/access
Access 2019 Essentials
Most relevant
Excel 2019 Pro
OpenCourser.com/course/f3lzx4/excel
Excel 2019 Pro
Most relevant
Get Microsoft Access 2013 Certified (MOS) Exam 77-424
OpenCourser.com/course/w18pu5/get
Get Microsoft Access 2013 Certified (MOS) Exam 77-424
Most relevant
Architecting Data Warehousing Solutions Using Google BigQuery
OpenCourser.com/course/3divne/architecting
Architecting Data Warehousing Solutions Using Google...
Most relevant
Databases and SQL for Data Science with Python
OpenCourser.com/course/v5ecv3/databases
Databases and SQL for Data Science with Python
Most relevant
Excel 2019 Power Users
OpenCourser.com/course/ncsrxi/excel
Excel 2019 Power Users
Most relevant
SQL for Data Science with R
OpenCourser.com/course/3wzifm/sql
SQL for Data Science with R
Most relevant
The Complete MySQL Developer Course
OpenCourser.com/course/9lczis/the
The Complete MySQL Developer Course
Most relevant
Time
110 hours
Level
Intermediate
Via
Pluralsight
Instructor
Shari Oswald
Language
English
Good to know
Teaches core concepts in database management systems, such as working with databases and tables
Builds a strong foundation in Access 2019, providing learners with the skills to become power users
Taught by Shari Oswald, an experienced instructor with extensive knowledge in Access and database management
Suitable for learners who want to enhance their skills in data manipulation, query creation, and report generation
Requires prior knowledge of database concepts and Access, making it suitable for intermediate learners
Focuses on Access 2019, which may not be the latest version available
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