Introduction to Access

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

Open Microsoft Access.

Files to import:

  • Create a new database in Access
  • Import the four files located above
  • Create 'Relationships with all four tables by their similar fields. See the image below for the correct relationships

  • Create a query that selects for the files that have 'Never' been accessed and that are in the 'Spanish' language. The table should contain the following fields: last, first, the file name, language, and usage.
  • Sort the query by last name ascending
  • Export the results to a HTML file named hw10.html
  • Open a PowerPoint presentation name it 'Homework 10'
  • On slide one make it a title only slide & paste the report on slide one
  • Title the slide as "Homework 10 Report 1"

Switching programs for ease of operation

  • Create a query with the 'Last', 'First', 'Sales', 'Countries' in that order
  • Take this query and export it to Excel. Go to the data tab and in export click the export to Excel option.
  • Find the subtotals based on 'Countries' (See Week 11 Lab Manual)
  • Import the data back into Access
  • Create a report & make it look nice and fit on one page.
  • Remove the 'Average' after each country name as part of making the report look nice (see Lab Manual on how to do this)
  • Export the report in the 'Word/RTF' format
  • Add the report to the PowerPoint presentation on slide 2

Adding data to tables using forms

  • Create a query named 'Sales Query' with the following fields: from the 'Employee' table get the 'ID', 'Last', 'First', 'State'. From the 'Sales' table get 'Sales'
  • Go to the end of the form. Leave the first field alone. The '(New)' in the 'ID' box will automatically fill in the correct value when you start to enter data into the next field
  • Enter 8 records where the state is 'AZ'. Make up the names and sales figures. Sales must be a value
  • Create a report where 'Sales Query' is filtered for only AZ
  • Make the report look nice
  • Save the report as a HTML file
  • Add the report to the PowerPoint presentation on slide 3

Save the PowerPoint presentation as 'hw10.pptx' in the 'PowerPoint Presentation' format (it should be default). Send hw10.pptx 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 10, 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.