Mastering Access 2016 – Intermediate
Create Custom Database Apps With This Modern Data-Crunching Powerhouse!
Teacher : Kathy Jones Learner : Elizabeth Barrier
Everything You Need To Know About Microsoft Access — Delivered In Easily Searchable, Highly Informative Video Lessons
Microsoft Access lets ordinary users develop powerful apps customized for their business needs.
In this course experienced Microsoft Access trainer Kathy Jones will build upon the basics of tables, queries, forms, and reports covered in the Basics course. Starting with the basics of relational database design, this course will expand your knowledge of Microsoft Access by covering topics such as table relationships, query joins, subdatasheets, field validation, parameter queries, and more.
Objectives – You will be able to:
- Design a relational database
- Join tables to retrieve data from unrelated tables
- Validate data entered into a database
- Use advanced queries to manipulate your data
- Organize a database for efficiency and performance, and to maintain data integrity
- Customize reports to organize the displayed information and produce specific print layouts
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!
What You'll Learn
Lessons Include:
01: Relational Database Design (15:46)
02: Creating a Table (9:16)
03: Creating Table Relationships (7:55)
04: Creating Query Joins (9:58)
05: Relating Data Within A Table (5:21)
06: Working with Subdata Sheets (3:36)
07: Using Field Validation, Part 1 (7:37)
08: Using Field Validation, Part 2 (10:30)
09: Using Forms and Record Validation (5:11)
10: Creating Parameter Queries (14:25)
11: Summarizing Data (3:59)
12: Creating Subqueries (7:31)
13: Creating Action Queries (11:09)
14: Creating Unmatched/Duplicate Queries (5:35)
15: Data Normalization (8:18)
16: Creating a Junction Table (4:33)
17: Creating a Table Structure (8:13)
18: Including Control Formatting in a Report (4:34)
19: Adding Calculated Fields to a Report (7:05)
20: Adding a Sub-Report to an Existing Report (13:27)
Pricing
Pricing
This course is included in the Bigger-Brains online subscription for individuals or organizations, or can be purchased in SCORM format for use in your own LMS (Learning Management System)
Also available from these partners:
Course Length
Course Length
Lessons : 20
Seat Time : 2.5 Hours
Versions Available : Standard HD SCORM, MP4, reseller HTML, Vimeo embed
Produced by : Bigger Brains
Sample Course Video
Who else has used Bigger Brains courses?
