Answered: 9. Open the Items table and modify the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Transcribed Image Text:a. 9. Open the Items table and modify the table fields as follows: Set the Default Value property for the Price field to: 9 Change the data type for the Price field to: Currency c. Autofit the width of the ItemName field. b. d. Save the changes and close the Items table. 10. Create a Single Record form using the Items table as the record source. Save the form with the name: SingleRecordForm 11. Begin a new blank form in Layout view. a. From the Locations table, add the LocationID, Location Description, and Comments fields in that order, at the left side of the form. b.widen the labels so that they are just wide enough for Location Description to be completely visible. c. From the Locations table, add the OpenTime field to the right of the LocationID controls. d. Reduce the width of the OpenTime bound control so that the control is just wide enough to display the time data. e. From the Locations table, add the Close Time field to the right of the OpenTime controls. f. Reduce the width of the CloseTime bound control so the control is just wide enough to display the time data. g. Move the OpenTime and Close Time controls so they are next to the Location Description controls instead. h. From the Locations table, add the Days field to the form layout in the empty space to the right of the LocationID controls, above the OpenTime controls. i. Add a logo to the form header. Use this file, located with the resources for this project: toptCornLogo-small.png j. Save the form with the name: LocationsDetails Form 12. Close the forms.

8. Use the Form Wizard to create a new form for inputting sales data.
Include all the fields from the PopcornSales table.
a.
b.
Include the Item and Quantity fields from the SaleDetails table.
c. View the form data by records in the PopcornSales table with related records
in the SaleDetails table displayed in a subform.
d. The subform should be displayed as a Datasheet.
e.
Name the main form: PopcornSales Form and name the subform:
SaleDetailsSubform (Hint: Be sure to remove the space between
ure.com/courses/79665/assignments/1378308?module_item_id=3226669
f.
g.
Access 365/2021 Capstone - SIMnet
SaleDetails and Subform in the subform name suggested by Access.)
Open the form in Form view to review your work.
Navigate to the record in the main form for SaleID 3 and enter sale details in
the subform as follows:
Item: Truffle, Quantity: 3
Item: Old Bay, Quantity: 2
h. Close the form.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions