Preparing the data for use in Access

• Import the file 'Students Last & First Names Combined'
• The last and first names must be separated into thier own fields. Use Excel for this
• Save the new table make sure the FORMAT is 'Unicode Text'
• YOU WILL USE THIS NEW TABLE IN THE NEXT EXERCISE

Creating a query

Open Microsoft Access

• Create a query that finds all of the History majors with a GPA greater than or equl to 3.5. Include in this query the following fields in the given order: last name, first name, major, & GPA
• Create relationships
• Create a report that includes in this order last name, first name, major, GPA

Creating a Custom Report to Turn In

• Create a report on the History query from above
• Make the report look nice by putting the fields closer together so they are easier to read
• At the top of the report in the header create a text box and put "History Majors"
• Make the report look nice and make sure it fits on the portrait page format. You can have multiple pages but do not go off the side of the page
• Title the report "Homework 9 Report"
• Remove the time field in the header
• In the header create a text box with 'History Average GPA ___" calculated from above
• Save the report as "Homework 9"
• Export the report in the 'Word/RTF' format
• The report is what you will turn in.