Database: Demographic Information

Resources: Database Template, Spreadsheet Guide on Excel®, and Lynda.com® Tutorials

Use the raw data in the Database Template to build on this assignment over the next 4 weeks using this single document. The final product will be submitted in Week 5.

Note: The Database Template has two worksheets. Access each using the tabs at the bottom of the template. You will also add new tabs in Weeks 4 & 5. Each week’s tab should be contained in a single worksheet.

Using the Demographic worksheet in the Database Template, do the following:

  • Create an automatic sort by applying a filter to each column so your data can be viewed in different ways.
  • Format the Demographic worksheet so it can be printed in landscape format and on a single page.
  • Create a header in the header field labeled “Database.”
  • Add cell borders around each cell.

Leave a Reply

Your email address will not be published. Required fields are marked *