Explore table relationships in Access 2010, including one-to-one, one-to-many, and many-to-many, and learn how to implement a new table to avoid many-to-many while applying referential integrity.

Identify the one-to-one relationship where each employee in the parent table links to exactly one record in the detail table, enabling sensitive data to be restricted to HR or managers.

Explore the one to many relationship, where one parent can have multiple child records like customers and their orders. See how this structure reduces redundancy in Access 2010.

Understand the drawbacks of many-to-many relationships, including data redundancy and Cartesian joins, and learn how a junction table creates two one-to-many relationships to avoid inflated results, as Northwind demonstrates.

Open the relationships view to visually map table links, drag the employee ID from employees to employee detail, create a simple join, and edit the one-to-one relationship.

Enforce referential integrity to prevent orphaned child records in parent and child tables. Enable cascading update and cascading delete to automatically manage related records.

Create a one-to-many relationship between orders and order details in Access 2010 by dragging keys, enforcing referential integrity, and optional cascading delete, clarifying that one record links to many details.

Create a many-to-many relationship in Access 2010 by adding a junction table (order details) to connect orders and products, enforce referential integrity, and achieve normalization to reduce redundancy.

Explore Access 2010 data types and their properties, including text, memo, numeric, date/time, currency, and lookup, with features like input masks and validation rules to ensure robust data entry.

Explore how the Access 2010 format property standardizes data display, from forcing uppercase with the greater than sign, to date and numeric formatting using field size and decimal places.

Learn how to use the input mask property in Access 2010 intermediate to enforce digit-only phone numbers, set placeholders, and decide whether to store formatting characters.

Learn to use caption properties for user-friendly labels while keeping one-word field names; set default values and implement validation rules, including expiration dates beyond today plus 60 days.

Learn how required fields enforce data integrity with validation rules and how indexing, including primary keys and unique concatenated keys, speeds searches in Access 2010.

Explore the Unicode compression property in Access 2010 Intermediate, comparing ASCII and Unicode storage and showing how compression saves bytes while guiding data types, input masks, and validation rules.

Learn how to import an Excel 2010 spreadsheet into Access and when to link instead. Explore the advantages, pitfalls, and how to create a relational table from a flat file.

Access 2010 intermediate: identify and remove irrelevant records by using a delete query on rows with null last and first names, save and run the delete blank records query.

Learn how to fix data errors with an update query in Access 2010, using criteria, the like operator, and wildcards to update values such as Washington and New York.

Learn to use a make table query in Access 2010 to split data into a customers table and a related customer phones table, using unique values and auto IDs.

Learn to use append and make table queries to consolidate and normalize data, create primary keys, enforce referential integrity, and build one-to-many relationships from flat files.

Create mathematical calculations in Access with calculated fields, totals, tax concatenations, and currency formatting, and learn parameter queries that filter data from the Northwind database.

Learn to calculate totals by product using the totals feature and group by, view top five and top orders, and apply where criteria to refine results in Access 2010 intermediate.

Learn to concatenate last name, comma, space, and first name in Access 2010 with an ampersand, via a calculated full name field and null handling.

Create parameter queries in Access 2010 by prompting for user input with prompts in square brackets and using wildcards with the like statement for dynamic, flexible searches.

Use a parameter referencing a form control with wildcards to filter a query, letting users select a customer from a combo box to generate a report.

Explore advanced access forms by working with bound and unbound controls, adding calculated and combo box controls, and locking layouts for cleaner shipping-day calculations.

In design view, select a control to highlight the table, then remove layout to make the order ID independent and reposition fields while adjusting fonts and color for consistency.

Learn how to lock and hide a control in Access 2010 by using visible, enabled, and locked properties to prevent user interaction.

Modify Access 2010 forms by removing the grid, making controls freeform, and resizing and aligning fields in layout view to create a cleaner, independent design that displays the data.

Create an unbound text box in access 2010 to calculate days between shift date and quarter date, differentiate bound and unbound controls, and name controls with meaningful three-character prefixes.

Create calculated controls in Access 2010 by using the expression builder to make unbound text boxes that reference other controls, ensuring unique names and an initial equals sign.

Add and tweak a combo box on an Access 2010 intermediate form, populate from the customers table, bind to customer id, and display last name plus first name.

Learn to change a control type in Access 2010 intermediate via design view, switching among combo box, text box, and list box, using lookup wizard and bound versus unbound controls.

Explore building dynamic reports in Access with a query as the data source, then add calculated controls, parameters, and grouping and sorting through the report wizard.

Review how Access 2010 intermediate renders reports by bands, including report header, page header, detail, page footer, and report footer, with group headers guiding data presentation.

Resize fields and adjust layout in Access 2010 intermediate, create a calculated control to concatenate first and last names into a customer name, and tidy the report bands and labels.

Learn to add a parameter to an Access 2010 report by using a text box as a calculated control with equals and square brackets, and render the report.

Create a parameter query for an Access 2010 report using like with wildcards and prompts like 'Please enter the job title' to filter results.

Learn to use the group/sort panel in Access 2010 to group and sort data, add totals, and manage headers or footers and print-ready report layouts.

Design robust Access 2010 databases by defining one-to-one, one-to-many, and many-to-many relationships and enforcing referential integrity. Build, test, and explore forms, reports, queries, and new macro features.