These videos are part of my Introduction to Microsoft Access course. To complete the course please enrol here courses.bluepecantraining.com...
This video demonstrates how to establish a relationship between two tables in a Microsoft Access database using the Lookup Wizard. The lookup wizard creates a drop-down list in one table that includes values from a field in another 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.
------------------------
Негізгі бет Тәжірибелік нұсқаулар және стиль Create a DROP-DOWN LIST with Values From ANOTHER TABLE | The Introduction to MS Access Course
Пікірлер: 24