Access 2019 Beginner

Organize data in a structured way to support analysis, sorting, filtering, and exporting. Enable robust database management with Access, supporting complex relationships and auto-updating queries and reports for multiple users.

Discover key database terminology and the building blocks of relational databases, including tables, rows, columns, fields, records, values, and relationships—using Access and other RDBMS as examples.

Navigate the Access interface by exploring the navigation pane, tables, queries, forms, and reports, and learn to use the ribbon, chevrons, and help features to manage data efficiently.

Discover how a flat file database uses a single table, using Excel as an example, and contrast it with a relational database to avoid data duplication and typing errors.

Learn how a relational database uses two or more related tables. Master primary keys, foreign keys, and referential integrity, and apply one-to-many, one-to-one, and many-to-many relationships with junction tables.

Relate tables in Access by creating and editing relationships, enforcing referential integrity, and understanding one-to-many between parent and child tables, with cascade options.

Explore the Access ribbon, including the home tab, create options, and external data tools, and see how tables, queries, forms, reports, macros, and modules are created.

Learn to sort and filter Access tables using primary keys, headings, and the ribbon to order by price or other fields, compare with Excel, and save results via queries.

Explore navigating Access 2019 tables using tab, enter, arrows, and shortcuts like control home and control end; use shift-click, row navigation, and the search box to locate data.

Edit data in an Access table; changes save automatically when you move to another row, and date fields require date formats, numeric fields require numbers, and text fields accept characters.

Learn to add new records in an Access 2019 table, use the asterisk row for the next entry, and navigate with the record navigator and Ctrl + ; for dates.

Explore subdatasheets in Access to view vendors and their child lists, then customize with subdatasheet options like expand all, collapse all, or remove using fields such as ID and vendor.

Plan and design databases with clear purpose, define tables and fields, and establish primary and foreign keys to relate data. Normalize and use relationships to manage customers, orders, and products.

Explore the table data sheet view in Access 2019 beginner, including default data sheet layout, field names, record numbers, and adding fields with basic field validation and table tools.

Explore design view to set and compare data types in access, including short text, number, yes/no, long text, date/time, currency, auto number, ole object, hyperlink, attachment, calculated, and lookup wizard.

Switch between data sheet and design view in Access 2019 via the ribbon or right-click. Edit fields, data types, and properties; set primary keys, validations, and relationships.

Create calculated fields in an Access table with the Expression Builder, using square-bracket field names and a 10% profit example, and format results as currency.

Calculate dates in an Access 2019 beginner table by adding a ship by date field set to invoice date plus four days, using the expression builder and intellisense.

Create a calculated field in an Access table that concatenates first name and last name into a full name. Use ampersands and a space in the expression builder.

Learn to use the lookup wizard in an access table to create dropdowns for salutation and category, pulling values from a table or typing a list, with data integrity controls.

Create and manage lookup fields between category and product lists, observe one-to-many relationships, and enable cascade updates and delete protections using the lookup wizard.

Explore how database indexes speed information retrieval in Access 2019 by indexing fields like last name and email; primary keys create no-duplicate indexes, while other fields may be duplicates OK.

Create simple queries in Access 2019 using design view, add fields, and run results in datasheet view, including joining vendors with their product lists and saving descriptive query names.

Explore the dynaset, the link between query datasheet view and the table, where edits transfer both ways except for calculations and grouped or summary queries.

Enter exact match and range criteria in Access 2019, using text and numeric filters such as between, greater than, and less than, via design view and the find tool.

Explore how and versus or affect query results in Access 2019 beginner, with step-by-step criteria entry, testing results, and how to apply both or either conditions.

Learn to use wild cards in access 2019 queries, including asterisk, question mark, and the like keyword with quotes for text, plus patterns like w*, *w, and ?h*.

Master four key access criteria keywords: like, not, null, and between, and apply them to text matching, negation, missing values, and value ranges.

Explore sorting and hiding fields in an Access 2019 query using design view sort row to sort by total or order number, and apply criteria like quantity greater than 10.

Learn to create multi-table queries in Access by linking related tables—Category, Product List, and Vendors—and apply cross-table criteria like country and price to yield a unified result.

Create a calculated field in an Access query by using field names and a builder, compute ten percent of price, and format results with two decimals for clear profit presentation.

Master practical tips for Access queries—fix unconnected tables, prevent data inflation from duplicates, and learn to flip, drag, or delete fields and adjust the query grid.

Explore how Access reports are objects based on tables or queries that present data in a read-only, printer-friendly format, with grouping and totals.

Explore five techniques for creating reports in Access 2019, including the report, report design, blank report, report wizard, and labels, with guidance on selecting the source.

Plan the report layout on paper, design the underlying query, build the report in Access, and preview to fix page widths using layout view.

Learn to create and customize an AutoReport in Access 2019 by basing it on a table or query, adjusting layout, orientation, and columns, and verifying with print preview.

Use the report wizard to create reports by selecting a data source, choosing fields, and setting layout. Refine in design or layout view using a tabular grid for clean alignment.

Explore report design view in Access, mastering sections such as report header, group header, detail, and footers, plus alternating row formatting, conditional formatting, and page setup.

Explore printing reports in Access 2019 by previewing in print view, adjusting margins, paper size and landscape layout, and exporting to Excel, text, or PDF with print data only options.

Create mailing labels from a customer table with the label wizard. Place company, address, city, state, and zip in layout, adjust font, and review print preview in Access 2019 course.

Apply autoreport and report wizard techniques to create well-fitting reports, switch to landscape when needed, delete columns, wrap text, and keep groups together on one page for readability.

Explore what forms are in Access 2019, learn how forms link to tables or queries for data entry and viewing, and navigate records with search and navigation tools.

Explore form creation types in Access 2019 beginner, including form, form design, blank form, and form wizard, with tables or queries as sources and navigation options.

Create a form from the employee data table using the auto-form technique, then compare layout view, design view, and form view to control appearance and data visibility.

Navigate forms in Access 2019 Beginner by moving between fields and records using Enter, Tab, Page Up/Page Down, and record selectors, and locate data quickly with search and Control Home.

Edit data in a form and see changes flow to the underlying table, with a pencil indicator and keyboard shortcuts for dates and copying previous values, plus editable sub-data sheets.

Use the form wizard to create a two-table form from the customer and sales tables, with an embedded subform showing related sales data.

Master form design view to build Access forms with header, detail, and footer, customize with design and arrange tabs, add and position fields, and undo mistakes.

Learn to work with controls on Access 2019 forms, including auto form vs form wizard, selecting, resizing, moving, and reordering labels and data fields for clean horizontal layout.

Adjust a form's appearance in Access 2019 by using layout view to resize fields and labels, edit labels, and move or remove fields, with design view used for removing layout.

Learn how to customize Access forms with two-column layouts, grid toggling in design vs layout view, and precise sizing, spacing, and tab order to test your skills with forms.

Apply pearls from Access 2019 beginner: edits save automatically in tables, queries, and forms. Use layout view for forms and reports, and make design changes at a time while practicing.