Mary Chimney

Computer Literacy

Lab 5 Report

            I started by going to Microsoft Access and creating a new database.  After that I created three different tables.  The tables were: “customers,” “order_status,” and “orders.”    In the customers table I included John, Jenny, and Jason as my customers and included their customer ID number and their address and phone number.  In the second table I included three different order numbers and put yes or no on their statuses.  And then on the last table I put customer ID numbers, order numbers, prices, and the order dates.  After I finished with all of that and saved it all, I then went to “Queries” and clicked on “Create query in Design view.”  I then selected the customer ID number, name, order number, price, order date, and the status.  Then I went to “Query” and pressed “Run” and then I saved my query as “Query1.”  I then went to SFTP and logged on, and since I had saved my database in “Temp” I was able to upload it onto my website and I created the hyperlink “Lab 5” through Microsoft FrontPage.  After I had finished all that, my tables and query were accessible through my personal website.