Explain the step by step process you set up to prepare the data from the Excel shipment file to add it to the inventory table in Access
What will be an ideal response?
First, the data in Excel should be examined for accuracy and any blank rows should be deleted. Two columns need to be added in Excel to match the data to the table in Access that it will be added to: a Product field which combines the ProductType field and the ProductDescription field using the CONCATENATE function, and a SalesPrice field, which multiplies the Price field by the markup amount of 6%. Then, because there is only one product field in Access, the ProductType and ProductDescription fields are moved to the right of the SalesPrice field.
When importing the data into Access, a range should be chosen that includes all the Excel fields except the ProductType and ProductDescription. The import steps can be saved so this can be run each time without having to choose the range manually.
You might also like to view...
After applying a slide master use ___________ view to verify that the new font attributes are applied to the text on all of the slides in your presentation.
A. Normal B. Slide Sorter C. Slide Preview D. Slide Show
When you start Outlook, the Calendar view appears.
Answer the following statement true (T) or false (F)
Write a piece of code that creates a “Warning: unresponsive script” error. Then explain in detail what caused the error and how you can fix it.
What will be an ideal response?
A business manager must think like a ________ when designing a database
Fill in the blank(s) with correct word