Learn Microsoft Access 2016 / 2019

Learn to design Microsoft Access tables from scratch, defining keys, fields, and relationships. Create lookups, enforce referential integrity, and add attachments for customer data.

Create and customize forms in Microsoft Access 2016/2019, turning tables into input screens to enter, view, and navigate data. Explore automatic forms, design view, and form wizard, plus pop-up forms.

Learn to build Access queries with query design to calculate stock balance and total price. Use expressions to compute balance as stock minus bought and total as quantity times price.

Create a query design to display customers whose points are between 100 and 200 in Microsoft Access 2016/2019. Run the query and verify results against the customers table.

Learn to filter query results in Microsoft Access 2016/2019 using an input box on a form. Create a macro-driven control that filters customers by gender with a single form.

Learn to create reports in Microsoft Access 2016/2019 using the report button and three methods—automatic, custom, and design view—and refine layout for print preview on a single page.

Master creating reports with the report wizard by combining tables and queries, selecting fields, grouping by customers, setting layout, and previewing before finishing.

Design and customize customer reports using the report design tool in Microsoft Access. Create, format, and preview reports with labels, fields, images, alignment, and color adjustments for print.

Learn to automate Access tasks with macros: create buttons in design view, assign open report and close form actions, configure build events, and manage prompts.

Create a startup form in Microsoft Access 2016/2019, add buttons to open customer, agenda, products, and reports forms, and configure actions including closing the database with macros.

Configure Microsoft Access 2016/2019 to launch with a chosen main form by setting the startup options and selecting the form to display on startup, replacing blank screens.

Learn how to hide database objects from users by disabling the navigation pane in current database options, so users interact with the main form and cannot access reports.

Create a login form in Microsoft Access 2016/2019 using macros, validating username and password with do look up, and open the main form on success.