These videos are part of my Introduction to Microsoft Access course. To complete the course please enrol here [ Ссылка ]

This video will demonstrate how to create a custom switchboard or navigation form that will allow the database users to easily navigate between important forms and reports.

THE COURSE
This introduction to Microsoft Access course provides the perfect foundation for developing expertise. Even though it is a beginner’s course, delegates will build two fully functioning relational databases. I started my Microsoft Access training career back in the late 1990s and over the years have fine-tuned his content and delivery to culminate in this course.

The course has been designed to be as hands-on as possible. It is project-based and takes you through the steps involved in building an Access relational database from the ground up.

Topics Covered in the Course
Relational Database Theory – what is a relational database and how does it compare to the way data is stored in Excel, for example?

Tables – designing tables to store data. Setting data types and field properties.

Importing Data – importing data into your Access database stored in Excel or as text files.

Creating Relationships Between Tables – understanding primary and foreign keys and creating relationships between tables.

Design Forms – that look great and function well.

Select Queries – understand how to set AND/OR criteria, use comparison operators and wildcards.

Design Reports – that look professional.

Create a Front-End for your Database – create a navigation form with command buttons that open your forms and reports. Set database options that control what appears/doesn’t appear to your users when they open the database.

The course was created using Access 365 (2019) but will work for earlier versions.
------------------------

свернуть