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...
In SharePoint, a discussion board provides a threaded message board to all members of a team
Indicate whether the statement is true or false
A(n) ________ provides a visual cue about the value of a cell as compared to other cells in a range
Fill in the blank(s) with the appropriate word(s).