Answered step by step
Verified Expert Solution
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 and enter sale details in the subform as follows: Item: Original BlendQuantity Item: Old Bay, Quantity Close the form Open the Items table and modify the table fields as follows: Set the Default Value property for the Price field to Change the data type for the Price field to: Currency Autofit the width of the ItemName field. Save the changes and the Items table. Create a Single Record form using the Items table as the record source. Save the form with the name: SingleItemFrm 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 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 Close the forms Import the StoreSales table from the SalesArchive Access database downloaded from the Resources link Do not open the SalesArchive database 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started