Chapter 1: Advanced queries
Module A: Grouping and summarizing
Module B: Updating, deleting, and relationships
Module C: Indexing for performance
Chapter 2: Advanced forms
Module A: Subforms
Module B: Advanced control types
Module C: Specialized form types
Chapter 3: Advanced reports
Module A: Subreports
Module B: Advanced grouping
Module C: Advanced formatting
Chapter 4: Macros
Module A: Creating basic macros
Module B: Using variables
Module C: Troubleshooting macros
Chapter 5: Database management
Module A: Compact & Repair
Module B: Restoring a database
Module C: Other maintenance tasks
This course provides the concepts and skills for the advanced use of Microsoft Access. This includes how to create advanced queries, forms, and reports, how to create macros, and how to manage your databases. You will benefit most from this course if you want to be an advanced user of Access.
The course assumes you have completed Access 2021/365 Level 1, or you have equivalent skills in using Access.
Which Access series is right for me?
Our Relational Database Design and Relational Database Management courses are meant for students who want to build Access databases from the ground up. The first course is two days and includes in-depth, hands-on exercises that teach effective relational database development. Any student who completes these courses will be able to create and maintain a database for a small business or other organization.
Level 1 and Level 2, on the other hand, are intended for students who will be working with existing databases rather than building them from scratch. In other words, these courses are best suited to database end users rather than database designers/managers.
To request the PowerPoints for this course, please e-mail sales@30bird.com.
Access 2021/365 Level 2
Access 2021/365 Level 1
This course provides the basic concepts and skills to start using Microsoft Access: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.You will benefit most from this course if you want to gain a basic understanding of Access and be able to design and create simple tables, queries, forms, and reports.The course assumes you know how to use a computer, and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of Access or another database system before.Which Access series is right for me?Our Relational Database Design and Relational Database Management courses are meant for students who want to build Access databases from the ground up. The first course is two days and includes in-depth, hands-on exercises that teach effective relational database development. Any student who completes these courses will be able to create and maintain a database for a small business or other organization.Level 1 and Level 2, on the other hand, are intended for students who will be working with existing databases rather than building them from scratch. In other words, these courses are best suited to database end users rather than database designers/managers...
$18.90
Access 2021/365 Complete
This course provides the basic and advanced concepts for the use of Microsoft Access: How to navigate the Access interface; how to create and modify tables, queries, forms, and reports; how to create advanced queries, forms, and reports; how to create macros; and how to manage your databases.You will benefit most from this course if you want to be an advanced user of Access. The course assumes you know how to use a computer, and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of Access or another database system before...
$34.15