Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Navigate to the record in the main form for SalelD 3 and enter sale details in the subform as follows: Item: Original BlendQuantity Item: Old

Navigate to the record in the main form for SalelD 3 and enter sale details in the subform as follows: Item: Original BlendQuantity Item: Old Bay, Quantity 8 Close the form 9. Open the Items table and modify the table fields as follows: Set the Default Value property for the Price field to8 Change the data type for the Price field to: Currency Autofit the width of the ItemName field. Save the changes and the Items table. 10. Create a Single Record form using the Items table as the record source. Save the form with the name: SingleItemFrm 11. Create a form to display records from the Items table in two formats with the Single Record form at the top and a Datasheet form at the bottom Create a Split Form based on the Items table. Name the form: SplitItemFrm 12. Begin a new blank form in Layout view. From the Locations table, add the LocationID , LocationDescription , and Comments fields in that order , at the left side of the form Widen the labels so that they are just wide enough for LocationDescription to be completely visible. From the Locations table , add the OpenTime field to the right of the LocationID controls Reduce the width of the OpenTime bound control so that the control is just wide enough to display the time data. From the Locations table, add the Close Time field to the right of the LocationDescription controls Reduce the width of the CloseTime bound control so the control is just wide enough to display the time data. From the Locations table, add the Days field to the form layout in the empty space to the right of the to right of the OpenTime controls h Add a logo to the form header. Use this file, located with the resources for this project toptCornLogo- small.png Save the form with the name: LocationsFrm 13. Close the forms 14. Import the StoreSales table from the SalesArchive Access database (downloaded from the Resources link). Do not open the SalesArchive database .15. Verify that you are working in the database you downloaded from Access , not the SalesArchive database . Rename the StoreSafes table SalesArchive Open the SalesArchive table and delete the Total field .

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Performance Indexing In SQL Server

Authors: Jason Strate, Grant Fritchey

2nd Edition

1484211189, 9781484211182

More Books

Students also viewed these Databases questions

Question

Find dy/dx if x = te, y = 2t2 +1

Answered: 1 week ago

Question

What is DDL?

Answered: 1 week ago