Create a new table in design view

Assignment Help Computer Engineering

Reference no: EM133912226

Problem

Create a new table in Design view. This table will serve as the junction table between tblRoom and tblItem. As the first field, add RoomItemID with a data type of AutoNumber and a description of A unique identifier for the room item (primary key) (no period). As the second field, add RoomNumber, with a data type of Short Text, a description of The room number from tblRoom (foreign key), and a field size of 30. Get the instant assignment help. As the third field, add ItemID, with a data type of Number, a description of The item ID from tblItem (foreign key), and a field size of Long Integer. As the fourth field, add InventoryCount, with a data type of Number, a description of Number of items of this type in this room, and a field size of Long Integer. Assign the appropriate field to be primary key. Save the new table as tblRoomItem. Close the table.

Reference no: EM133912226

Questions Cloud

How you configure network to provide reliable connectivity : How would you configure the network to provide reliable connectivity for all devices, including considerations for bandwidth management and parental controls?

Write the necessary sql commands to capture this information : Where you think student and tutor information such as name, address, phone and e-mail should be kept? Write necessary SQL commands to capture this information.

Concept of the traditional political science agenda : Discussion concerning the modern state, security stands as a central concept of the traditional political science agenda in discussion international relations.

Newborn is out of the room for hearing screening : 17-year-old Deborah Nelson is sitting in her bed. Her (2 day) newborn is out of the room for a hearing screening.

Create a new table in design view : Create a new table in Design view. This table will serve as the junction table between tblRoom and tblItem.

Describe ethical dilemma in nursing : Describe an ethical dilemma in nursing. You may choose any ethical dilemma that you have knowledge or experience with.

Describe all steps involved in assessment and rating process : Describe all the steps involved in the assessment and rating process. (250 word limit)

Which term describes a type of penetration testing : Which term describes a type of penetration testing in which the tester is provided only a very limited amount of information about the system to be tested?

Commonly prescribed medications : I am one of the most commonly prescribed classification of medications in the US (two of my medications are in the top 5 most commonly prescribed medications)

User Account

All Pages