Question: 6. Create a table in Design View as follows to store data about program types: a. Add a new field named ProgTypeID with the Short

6. Create a table in Design View as follows to store data about program types: a. Add a new field named ProgTypeID with the Short Text data type. b. Set ProgTypeID as the primary key field. c. Add another new field named ProgDescription and assign it the Short Text data type. d. Set the Field Size property to 25 for the ProgDescription field. e. Save the table using ProgramTypes as the name, open it in Datasheet View to confirm it contains no data, and then close the ProgramTypes table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please explain and show me how to do this on Access. Thank you! I posted this question before, and the person who answered did not answer the full question and did not answer it correctly, I have...

This question is based on Microsoft Access course. Use the following information and create a Student List database file. 1) Create a new blank database file and name it as a StudentList and save on...

Use the following information and create a Student List database file. Create a new blank database file and name it as a StudentList and save on the Desktop. Create a table using design view: a )...

Create a new table in Design view. This table will store the room types. Add the following fields (in this order): RoomType, and then RoomAmenities. Set the data type for the RoomAmenities field to...

home / study / business / accounting / accounting questions and answers / ex16_ac_ch02_grader_ml1_hw - my game collection project description: you have cataloged your ... Question:...

SEND PICTURE OF ACCESS FILE Blue Lake Sports is a nationally recognized sporting goods company. It has a growing internship program at its corporate office to offer experience to college students....

EX16_AC_CH02_GRADER_ML1_HW - My Game Collection Project Description: You have cataloged your video games in an Access database. In this project, you add two tables to a database you have startedone...

1 Start Access. Open the downloaded Access file named exploring_a02_grader_h2 . 2 Create a new table in Design view. Add the field name SystemID and select AutoNumber as the Data Type. Add the...

Database Management 1.Open Access and create a database called, "Movie Favorites." Create the Film Favorites table in Design view using the structure shown below: Structure of Film Favorites table...

1. Import a table from the downloaded Access database a01_grader_a1_Guest.accdb selecting the tblGuests table. Do not save the import steps. 2. Create a new table in Design view. This table will...

Chapter 2 explains the difference between positive analysis and normative analysis. In the debate about whether the central bank should aim for zero inflation, which areas of disagreement involve...

Hal is having difficulty choosing between two tennis rackets, A and B. B has substantially more power than A, but substantially less control. According to the rational choice model, how will the...

which of the following statements is false? A . the reduction in the WACC increases with the amount of debt financing B . because the firm's free cash flow is computed without considering the firm's...

Discuss qualitative research designs in detail?