McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Data Files
Buzz in IT
Updates
Concepts
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center


Office XP Excel 2002
Office XP Excel 2002, 2/e
Timothy O'Leary, Arizona State University
Financial Analysis, Lookup Functions, and Visual Basic for Applications (VBA)

Concepts

After completing this lab, you will know how to:

  1. Define table lookup fields.
  2. Create many-to-many relationships.
  3. Create forms and subforms in Design view.
  4. Add a combo box to a form.
  5. Calculate subtotals in a subform.
  6. Change tab order.
  7. Add and link a subform to a main form.
  8. Create an advanced filter.
  9. Create an update query.
  10. Create a delete query.




McGraw-Hill/Irwin




Copyright2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.