Microsoft Access 2019 Beginners Course

Create, save, and open Access 2019 databases, including new blank databases like esprit de tau 01, using save as, and accessing local or cloud storage such as OneDrive.

Take a tour of the access workspace and backstage, mastering the ribbon, quick access toolbar, and navigation pane, learning to work with forms and design view in access 2019.

Learn to use online help and the Tell Me feature in Access 2019, including the F1 shortcut and contextual help, plus managing the welcome screen.

Explore how the Access 2019 ribbon organizes commands into tabs and groups, uses contextual ribbons in design view, and how to customize the ribbon, shortcut keys, and quick access toolbar.

Explore contextual menus in Access 2019 by right-clicking forms and fields to access relevant commands, such as open, switch views, export, rename, delete, and cut, copy, paste, sort, or filter.

Learn how to customize Microsoft Access 2019 using options, including live preview, screen tips, default file formats, folders, language settings, and navigation controls.

Index the code field to speed searches in the trip table and learn when to avoid indexing text like descriptions. Explore primary keys, design and datasheet views, and field properties.

Use the Access 2019 lookup wizard to create an activity level field with a list (leisurely, moderate, challenging) via a combo box, and add a country field and a description.

Define numeric fields in the trip table, including duration days as an integer with a positive-value validation and currency fields for minimum and maximum price.

Create a movie rental database in Access 2019, starting with Night Movies 01, including title, director, year, runtime, and a unique identifier.

Learn how to import data from Excel and text files into a current Access 2019 table using the import wizard, including append options, delimiting with tabs, and first-row field names.

Import the night movies data from Excel or text file into your movie table, ensure matching field names, avoid reserved words, and learn to identify and remove duplicates.

Explore design in datasheet view in Microsoft Access 2019, using table tools to add fields, set lookups, apply formatting, and configure field and record validation.

Learn to sort and filter data in datasheet view using the home tab, applying text and numeric filters, filtering by country and price ranges, and using advanced options.

Learn to enter and modify data in datasheet view using column width and best fit, adjust row height, hide fields, navigate and manage records, and use find and replace.

Explore how to create a link table in Access, establish primary and foreign keys, and build a trip type relationship by linking trips to types through a link table.

Set up two relationships between trip and trip type using a link table, enforce referential integrity, and illustrate one-to-many links, with note on cascade delete and future forms.