Database in Access - a practical tutorial 2023 скачать в хорошем качестве

Database in Access - a practical tutorial 2023

Take a look at our video, which explains the basics of creating databases in MS Access. This is an important skill that significantly improves office work, and with our course, you can easily master the use of MS Access and databases. The video covers the basics of creating tables, data types, data validity, masks, relationships between tables, joining tables, lookup wizard, validation rules, mandatory fields, list of allowed values in a table, forms, autoexec macros, queries and reports. With this course, participants will gain knowledge of database development and have the tools to use it in their daily office work. What sets our course apart is that the entire course is free, and the knowledge presented in it is worth much more. It makes an excellent recorded resource for students who want to develop their database skills. Don't wait, watch our video now and gain knowledge that will surely come in handy for your work and studies! Link to download the database: https://drive.google.com/file/d/1lnev... Link to voluntary tribute to the development of the channel: https://paypal.me/MatmaNa100 00:50 Basics of creating tables 04:36 Data types 05:00 Table: Design view, data validity, masks 15:15 Relationships between tables, joining tables, lookup wizard 18:00 Validation rules 19:17 Mandatory fields 20:00 List of allowed values in a table 22:00 Forms 26:50 Forms - navigation buttons 29:06 Forms - database menu 33:00 AutoExec macro - autostart when opening a database 34:45 Queries - extracting data from tables 47:30 Reports - the wizard