Question

Create a Table: A. Create a table called Publisher having the following structure: Field Name Data Type PubID Short Text PubName Short Text URL Hyperlink 2 Set the field PubID as the primary key. Set the Field Size field property of the field PubID to 5. Set the Field Size field property of the field PubName to 50. Set the caption property of the PubID field to Publisher ID. Set the caption property of the PubName field to Publisher’s Name.

Answer 1

Answer:

Explanation:

Step 1 Open Microsoft Access

Step 2 click on Blank Desktop Database & Define Database Name and click Create.

Step 3 click on Design View

Step 4 Type Table Name Publisher and click ok

Step 5 Type Field Name PubID and set data type to Short Text

and at the bottom of the microsoft Access Screen you will find Field size 255 is default Field size Erase 255 and type 5 and Type Caption as well Publisher’s Name

Step 6 Use Tab Key for goto Next Cell

Step 7 In Row Two Type PubName and set Data Type to Short Text

Follow step 5 instruction for Field size and Caption

Step 8 In Next Row Type URL and Select Data Type Hyperlink by pressing H on keyboard.

Done.