Uncategorized

Open .mdb. 1) For the table Classes, set a validation rule for the ClassTime field such that the Class start should be between 9 am and 7 pm inclusively. (The expression for time is like #9 AM#.) Provide appropriate Validation Text to the ClassTime field such as “Please enter between 9 AM and 7 PM.” 2) For the table Classes, set a validation rule that the StartingDate should come berfore the EndingDate. Provide an appropriate Validation Text for this validation rule such as “Starting Date should be earlier than Ending Date.” (3 points)

Direction: Work on the questions below and save your work progresses from time to time by clicking Ctrl-S. Using.mdb file Open .m...

Continue reading