Microsoft Access 2010 Chapter 5 Apply Your Knowledge

Microsoft Access 2010 Chapter 5 Apply Your Knowledge
Reinforce the skills and apply the concepts you learned in this chapter.

Adding Date/Time and OLE Fields, Using an Input Mask Wizard, and Querying Date/Time Fields

Instructions: Start Access. If you are using the Microsoft Access 2010 Complete or the Microsoft Access 2010 Comprehensive text, open the Babbage CPA Firm database that you used in Chapter 4. Otherwise, see your instructor for information on accessing the files required in this book.

Perform the following tasks:
1. Add the Start Date and Picture fields to the Bookkeeper table structure, as shown in Figure 5 – 84. Create an input mask for the Start Date field. Use the Short Date input mask type.
2. Add the data shown in Table 5–1 to the Bookkeeper table.
3. Query the Bookkeeper table to find all bookkeepers who started after January 1, 2012. Include the Bookkeeper Number, First Name, Last Name, Hourly Rate, and Earnings YTD in the query results. Save the query as Start Date Query.
4. Submit the revised database in the format specified by your instructor.