From the course: Access 2016 Essential Training

Unlock the full course today

Join today to access over 24,000 courses taught by industry experts.

Challenge: Creating tables

Challenge: Creating tables

From the course: Access 2016 Essential Training

Start my 1-month free trial Buy for my team

Challenge: Creating tables

“

- We've covered a lot of ground so far so I think we're ready for our first challenge. In the LandonHotel-ChallengeStart database go ahead and try creating a new data table to store a RoomServicesMenu for the Landon Hotel. Think about some of the information that would need to be available to the hotel staff and create the necessary fields and data types to store the data. Remember that you're not creating the actual menu, just the structure of the table that will support the individual menu items. If you want to take this challenge a step further see if you can create another table that will store orders and establish the relationships between the guests to the menu items that they may have ordered. I estimate that this challenge will take less than 10 minutes. Have fun.

Contents