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.