Add a fourth field to the table with the name ChildPrice and the Currency data type.

Add a fourth field to the table with the name ChildPrice and the Currency data type.

DevelopmentDesignPicturesg11731.png Shelly Cashman Access 2016 | Modules 1–3: SAM Capstone Project 1a

Carpenter Family Camp

CREATING Tables, Queries, forms, and reports in a database

GETTING STARTED
Open the file SC_AC16_CS1-3a_FirstLastName_1.accdb, available for download from the SAM website.

Save the file as SC_AC16_CS1-3a_FirstLastName_2.accdb by changing the “1” to a “2”.

· If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

To complete this Project, you will also need to download and save the following support file from the SAM website:

· Support_SC_AC16_CS1-3a_Activity.xlsx

PROJECT STEPS
Carpenter Family Camp operates summer camps for youth as well as families on a lake in Maine situated near the coast. The camp includes activities for families as well as separate activities for adults and children. Optional adventures to nearby attractions are also available. Create a new table in Datasheet View with the following options:

a. Rename the default primary key ID field to AdventureID, and then change its data type to Short Text. (Hint: The AdventureID field should remain the primary key.)

b. Change the field size of the AdventureID field to 4.

c. Add a new field with the name AdventureName and the Short Text data type.

d. Add another field to the table with the name AdultPrice and the Currency data type.

e. Add a fourth field to the table with the name ChildPrice and the Currency data type.

f. Save the table using Adventure as the name.

With the Adventure table still open in Datasheet View, change the font in the table to Arial Narrow and the font size to 12 pt.

With the Adventure table still open in Datasheet View, add the records shown in Table 1 below. If necessary, resize the AdventureName field so that all field values are completely visible. Save and close the Adventure table.

Table 1: Adventure Table Records
The post Add a fourth field to the table with the name ChildPrice and the Currency data type.

CLICK HERE TO ORDER NOW!!

 

Leave a Reply

Your email address will not be published. Required fields are marked *