Warren Township High School
Business Education Department
 Business Computer Applications II
Access Projects > PIZZA PAYROLL

PIZZA PAYROLL
ASSIGNMENT GRADE
Creating Advanced Queries, Data Access Pages, Switchboards, Macros & Applying Security Features
DIRECTIONS:  We will be using PIZZA PAYROLL Database for this ASSIGNMENT.
  1. Everything on this ASSIGNMENT will be on your test!  Be sure to use help for assistance.
     
  2. DAP:  Create a data access page containing all the fields from the Payroll Table.  Save it in your folder.  Input a record for yourself.  Check the Payroll form for your new record.
     
  3. CALCULATED FIELD:  Create a select query that includes EmployeeID, Date, GrossPay and Taxes.  Create a calculated field that calculates the TaxPercentage (Divide taxes by grosspay).  Save it as Tax Percentage.  Use help!  [See the Net Pay query in your database for an example].
     
  4. Include one message box macro on each of your Access Database forms.  Have it run when the form is opened.
     
  5. Create switchboards for your database:  main, tables, forms, reports DAP's and queries.  All forms, reports, tables, queries and DAP's must be linked. 
     
  6. Include an option on your main switchboard to open tables, forms, reports, DAP's and queries.  
     
  7. Include an option on your main switchboard to edit your switchboard.
     
  8. Include an command button on your main switchboard to close the Pizza Payroll switchboard.
     
  9. Include a command button on the main switchboard that will exit Microsoft Access.
     
  10. Include an option on your tables, forms, reports, DAP's and queries switchboards that returns you to the main switchboard.
     
  11. Open all forms in edit mode.  
     
  12. Customize your switchboard text and background colors.  Customize the font style and size also.  Be consistent.
     
  13. Add an appropriate picture to the Main Switchboard.
     
  14. Set the switchboard to be loaded at start-up.  (Tools,....)
     
  15. Set a password--use stock as your password or I will not be able to grade it! 
     
  16. Export the Tax Percentage Query to Excel and create a 3D-Line Chart representing Employee Id, Date and Gross Pay.  Format it attractively, including:  fonts, titles, legends, etc.  Save the chart as an item in the spreadsheet.  Save the spreadsheet as pizzachart in your Access Unit 3 Folder.