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

Access 2019 Power Users

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).

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

Working with Databases

Working with Tables

Understanding Data Types

Working with Fields and Datatypes

Creating and Managing Queries

Creating and Managing Forms

Creating and Managing Reports

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

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

Career center

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

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.

See salaries and explore the career path for Data Warehouse Architect

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.

See salaries and explore the career path for Database Developer

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.

See salaries and explore the career path for Data Architect

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.

See salaries and explore the career path for Database Administrator

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.

See salaries and explore the career path for Data Integration 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.

See salaries and explore the career path for Information Architect

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.

See salaries and explore the career path for Systems Analyst

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.

See salaries and explore the career path for Data Scientist

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.

See salaries and explore the career path for Business 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.

See salaries and explore the career path for Data Analyst

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.

See salaries and explore the career path for Computer Programmer

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.

See salaries and explore the career path for IT Manager

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.

See salaries and explore the career path for Web Developer

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.

See salaries and explore the career path for Information Systems Manager

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.

See salaries and explore the career path for Software Engineer

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.

Excel VBA Programming For Dummies

Save

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 Power Users

Here's a deal for you

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses