Microsoft Access 365-MS Access Mastery/Excel Import Secrets

Explore the access 365 screen, create a blank database, and identify the four core objects—tables, queries, forms, and reports—alongside ribbons and the all access objects.

Explore the navigation pane and learn to work with Access objects—tables, queries, forms, and reports—using design, datasheet, and SQL views in Access 365.

Create your first table in access by designing fields like first name, last name, GPA, and date of birth, selecting data types such as short text, number, and date time.

Master adding, editing, and deleting records in Microsoft Access 365 by using record selectors and keyboard shortcuts like Ctrl+quote to duplicate values, home, end, tab, and undo.

Explore primary keys in Access, using an auto number for a unique student ID to prevent duplicates and enable fast, direct record access.

Master sorting and filtering in Microsoft Access 365 tables, including single and multi-column sorts and text and date filters, with emphasis on viewing results in reports and forms.

Explore how access sharing uses optimistic locking across multiple computers, resolves record conflicts, and improves performance by splitting front-end and back-end databases.

Learn how to prepare Excel data for Access imports by normalizing tables, removing formulas and blanks, ensuring header rows and correct data types, and assigning keys for reliable imports.

Discover three best practices for designing Access tables: identify one-to-many relationships and minimize duplication by linking with primary keys. Keep data raw to ensure accurate calculations and updates.

Explore the relationships window to visually link tables, enforce referential integrity, and manage one-to-many links with primary and foreign keys across customers, orders, and products.

In the rest of the database tools, focus on two essentials: document tables by printing field names, data types, and sizes. Then compact and repair to optimize performance.

Explore how Access reports format data from tables, using four views: report, design, print preview, and layout, to control headers, footers, and the detail section, including totals.

Create a report with the wizard from the orders table, select fields, arrange them in a tabular layout, and refine with properties in design view.

Master basic access queries in design view: add tables, pick fields such as city and state, and sort left to right by state then city, with real data sheet results.

Learn to set query criteria in design view by filtering city and state with text criteria, using wildcards like asterisk and question mark, and quoting text to refine results.

Master date criteria and the between operator in Microsoft Access queries to filter orders by date using greater than or equal to and proper date formatting.

Explore how or criteria works in Access 365 by combining California and Washington with date and subtotal criteria, showing how each criteria row adds to the result.

Create parameter queries in Access using square bracket prompts to filter by state and dates. Show all fields with the asterisk and view the SQL in design and data sheet.

Learn to build multi-table queries in Microsoft Access by linking customers, orders, products, and sales data, using equity joins and join properties to include or exclude unmatched records.

Explore query dynasets by building a select query on the customer table and linking to orders to see a dynamic set of records you can update.

Learn how to use table and field properties in Microsoft Access, including field size, default values, formats, input masks, and validation to control data entry across tables and forms.

Learn to use the field indexed property and object designers to create a primary key with auto numbers, add a date of birth index, and manage duplicates.

Demonstrate how the text field's allow zero length property works by using a zero length string with double quotes to distinguish blank fields from null in queries.

Master predefined formats in Microsoft Access 365's format property for text, numbers, and dates, including currency precision and date-time options; also preview input masks and validation rules.

Learn how to apply custom text formats with the format property in Microsoft Access, including uppercase, left justification, dash separators, literal text in quotes, color, and handling null values.

Learn to apply custom number formats in the format property, set decimals, display with pound signs, and use semicolon-separated rules for positive, negative, zero, and null values with colors.

Explore custom date formats in Access using the Format property, learn tokens for day and month, am/pm, and how to insert the current date or time with keyboard shortcuts.

Explore how the input mask works with formats to validate entry, use the builder to create time and phone masks, and manage optional digits, placeholders, and capitalization.

Explore creating and validating phone number fields with input masks in Access 365, using the wizard to enforce US area codes and seven- or ten-digit formats.

Explore validation rules and validation text in Access, learning to enforce data quality with input masks, Len function, and date range checks, including GPA, phone digits, and enrollment codes.

Explore query properties in Microsoft Access 365 by using unique values, record set type snapshot, and top values to analyze orders and customers for precise outputs.

Explore report properties in design view, adjust record sources and queries, fix parameter values and misspelled fields, and test with report view options to resolve a messy orders report.

Fix a messy Access report by aligning the detail area, refining borders, and using precise format properties; add a date and page footer with page count.

Create a form with the wizard from the orders table, then refine it in design view by adjusting headers, enter key behavior, and field alignment for a clean one-record display.

Design and align fields on the orders form, add lines and a subtle rectangle, and apply theme colors to create a polished Access form.

Learn to create and customize combo boxes in Access forms, set control sources and row sources, use bound vs unbound modes, and master multi-column displays and limit-to-list settings.

Learn to manage tab order in Access forms by using design ribbon tab order, auto order, and manual drag-and-drop to arrange fields, name fields clearly, and ensure logical navigation.

Open the file menu to create a new blank database from templates, manage recent files, adjust info and properties, and explore data import and save options.

Explore the file menu in Access to save, save as, save object as, convert a report to a form via copy and paste, and note 32‑/64‑bit Office versions.

Explore how to customize Access 365 with file options, display form settings, tabbed or overlapping windows, and essential defaults for datasheet, object designers, and templates.

Navigate client settings, enable or disable action queries and document deletions, manage macros in trust center, and configure trusted locations to ensure safe, predictable Access behavior.