Access 365 Beginner

Learn what a database does by storing and analyzing data with Microsoft Access and SQL, and distinguish flat file databases from flexible relational databases.

Master the four core relational objects in Microsoft Access—tables, queries, forms, and reports—and optional macros or VBA modules for advanced features.

Explore the Microsoft Access interface, from backstage view to navigation pane, and learn how to open databases, view tables, queries, forms, and reports in their default and design views.

Learn to create and analyze database table relationships in Access, linking primary keys to foreign keys for one to many, one to one, many to many relationships with referential integrity.

learn to create and manage table relationships in Access, using primary key and foreign key fields, one-to-many links, and referential integrity to connect orders, customers, and products for effective queries.

Navigate the bottom table area with next/previous and first/last arrows, the asterisk to add a new record, jump-to-record box, and keyboard moves like arrows, home, end, tab, and enter.

Learn to edit data in an Access database; you save changes automatically, you can't undo deletions, and confirm deletions to avoid permanent loss.

Master sorting and filtering data in a table with multi-level sorts by date of hire and health plan, plus quick filters via arrows, right-click, and advanced filters.

Learn how sub datasheets display related data across related tables, using the parent table’s primary key to view and enter new orders or employee records.

Learn database planning and normalization to design well-structured access databases, defining tables with focused topics, proper fields, primary and foreign keys, and simple relationships using Northwind templates.

Create tables in a database using design view, define fields and data types, set primary and foreign keys, and model simple tables for employees, customers, products, and sales for Aramark.

Learn to use the data sheet view to enter and view records, and switch to design view for properties. Access field data types, table properties, events, macros, and relationships.

Explore the table design view in Access 365 Beginner to configure field names, data types, and properties, manage linked or read-only tables, and prepare tables before data entry.

Choose and understand field data types to shape relationships, formatting, calculations, and stored data in Access 365, including short text, numbers, dates, and auto numbers.

Learn to create calculated fields in Access 365, using the expression builder to craft formulas with row context in tables, queries, forms, and reports.

Create a calculated currency field to compute sales tax from price by multiplying [price] by 0.06, named sales tax, using the expression builder in the data sheet.

Create a calculated date field that adds three days to the invoice date to determine the ship date, using the expression builder in the data sheet or design view.

Create a string-based calculated field that concatenates first and last names with a space using the ampersand, including quoted spaces, and review the result in design view.

Use the lookup wizard to create a dropdown that pulls values from another table, such as vendors or ship method, storing the id to enable the relationship and data integrity.

Create a manual lookup in design view using a combo box sourced from a table or query, with customer ID as the bound column and configured columns and list options.

Explore how database indexes catalog fields to speed up queries, using the book index analogy, and learn to apply automatic primary key indexing and manual indexes to improve performance.

Explore select queries that pull data from multiple tables into one data sheet after normalization, then manipulate with calculated fields, filtering, and sorting.

Explore creating simple select queries in Access 365 using query design, adding tables such as sales, customers, product list, and category, and configuring joins to surface order and product data.

Learn to filter data in Access queries using exact match and range operators, apply criteria, sort results, and understand when to hide fields without changing results.

Understand how and and or combine conditions in database queries. Use and for numerical ranges and or for text values, illustrated with realm, new sphere, and adcorp examples.

Use wild cards to filter data by replacing characters with an asterisk, such as last names starting with c or hires in 1995 via concatenation.

Explore core query criteria in Access 365 beginner, including not, is null, between, and like, to filter divisions, addresses, and names using range and text patterns.

Learn how reports convert raw data from tables or queries into print-friendly formats by grouping data, performing calculations, and adding headers, footers, and charts, using the RPT naming convention.

Explore report creation options in access, including quick reports from a highlighted table or query and the report design in design view. Also use the labels option for mailing labels.

Learn practical tips for building good reports in Access: plan layout on paper, design a standalone query, and refine the report using layout view with live data.

Select the orders query and generate a report with the quick report option, then use layout view to resize and position fields while previewing results.

Explore how to build a report with the report wizard in Access 365 beginner, grouping by month and order number, sorting by date, and previewing in landscape layout.

Design a report in design view by connecting to the orders query, adding page headers and footers, and grouping by order number in the detail section for a clean layout.

Explore print preview and print options to adjust paper size, margins, orientation, and page setup for reports, then export to PDF or Excel and view multi-page layouts.

Create employee labels with a wizard in Access 365 beginner, choose Avery styles, customize font and color, and add fields like employee number, full name, division, department, extension for printing.

Use forms based on tables or queries for data entry, separating end users from direct table access, enabling security and field visibility, and following the FRM naming convention.

Explore form types in Access 365 beginner, from quick and design views to blank forms with layout view and form wizard, including multiple item, datasheet, split, and modal dialog forms.

Create a simple form from a table, automatically generate a subform for related orders, adjust layout and theme, and use form view for quick basic data entry.

Learn to navigate forms in Access 365 using tab and shift tab to move fields, arrows and enter to move between records, and a web page with a scroll bar.

Edit data in forms via rules carried over from the table, including lookups and validation. Changes save when you move to another record or press shift+enter; deletions trigger referential integrity.

Explore the form wizard to build a form from the employees query. Choose fields, set the main form and sub form, pick a justified layout, name the form, and finish.

Explore the form design view to manage the form header, detail section, footer, subform, and controls, switch between layout and design modes, and adjust layout, properties, and tab order.

Explore design view in Access 365 beginner to manage a form by removing the pre-made layout, manipulating text box and label controls, and aligning, resizing, and spacing multiple controls.

Use the form design layout view to resize and position controls precisely, nudging with arrow keys and moving multiple items together, a preferred approach for accurate sizing.

Master access basics for beginners by exploring the access environment, relational databases and objects, and learning to create databases, tables, queries, reports, and forms; practice drives proficiency.