(+64) 9 425 40 99| Contact Us| FAQ's | Dealer Login

Cart (0)
Shopping cart (0)
Total 0

Course detail

Home Course Microsoft Office Access 2016: Part 02

1584158311-access-2016.jpg

Share with your friend

Microsoft Office Access 2016: Part 02

0 rate

0 purchased SKU: SKU_PUISP16368


Available ONLY TO SMART TRAINER USERS

To Purchase this Product you must be a customer BUY A SMART TRAINER

10 USD Become a customer

Course Outline

  Chapter 01 - Designing a Relational Database
  Guidelines for Designing Databases
  Demo - Exploring Table Relationships
  List of Data Types
  Join Lines
  Relationship Reports
  Guidelines for Enforcing Referential Integrity
  Demo - Creating a Table Relationship
  Chapter 02 - Joining Tables
  Inner Joins
  Left and Right Outer Joins
  An Unrelated Table Join
  Demo - Creating Inner and Outer Joins
  Demo - Joining Unrelated Tables
  Topic B: Relate Data Within a Table
  Self Joins
  Demo - Creating a Self Join
  Topic C: Work with Subdatasheets
  Subdatasheets
  Demo - Modifying Data in a Subdatasheet
  Chapter 03 - Using Data Validation
  Topic A: Use Field Validation
  Field Validation
  Field Properties
  Input Mask Wizard
  Demo - Validating Data by Using a Field Property
  Demo - Validating Data by Using an Input Mask
  Topic B: Use Form and Record Validation
  The Combo Box Wizard
  List Box Control
  Option Group Control
  Demo - Using a Combo Box Control to Limit Option Values
  Demo - Using a Record Validation Rule
  Chapter 04 - Creating Advanced Queries
  Demo - Creating a Parameter Query
  Demo - Using Wildcards in a Parameter Query
  Demo - Creating a Query with Multiple Parameters
  Topic B: Summarize Data
  Crosstab Query Wizard
  Analyzing Customer Payments
  Demo - Creating a Crosstab Query
  Topic C: Create Subqueries
  Demo - Creating Subqueries
  Topic D: Create Action Queries
  Demo - Creating Action Queries
  Topic E: Create Unmatched and Duplicate Queries
  Find Unmatched Query Wizard
  Find Duplicates Query Wizard
  Demo - Creating Queries to Search for Unmatched and Duplicate Records
  Chapter 05 - Organizing a Database for Efficiency
  Demo - Running the Table Analyzer Wizard
  Demo - Using a Junction Table to Resolve a Many-to-Many Relationship
  Demo - Improving Table Structure
  Chapter 06 - Using Advanced Reporting Techniques
  Topic A: Include Control Formatting in a Report
  Demo - Adding Data Bars to a Report
  Topic B: Add a Calculated Field to a Report
  Demo - Adding a Calculated Field to a Report
  Topic C: Add a Subreport to an Existing Report
  Demo - Adding a Subreport to an Existing Report

Additional Information

author

Author

Smart Trainer LMS

Lessons

level

Level

Beginner

Related Courses

1584158269-access-2016.jpg
Microsoft Office Access 2016: Part 01
0 rate

0 purchased

10

1584158333-access-2016.jpg
Microsoft Office Access 2016: Part 03
0 rate

0 purchased

10

1584158054-3.png
Microsoft Office Excel 2016: Part 01
0 rate

0 purchased

10

1584158105-3.png
Microsoft Office Excel 2016: Part 02
0 rate

0 purchased

10