VISUAL BASIC FOR ACCESS

Access.<br><br> It is also an excellent reference resource for more complicated questions students may have. Chapter Check-Off List Students should record when they have completed the work associated with each chapter in the book Microsoft Access 2002 Visual Basic: For Applications Step by Step. The book comes with a CD to be used on exercises.<br><br> Students should read through each chapter, performing the exercise steps as they read. Course Project Students should do the course project, using the information they have learned about Access and Visual Basic from this course and previous courses. Grading Students 9 grades should be based upon completing the Chapter Check-Off List in a timely manner, and upon the quality of the project completed.<br><br> 6 SECTION TWO: CHAPTER CHECK-OFF LIST 7 TEACHER 9S MANUAL FOR VISUAL BASIC FOR ACCESS Student Name: ___________________________________________________________ Teacher Name: ___________________________________________________________ Chapter Check-Off List Chapter # TOPIC CHAPTER EXERCISES COMPLETED? (X) 1 Get Started Quickly with Wizards 2 Customize an Application with Visual Basic 3 Find and Filter Records in a Form 4 Respond to Data Entry Events 5 Write Your Own Functions 6 Monitor and Debug your Code 7 Respond to Errors and Unexpected Conditions 8 Gather Information in a Dialog Box 9 Navigate through your Application 10 Display Custom Menus and Toolbars 11 Put Final Touches on an Application 12 Explore Objects and Collections 13 Customize Reports with Visual Basic 14 Share Data with Other Applications 15 Connect to the Web Grade Received in the Course for the Chapters Completed and the Course Project: __________ 8 SECTION THREE: COURSE PROJECT 9 Students should be assigned or choose from among the following course project options. The grade given by the teacher to the student for the course will largely be based upon the quality of the completed project.<br><br> It should incorporate as many features as possible from what was learned in the textbook. Project #1: A Family Address Book An address book in Access can serve many functions. It can help keep track of friends 9 addresses and telephone numbers.<br><br> It can be used to automate printing of annual newsletters to relatives and friends. It can be used to print address labels. It can be used as an invitation list.<br><br> Make an address book that can serve many of these useful functions and more. As part of performing this project, ask family members what features they would like in it. Allow individual family members to have their own address book of friends and family members, without having to add a whole new record if other family members some common entries.<br><br> Project #2: A Home School Family Organizer for The Puritans 9 Home School Curriculum Home school families need to track the courses their children have completed and their grades in those courses. They need to make sure their children have completed all of the necessary tests and subjects. It is wise too to keep a record of extracurricular activities that children have participated in.<br><br> It would be nice to print out the Grade Point Average (GPA) in each level of education (primary, middle, and high school levels). It is nice to be able readily to print out all of this information should state authorities or colleges request it. The Teacher 9s Manual for Implementing the Puritans 9 Home School Curriculum contains information on what needs to be completed.<br><br> But parents will often want to tailor the curriculum to their own needs. This project should allow parents to customize courses, etc. As part of performing this project, ask family members what features they would like in it.<br><br> Project #3: A Family Meal Planner and Recipe Book Each dish can consist of various ingredients, and each meal consists of various dishes. Prepare a program that allows someone to prepare a schedule of upcoming meals for the coming period of time (one month?, two months?, etc.) and what ingredients will be necessary for those meals. Have it print out a list of what needs to be obtained given the coming schedule of meals.<br><br> As part of performing this project, ask those who will be cooking and shopping what features they would like in it. Make sure it is as user friendly as possible. <br><br>

less