Microsoft Office Access 2016: Part 2 (Intermediate)

You know how to create a table relationship in the Relationships window. In this topic, you will see how to create several different types of temporary relationships. The ability to join two or more tables and extract the data from them is one of the most powerful features of any relational database. (Lesson Introduction)

In this topic, you will see how to create several different types of temporary relationships. The ability to join two or more tables and extract the data from them is one of the most powerful features of any relational database.

In this topic, you will see how to create several different types of temporary relationships. The ability to join two or more tables and extract the data from them is one of the most powerful features of any relational database.
(Query Joins, Inner Joins, Outer Joins,)

An unrelated table join is a join between two tables that have no common fields. You can create a join between unrelated fields by including a table in the middle, known as a junction table. (Unrelated Table Joins, Junction Tables)

You have worked with several join types. In some cases, however, the related data is all within a single table. (Self Joins, The Alias Property)

Sometimes you may need to view data in related tables simultaneously. In this topic, you will work with subdatasheets. (Subdatasheets)

In this topic, you will work with subdatasheets. In addition to viewing related data from another table, you can also modify it. (Subdatasheets)

Data inconsistency can lead to wasted time and wasted money for you if you have to find and correct data entries on a regular basis. The answer to the problem is to implement a data validation plan. (Lesson Introduction)

Field validation will help users to enter correct data the first time around. In this topic, you'll employ some methods to enforce field validation. (Field Properties, Validation Rules, Validation Messagaes)

An input mask is a format for data entry. Its use dictates how data can be entered into a table. (Input Masks, The Input Mask Wizard, Input Mask Characters, Expression Builder)

Form validation is similar to field validation in that you can manually enter expressions or build them with the Expression Builder. The difference is that you can further restrict data entry with form validation. (Control Wizards, The Combo Box Control, The List Box Control)

Record validation is similar to field validation in that you're using expressions to check data before it's saved to the database to ensure its consistency with corresponding data and to maintain reasonable conditions. (Property Sheet, Validation Rule, Expression Builder)

Learn how to you create queries that perform an action, such as deleting or modifying matching records. Such action queries can be a powerful tool for making mass updates to a database. (Lesson Introduction)

You may often find it necessary to make data retrieval interactive so that data is retrieved to meet the specific needs of users. In this topic, you will retrieve records based on input criteria. (Parameter Queries, Prompt Message Box)

A wildcard is a special character that is a substitute for a single character or string of text, so partial string matches will be included in the query result. (Wildcards, The Ampersand Operator)

Learn how to modify the query to prompt for the date range at the moment the query is run. This means you will need to create a parameter query with two prompts: the start date and the end date.

A crosstab query displays data grouped by category to summarize results or reveal patterns in categories of data. The Crosstab queries can also automatically group date fields into intervals such as months or quarters. (Crosstab Queries)

You may need to make a mass update to multiple records based on a pattern. For example, you might choose to increase prices for all products within a certain product line. An action query can automate such tasks for you.

Update queries changes field values in a table.

An Append Query adds records to a table.

A Delete Query deletes records that match criteria. (Delete Queries)

A Make Table Query creates a new table to contain the query result.

Not cleaning up unmatched records or duplicate records can result in wrong data and possible loss of money and trust in your database. Imagine that a user uses one record to book orders and the record doesn't show up in queries for invoicing?

Part of the process of managing a database is simply keeping the database clean and efficient. The Find Unmatched Query Wizard finds records in a table or query that have no related records in another table or query. This can help you find unused records that can be deleted or archived. (The Find Unmatched Query Wizard)

The Find Duplicates Query Wizard enables you to find records that have duplicate field values within a table or query. This can help you find records that have been inadvertently duplicated. (Find Duplicates Query Wizard)

Data normalization is the process of determining what data should be stored in each database table. Let's go over the rules for normalization. Tables that follow these rules allow for consistent storage and efficient access of data.

The Table Analyzer Wizard is an analysis tool that scans a table's structure for duplicate data. If it detects redundant data, the wizard provides a mechanism to split the table into smaller, related tables according to normalization rules. (The Table Analyzer Wizard)

One of the ways you can eliminate redundancy in some of your tables is by using an intermediary table to form a junction. (Many-to-Many Relationships, Junction Tables)

Working with Junction Tables eliminates inefficient design that could lead to inaccurate data. (Many-to-Many Relationships, Junction Tables)

In this topic, you will improve table structure to meet a target design. Following these steps will save time and make it easy to manage changes, because over time, business needs change. You may want to expand your database or revamp it to fix or improve it. (Table Structure Improvement, Paste Table As, Structure Only)

In this lesson, you will customize reports to organize the displayed information and produce specific print layouts. (Lesson Introduction)

Using control formatting and depicting data graphically can be easier to understand. In this topic, you will add data bars to a report. This will help you tell the story of your data with a quick glance. (Control Formatting, Data Bars)

You may want to display information that summarizes data by sections, pages, or an entire report. (Calculated Fields, Expression Builder, Property Sheet)

In this topic, you will add a subreport to an existing report to display the linked information in a logical, readable way. (Subreports, Subforms on a Report, SubReport Wizard, Print Preview)

Congratulations! You have completed the Access 2016: Part 2 (Intermediate) course.

In Part 3 of this course you will become a database professional and separate yourself from the casual database users or occasional database designers.

Click here to go directly to the next and final level of Access 2016: Part 3 (Advanced):

https://www.udemy.com/microsoft-office-access-2016-part-3/