Create a Custom SwitchBoard / Navigation Form in MS Access | The Introduction to MS Access Course
https://www.udemy.com/course/microsoft-access-for-beginners/?referralCode=B3AA9B5B16B34FFF9C33
This video is part of my Introduction to Access course, which you can enrol on by following the link above. It 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.
Видео Create a Custom SwitchBoard / Navigation Form in MS Access | The Introduction to MS Access Course канала Chester Tugwell
This video is part of my Introduction to Access course, which you can enrol on by following the link above. It 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.
Видео Create a Custom SwitchBoard / Navigation Form in MS Access | The Introduction to MS Access Course канала Chester Tugwell
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Microsoft Access 2016 Forms: SwitchboardMicrosoft Access Switchboards and Navigation Forms. Why NOT To Use Them! Create Your Own Menu FormsHow To Create An Excel Data Entry Form WITHOUT A UserFormExcel vs Access | Pros and Cons | The Introduction to MS Access CourseMs Access Dynamic MenuMicrosoft Access Forms Tutorial: MS Access 2019Using Multiple World Currency Symbols in Microsoft Access: $ € ¥ £ ¢ ﷼ ₽ and more...How to Create a Form with a Subform to Show Related Records in Microsoft AccessHow To Create a Microsoft Access Switchboard Using the Switchboard ManagerAccess Form With a Subform and Calculated FieldsRemove Unwanted Spaces from Cells in a Microsoft Word Table - 5 Methods.How to create MULTI-FIELD SEARCH FORM in MS AccessImport New and Changed Records in Microsoft Access. Update Pricing from Vendor Excel SpreadsheetExcel VBA - Attach (Invoice) PDF to Email and Send to Email Address (Based on Cell Value)Microsoft Access 2016 Forms: Navigation FormsHow to Open Excel from Access Using VBAAccess 2019 Full Tutorial: Microsoft Access Made EasyHow to Use a Tab Control in Microsoft Access to Group Other Controls Together (Tab Pages)Access 2019 - Navigation Form and Branding