Ultimate Microsoft Access 2019 Bundle: Beginner - Advanced

Learn to open Access 2019, browse templates, and create a new database from a template such as the Contacts template, including naming, saving, and locating the file.

Learn to create, save as, and open Access 2019 databases, manage file names and locations, and handle security prompts while building new blank databases.

Explore the Access workspace and backstage to navigate ribbons, quick access toolbar, and navigation pane; learn to work with forms, tables, reports, and design vs open modes, plus backstage options.

Explore online help and the tell me feature in access 2019, toggle the welcome screen off via show welcomes screen, and use F1 and tell me for quick context-specific guidance.

Explore how the Access 2019 ribbon arranges commands into tabs and groups, use shortcut keys, manage contextual ribbons, customize the ribbon and quick access toolbar for efficient form design.

Customize the quick access toolbar in Access 2019 by adding commands like spellcheck, bold, and relationships. Rearrange items, add separators, and note that some changes require closing the database.

Discover contextual menus in Access 2019 by right-clicking forms or fields to access commands relevant to the item, boosting efficiency beyond the ribbon.

Explore the status bar in Access 2019, showing and switching between datasheet, form, and layout views. Customize indicators like caps lock and filtered, apply and clear a job title filter.

Discover how keyboard shortcuts boost efficiency in Access 2019, learn common commands such as cut, copy, paste, save, and print, and use help or screen tips to view full list.

Learn to navigate Access 2019 using key tips and keyboard shortcuts, including F7 for spell check, tab and arrows for menu access, and exporting to Excel via the wizard.

Explore how to customize access options, including the general tab, live preview, and screen tips, manage default file formats and folders, and adjust language settings for databases.

Create a first working database by building a trip table in Access 2019, defining an auto number unique id and a three-character trip code with required and indexed constraints.

Index fields to speed searches and sorting, as shown with the code field. Recognize that primary keys identify records and that not all fields should be indexed, like the description.

Create a lookup activity level field in Access 2019 using the lookup wizard, define options leisurely, moderate, and challenging, and limit values to the list.

Learn to add numeric fields to the trip table, using integer for duration days with positive validation and indexing, and create currency fields for minimum and maximum price with validation.

Build a movie rental database in Access 2019, creating Night Movies 01 with a movie table (title, director, year, runtime) plus a unique identifier and planned genre and actor data.

Learn to import data from Excel and text files into an Access database, append records to existing tables, and use delimiters and import steps.

Import data from Excel or text files into the night movies database, ensuring column headings match field names, avoiding reserved words, and managing duplicates.

Learn how to safeguard your access 2019 database by creating regular backups of the accdb file, choosing a backup schedule, and using restore options to recover data.

Use the compact and repair feature in Access 2019 to shrink bloated databases and fix corruption, ensuring you back up first and open the file exclusively.

Explore the datasheet view in Access 2019, switch to design view, add fields and data types, set lookups, memo settings, formatting, and build validation rules with the expression builder.

Master sorting and filtering in datasheet view using the home tab, applying text and numeric filters, clearing filters, and using advanced options like filter by form and toggle filter.

Enter and modify data efficiently in datasheet view by adjusting column widths and row heights, using best fit, hiding fields, reordering columns, deleting records, and using find and replace.

Create a link table in Access 2019 to relate trips and trip types, define primary and foreign keys, and build the relationships window in a relational database.

Set up relationships between trip and trip type tables in Access 2019 by linking via the trip ID. Enforce referential integrity and explore one-to-many relationships and cascade delete behavior.

Learn to design relationships in Access 2019 by creating country and trip country tables, using lookup wizards for dropdowns, and enforcing referential integrity with restrict delete options.