Chapter 9 & 10 - Lecture notes 9-10 PDF

Preview

Summary

Professors were Dr. McCarthy and Dr. Wood...

Description

Chapter 9 & 10 









Internet history o In the 1960s, scientists working for the United States Air Force researched ways to make a highly robust network that would continue to work even if part of the network was damaged o Tucson was the biggest target for nuclear war  Had the most nuclear weapons o In 1969, the Advanced Research Project Agency Network made similar networks at UCLA that connected them and would eventually would become to be known as the internet o Until about 1990, there was no common “language” of the internet and it remained the domain of scientists and academicians o Around 1990, Tim Bernrers-Lee invented a standard language of the internet call Hypertext Markup Language (HTML)  Its a weak language o HTML is a platform neutral language which means it will work on all operating systems like Windows, Mac OS, Linux, and UNIX o Hypertext Transfer Protocol (HTTP) was developed as a means to transfer information in a standard fashion so all computers on the internet could receive data Internet and World Wide Web Structure o The internet is a “client / server” model o Reduce the internet to 11 computers, 10 clients connected to 1 server. Each of the 10 clients is named 1 through 10, giving it an internet protocol address Internet protocol address o IP addresses are actually a 32 bit number like 129.219.10.58  Protocol “http://” + “129.219.10.58” = “http:// 129.219.10.58” o Websites have addresses called Uniform Resource Locators (URLs) like “http://www.yahoo.com” that mask the IP address o “Http” is a hypertext transfer protocol, “www” is world wide web, “yahoo” is the domain name”, and “.com” is the domain code Common domain codes o .com commercial o .edu educational o .mil military o .gov governmental o .org organization o .net network Websites o Important aspects of websites are  Content (most important)  Interactivity  Design











o Browser application software provides a GUI interface Browser features o Bookmarks o Caching o Cookies  What remembers my personal information o Graphic files o JavaScript o Security o Pop up blockers o Usability Internet service providers (ISP) o Business that provides a way to access the internet. Broadband internet access is a high-transmission rate internet connection. Internet host services hold content on the world wide web Search engines o Top search engines  Google  Bing  Yahoo  Ask  Aol Business website alternatives o Blogs were originally called “web logs” maintained by an individual. In business, blogs can serve to bolster a business’ interests and create more visits to its website Hypertext markup language (HTML) elements o Hypertext is the text on a computer that leads a user to related information while markup language refers to the computer programming. HTML is represented by elements enclosed by (brackets) o Example: Yahoo!  Head elements define the documents’ style like: 

Wood - Wednesday  BETWEEN - includes bounds  Syntax in access is like English and not like Excel  AND - across  OR - down  Process for records must meet all criteria in the first row  Everything in Access is called an “object” o Every “object” has “properties” that describe something about the object

1. Click on create 1. Quarry design 2. Click on shipment 3. Add 4. Close 5. Double click on orderid 6. Double click on shipdate 7. Under order id 1. Criteria is 3020 ii. Copy “order 3010 shipped” and save it as the quarry name iii. Close b. Click on create i. Quarry design ii. Click on customer iii. Double click on lastname, firstname, email, city, province iv. In province 1. Under criteria put AZ ii. In lastname 1. Under sort put ascending ii. In firstname 1. Under sort put ascending ii. Unclick show row in province iii. Save quarry as “arizona customers” iv. Close b. Click on create i. Quarry design ii. Click on school iii. Double click on schoolname, phone, city, GSHI iv. Under city 1. Criteria row put in Denver ii. Under GSHI 1. Criteria row put in 12 ii. Save quarry as “denver high school” iii. Close b. Click on create i. Quarry design ii. Click on product iii. Double click on productid, productname, currentprice iv. Under currentprice 1. Criteria row put >100 2. Sort as descending ii. Save quarry as “pricey products” iii. Close b. Click on create i. Quarry design ii. Click on saleorder

iii. iv.

b.

b.

b.

b.

Double click on atrix in the top of the chart Double click on shiptoprovince 1. In criteria type AZ, TX, NM, OK going down 2. Unclick show button on all except the first column 3. Sort as ascending ii. Save quarry as “southwest orders” iii. Close Click on create i. Quarry design ii. Click on customer iii. Double click on customerid, firstname, lastname, province, country iv. In country 1. Sort as descending 2. Criteria is Not(“United States”) ii. Save quarry as “foreign customers” iii. Close Click on create i. Quarry design ii. Click on school iii. Double click on schoolname, phone, city, ULOCAL, CHATR iv. Under city 1. Sorts as ascending ii. Under ULOCAL 1. Criteria is 11 ii. Under CHATR 1. Criteria is or 1 (second row of criteria) ii. Save quarry as “large or charter” iii. Close Click on create i. Quarry design ii. Click on school iii. Double click on schoolname, phone, city, state iv. Under schoolname 1. In criteria type -> LIKE “*Elementary*” ii. Save quarry as “elementary schools” iii. close Click on create i. Quarry design ii. Click on school iii. Double click on schoolname, phone, city, state, CHARTR iv. Under schoolname 1. Sort ascending 2. Criteria is -> LIKE “*Elementary*” and on the next line -> LIKE “*Elementary*” ii. Under city 1. Criteria is Denver

ii.

Under CHARTR 1. Criteria is or 1 ii. Save quarry under designated name iii. Close b. Click on create i. Quarry design ii. Click on customer iii. Double click on city, province iv. Under province 1. Unclick show 2. Criteria is AZ ii. Right click on top half and click on properties iii. Change unique values to yes on property sheet iv. Save as designated name v. Close b. Submit :) good luck future Julia!...