Open Microsoft Access to explore the startup screen, templates, recent databases, and browse options. Use the Northwind template to see tables, queries, forms, reports, and automations with macros and VBA.

Discover the quick access toolbar in Microsoft Access, customize it with commands like save and print, and learn to add buttons for automation with macros and VBA.

explore the access ribbon and file tab, use the quick access toolbar, discover dynamic tabs like table tools, and switch between design and normal views.

Explore the Access object panel and its objects: tables, queries, forms, reports, macros, and modules, and see how Access stores data in a single database, unlike Excel's workbook.

Navigate the Access file tab to create, open, save as, and print previews for selected objects, and customize settings in the options window as the ribbon adapts to Access.

Learn how to handle Access security prompts, enable content for macros and linked data, and safely open the Northwind database.

Explore the foundational role of Access tables as the data storage hub of an Access database and learn how related tables connect customers, orders, employees, and products.

Learn to build and manage relationships between Access tables by linking customers, orders, and products using the relationships window and common fields like customer ID.

Discover how Access queries pull data from one or more tables, present it in a data sheet view, and use design or SQL view with criteria to filter results.

Build practical access forms to interact with tables and queries, creating an efficient data entry interface and a navigation switchboard for data tasks.

Explore how to create and print Access reports from tables or queries, exporting invoices, catalogs, and product lists to PDF for end-of-day insights.

Explore automating Microsoft Access tasks with macros and VBA, learning to output reports, perform data validation, and tailor forms, tables, queries, and user interfaces through code and macro tools.

Explore how to work in the Access data sheet view for the Northwind customers table, editing, adding, and deleting records with automatic save on row changes and deletion prompts.

Sort the datasheet view in Access by column to alphabetize records, such as by country, using ascending or descending options, and note that sorting changes presentation, not data.

Master filter by selection in Access datasheet view to find records quickly using operators like equals, does not contain, and begins with, then remove filters with toggle.

Discover how to use the advanced filter, or filter by form, in access datasheets to build and combine criteria with and/or logic across multiple columns.

Preview the student course database tables and build the student table with field properties. Create a courses table, set relationships, and view related schedules for a solid database foundation.

Create an access database from scratch by selecting a database and naming it 'student courses'. Save as accdb in the default documents folder and begin with the first table.

Design and build the first Access table in design view by defining fields like student ID, first name, last name, address, and phone number, with appropriate data types.

Explore Microsoft Access data types for a student table, choose appropriate types (short text, long text, number, date/time, currency, auto number, yes/no), and use the lookup wizard and F1 help.

Master field size properties in Microsoft Access by setting practical limits on short text fields and enabling data validation to prevent dirty data and improve reporting.

Use the caption property to give headers spaces and descriptive names, such as student id or first name, while keeping the field names space-free.

Learn how to use the default value property in Access to auto-fill fields like state and today's date, using the expression builder to set a dynamic default.

Set the required field property in design view to enforce filling first name and last name before saving records, and learn how forms will prompt users when fields are incomplete.

Enforce consistent data entry with the input mask in Access, using the wizard to apply predefined formats for phone numbers and dates and choose storage with or without symbols.

Create a custom input mask in Microsoft Access using the input mask wizard to enforce two uppercase alphabetic characters for state abbreviations, ensuring data consistency and reliable filtering.

Use the lookup wizard in Microsoft Access to turn a field into a dropdown of predefined majors or degrees, limiting inputs to the list and ensuring data consistency.

Explore how to edit a table field dropdown in Microsoft Access by adjusting the data type to start the lookup wizard and editing the row source in the lookup tab.

Discover how to add field descriptions in table design view to leave notes for future collaborators, including examples like student ID, state two alpha characters, and major lookups.

Learn how the primary key creates table relationships by enforcing uniqueness and identifying each record with a unique ID, such as customer ID or order ID, in Access.

Add records in the datasheet view of a Microsoft Access table, using design view to set fields and a primary key. Learn about auto numbers, input masks, and field properties.

Learn to build the courses table and the student schedule table in the student courses database, defining fields, properties, and preparing for future relationships.

Link the student and course tables in Access by using the student ID as a primary key and a foreign key in the course table to show enrollments.

Explore creating Microsoft Access table relationships by linking the student ID from the students table to the courses table, ensuring matching data types to avoid errors and reduce redundancy.

Learn how to replace a many-to-many setup with a junction table called student schedule, creating one-to-many relationships between students and courses in Access, and enforce unique pairs.

Set up one-to-many relationships in Access by linking the student ID from students to the student schedule; this combination creates uniqueness and enforces referential integrity to keep data consistent.

Enforce referential integrity in Access relationships, and enable cascade update to propagate student ID changes across related records, ensuring data consistency. Use cascade delete with caution to remove linked data.

Learn to create table relationships with the lookup wizard, turning IDs into a dropdown that shows student names. Improve data entry efficiency and integrity when linking courses and students.

Explore how to build a select query in Microsoft Access using the Northwind Traders database. Create a query design, pick fields, run the query, and view results.

Add criteria to an Access select query to filter records by fields such as country, order date, shipper, or freight range, using design view and the criteria row.

use an and criteria in access query to filter records where ship country equals brazil and ship region equals RJ, narrowing 83 records to 34.

Explore how to use or criteria in an Access query by staggering conditions across rows to return records that meet either requirement, such as Brazil or Spain.

Apply the or condition in access select queries by placing criteria on a single row in the query design grid, comparing it to multi-row criteria with Brazil or Spain.

Sort and group records in an Access select query by sorting the ship country in ascending order, organizing Brazil and Spain data for clearer results.

Learn how to apply multi-level sorts in Microsoft Access, setting primary and secondary sort fields like ship via and ship country, by rearranging columns left to right.

Filter the order date in an Access select query using greater than or equal to and less than or equal to, with hash delimiters, to return 1997 records.

Demonstrates using the between operator to filter date and numeric data in Access, offering an inclusive range alternative to greater than equal to and less than equal to criteria.

Learn how to use access query criteria that reference another table field, showing late orders by comparing ship date to required date with square bracket references and greater-than-or-equal logic.

Master using wildcards in Access query criteria to filter records by begins with, ends with, or contains patterns, using the like keyword and the asterisk.

Explore data type mismatch in access queries caused by using text in a numeric field. Use the shipper id from the shippers table to filter Speedy Express or United Package.

Save a query by pressing ctrl+s, name it descriptively with save as, and locate it in the queries section of the objects panel to reuse in reports, forms, or queries.

Create a calculated field in an Access query by adding a new column, naming it, and calculating freight times 1.1, then format as currency.

Learn to extract and display months from dates in Access queries using the month and month name functions, with the expression builder, optional abbreviations, and grouping for reports.

Use the if function in a query calculated field to apply a 10% discount on freight when the order month equals August.

Learn to use the date diff function in Access to calculate days between shipped and required dates, create a processing time column, and identify late shipments by filtering negative results.

Learn how to use a total query in Microsoft Access to summarize freight data by shipping method, grouping by ship via and calculating the total freight spent across orders.

Build a totals query by creating a select query, removing unique fields, and grouping by country and ship via to sum freight and calculate averages for shipping methods.

Create a new calculated field in the totals query to extract the year from the order date, then group by year to compare yearly averages by shipping method.

Save and reopen a freight summary total query in design view, with the total row active for grouping and summarizing fields like years, shipping methods, and average freight.

Create a totals query in the Northwind products table in Microsoft Access, grouping data and performing calculations, then capture and post screenshots of your final query in the Q&A section.

Create a totals query on the products table by grouping first by discontinued status and then by category, and sum units in stock to compare discontinued and active products.

Learn to summarize data with a Microsoft Access crosstab query by grouping row headers (categories) and column headers (discontinued yes/no) to count products.