Скачать с ютуб How to Create a FORM WITH SUBFORM in MS Access | The Introduction to MS Access Course в хорошем качестве

How to Create a FORM WITH SUBFORM in MS Access | The Introduction to MS Access Course

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted... Thank you! 👍👍 These videos are part of my Introduction to Microsoft Access course. To complete the course please enrol here https://courses.bluepecantraining.com... This video will demonstrate how to create a form that contains a subform displaying data from a different yet related table. 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. ------------------------