Microsoft Access 365 Lesson 4 - Restrict cell values (lookup table vs validation)

Channel:
Australia Magic Monk
Subscribers:
65,900
Published on ● Video Link: https://www.youtube.com/watch?v=bSGfmp9CDVY


Duration: 5:29
656 views
13

In this series of videos you will learn how to use the latest version of Microsoft Access as part of the Microsoft Office 365 suite, to create a simple database for a school. You will gain skills that will help you build a database for any small business or organisation.

Last lesson we showed you how to make sure the entered date is correct by using validation rules. This lesson we eliminate the possibility of entering the wrong data using lookup tables.



Other Videos By Magic Monk


2021-02-03Berlin Walking Tour part 5 (2018-12-29)
2021-01-31Berlin Walking Tour part 4 (2018-12-29)
2021-01-28Car won't start? Watch this video before doing anything else!
2021-01-25Microsoft Access 365 Lesson 8 - Calculated Form Control
2021-01-22Microsoft Access 365 Lesson 7 - Rearranging Form Controls
2021-01-19Microsoft Access 365 Lesson 6 - Form Wizard
2021-01-16Kogan Rear View Mirror Dash Cam Part 4 - Sample Footage
2021-01-13Microsoft Access 365 Lesson 5 - Changing Primary Key
2021-01-10Kogan Rear View Mirror Dash Cam Part 3 - Touchscreen sensor broken? Format SD Card
2021-01-08Two Swann Wire-free 1080p Smart Security Cameras for $229 AUD ($178 USD)
2021-01-07Microsoft Access 365 Lesson 4 - Restrict cell values (lookup table vs validation)
2021-01-04Kogan Rear View Mirror Dash Cam Part 2 - Installation, Switching display modes
2021-01-01Microsoft Access 365 Lesson 3 - Date Validation (restrict date range)
2020-12-29Kogan Rear View Mirror Dash Cam Part 1 - Unboxing
2020-12-26Microsoft Access 365 Lesson 2 - Date Input Mask vs Formatting
2020-12-23How to install Garmin 55 Dash Cam on another car
2020-12-20Overhanging Green Boulder @ Brisbane Rock Climbing Gym Urban Climb Newstead
2020-12-17Berlin Walking Tour part 3 (2018-12-29)
2020-12-14Travel around Europe with Xiaomi Redmi 6 and DJI Osmo Mobile 2 - Český Krumlov Episode 16
2020-12-11Microsoft Access 365 Lesson 1 - Create Table
2020-12-08Solving quadratic equations with OneNote - incorrect answer?