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 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.

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 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.

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.

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.

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.

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.

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.

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.

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.