If you have not done so already, use the Customers table in the BSN database that accompanies this book and the directions in this chapter to create Make sure that you reformat the default positions of the various textboxes as shown in the. Now add a subform of customer invoices to your form so that it. To do this, open your initial form in design view, select the subform tool from the Toolbox Controls, and add a subform. Answer the questions for the Subform Wizard to select the Invoices table. When you have completed these tasks, also do the following:
a. Use the navigation bar of the main form to go to the last record in the Customers table. Print the form for this record.
b. Use the navigation bar of the main form to find a record with invoices. Then use the navigation bar of the subform to select a particular invoice. Which one did you select? Print this form.
a. Add a label in the heading portion of your form that contains the term ‘‘Prepared by:’’ and add your name. Print a single copy of your completed form.
b. Use the navigation bar at the bottom of your form. What is the first record? What is the last record?
c. Add a new record to this form with your name as the customer. Print a copy of this form.
d. Close your form, go to the Tables portion of the database, and open the Customers table in datasheet view (see Figure 6 2). Verify that your new record is there. Now, add a second record with your name again. Are you surprised that you can do this?