Try This: Do the following steps
1. Open the Excel Spreadsheet:
Brown Bag
Products.xlsx
2. Use the Filter function to show only the records with
the Specialty Gluten Free. How many Records do you see? Remove the
Filter and close Excel.
3. Open the Brown Bag Lunch database you have been
programming. Or you may download the sample database
online:
4. Import External Data from Excel. Select the
spreadsheet Brown Bag Lunch Products.xlsx.
5. Import the data into a new Table in the Current
Database.
6. Select the Worksheet named Products.
7. Select that the first Row contains Column Headings.
8. Accept default settings for Field Options.
9. Name the table tblProducts. Finish the Wizard.
10. Use the Find command to find the Records with Ham.
11. Use the Filter to show only the items with the
Specialty Gluten Free. How many Records do you see?
12. Remove the Filter.
13. Rename the ID field to. ProductID
14. Save the changes to tblProducts.
1. Which
types of files can Access import?
(Give all
correct answers.)
(Give all
correct answers.)
(Give all
correct answers.)
4. Access
column headings have Filters by default.
(Give all
correct answers.) |
|
| |