Lesson 4: More Data, More Tables

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:

Brown Bag Lunch ver4.accdb

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.

 

Test Yourself

1. Which types of files can Access import?

(Give all correct answers.)
A. IBM Mainframe system files
B. QuickBooks financial records
C. Microsoft Excel files
Tip: Beginning Access, page 85

2. Which are options for imported data?

(Give all correct answers.)
A. Import into a new Table
B. Append (add) records to an existing Table
C. Link to an external table
Tip: Beginning Access, page 86

3. Which are options for adding a Primary Key to imported data?

(Give all correct answers.)
A. Choose my own Primary Key
B. Let Access add the Primary Key
C. No Primary Key
Tip: Beginning Access, page 90

4. Access column headings have Filters by default.
A. True
B. False
Tip: Beginning Access, page 95

5. Which functions does an Access Table share with a spreadsheet?

(Give all correct answers.)
A. Find
B. Sort
C. Filter
Tip: Beginning Access, page 94, 95

 

Practice Activities