- There is (as always) a list of goals on page 1.
- The introduction on SSA simply introduces the notion of a database (bottom left column second page).
- Read the case perspective and needs analysis (pp. 4-6).
- Start Excel, reset toolbars (as we always do). Page 7 at the top.
- Follow the steps on pp. 7-8 to set up the database.
It's better to work on the desktop and at the end to copy to floppy or to your locker.
- Follow the steps on p. 9 to name the database.
- Follow steps on pp. 9-12 to enter records in database using a form.
- Follow the steps on pp. 13-15 to compute YTD Sales.
- Follow steps on pp. 15-18 to determine letter grades using VLOOKUP.
Use percentages when you enter table 5-3 data.
- Follow the steps on pp. 18-20 to redefine the name Database.
- Read the guidelines to follow when creating a database (p. 21)
- Read how you use a data form to view records and change data (pp. 21-22)
- Read how you can print a database (p. 22). Do not print! Use print preview.
- Follow steps on pp. 22-27 to learn about sorting a database.
- Follow steps on pp. 27-32 to display and explore various subtotals, then remove them.
- Follow steps on pp. 32-35 to find records in the database using a form.
Read about using wildcard characters in comparison criteria on pp. 34-35.
Read about using computed criteria on p. 35.
- Follow the steps on pp. 35-38 to filter the database using AutoFilter.
Follow the steps on pp. 38-40 to enter custom criteria with AutoFilter.
- Read pp. 40-41 on how to achieve the same thing using a criteria range and an advanced filter.
Be careful when you define the range (p. 41 notes).
- Read pp. 43-45 on how to create an extract range and extract records.
Please be very careful when you follow the instructions in the book and don't rush through them!
- Pages 45-46 contain more information on comparison criteria.
- Read pp. 47-49 to practice using database functions such as DAVERAGE and DCOUNT.
