Creating Relationships in Access

Please click on the 'Lab Manual' for detailed instructions.


Import these files into a new Access Database:
Students Last & First Names Combined
Major
GPA

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 relationships between all tables on the ID
  • 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 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 label 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 11 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 11"
  • Export the report in the 'Word/RTF' format
  • The report is what you will turn in


Send hw11.rtf as an email attachment to your TA.

In the subject line for your email, include the assignment number, your name and the last 3 digits of your RunnerID in this form:

Homework 11, 123, Samantha Spade

(Replace Samantha Spade with your name and 123 with the last three digits of your student ID). The subject line must be exactly in this format (including capital letters and commas) in order for my grading script to download your assignment correctly, so please follow these instructions carefully.

Errors in your homework grade must be worked out with your TA within one week of grades being posted. You will be asked to show the assignment in the sent email box with the attachment to the TA as proof that you submitted your work on time.

Remove your USB drive and take the drive with you when you leave. This should be the last action when you leave the lab every time. The lab computers are wiped clean every night and all data stored on them is deleted. USB drives left plugged into the computer usually find a new owner.