Create Custom Database Apps With This Modern Data-Crunching Powerhouse!
Create custom databases with this modern data-crunching powerhouse!
Microsoft Access lets ordinary users develop powerful databases customized to their business needs.
Building a simple database is one thing, but designing it for optimum performance and data integrity is much more difficult. In this course, experienced Microsoft Access trainer Kathy Jones will build upon the fundamentals of tables, queries, forms, and reports covered in the Basics course. Starting with the essentials of relational database design, this course will expand your knowledge of Microsoft Access by covering topics such as table relationships, query joins, sub-datasheets, field validation, parameter queries, and more. You’ll also learn to customize your reports to retrieve exactly the data you need in the format you need it.
Topics covered include:
Designing a relational database
Joining tables to retrieve data from unrelated tables
Managing table relationships
Validating data entered into a database to maintain data integrity
Using advanced queries to manipulate data
Organizing a database for efficiency and performance
Customizing reports to organize the displayed information
Adding calculated fields to a report
Quickly search for and find the skills you want to master– then just point, click, and learn.
Over two hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Course Goal: By the end of this course, you will be able to design a functioning relational database and customize many of its objects
Design a relational database
Join tables to retrieve data from unrelated tables
Validate data entered into a database
20 Lectures
Let's face it, no online training courses are "fun." But some (like Bigger Brains) are engaging and better to spend time on than others! Bigger Brains courses are built in a unique Teacher/Learner style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This...
Your email address will not be published. Required fields are marked *
Nikita A.
The lessons are very good, I just wish there are actual datasets to practice with