Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10. [10] In the tblReservation table, change the PropertylD field data type to Lookup Wizard. Select the PropertylD, PropertyName, and Location ficlds from the tblProperty

image text in transcribed
10. [10] In the tblReservation table, change the PropertylD field data type to Lookup Wizard. Select the PropertylD, PropertyName, and Location ficlds from the tblProperty table, sort in ascending order by Property Name, do not hide the key column, resize the lookup columns to their best fit, and select PropertylD as the field to store in the table. View the tblReservation datasheet, resize the PropertylD column to its best fit, test the lookup field without changing a field value permanently, and then close the table. 11. [10] Define a field validation rule for the Bedrooms field in the tblProperty table. Acceptable field values for the Bedrooms field are values between 3 and 25, including those two values. Display the message Value must be between 3 and 25 when a user enters an invalid Bedrooms field value. Save your table changes and then test the field validation rule for the Bedrooms field; be certain the field values are the same as they were before your testing 10. [10] In the tblReservation table, change the PropertylD field data type to Lookup Wizard. Select the PropertylD, PropertyName, and Location ficlds from the tblProperty table, sort in ascending order by Property Name, do not hide the key column, resize the lookup columns to their best fit, and select PropertylD as the field to store in the table. View the tblReservation datasheet, resize the PropertylD column to its best fit, test the lookup field without changing a field value permanently, and then close the table. 11. [10] Define a field validation rule for the Bedrooms field in the tblProperty table. Acceptable field values for the Bedrooms field are values between 3 and 25, including those two values. Display the message Value must be between 3 and 25 when a user enters an invalid Bedrooms field value. Save your table changes and then test the field validation rule for the Bedrooms field; be certain the field values are the same as they were before your testing

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

13th Edition Global Edition

1292263350, 978-1292263359

More Books

Students also viewed these Databases questions