Week 9 What you need to know:
Discovering Computers: Ch 9 Communication and Networks • What components are required for successful communications? • What are the various sending and receiving devices? • How are computer communications used? • What are advantages of using a network?
How are client/server, peer-to-peer, and p2p networks different? • What are various network communication technologies? • What is the purpose of communication software? • What are various types of lines for communication over the telephone network?
What are commonly used communications devices? • How can a home network be set up? • What are various physical and wireless transmission media?
MS Office XP: Tutorial 2: Creating and maintaining a database • Learn the guidelines for designing databases and setting field properties • Create a new database • Define fields and specify a table’s primary key • Add records to a table
Modify the structure of a table • Delete, move, and add fields • Change field properties • Copy records and import tables from another Access database • Delete and change records
MS Office XP: Tutorial 3: Querying a database • Learn how to use the query window in design view • Create, run, and save queries • Update data using a query • Define a relationship between two tables
Sort data in a query • Filter data in a query • Specify an exact match condition in a query • Change a datasheet’s appearance • Use a comparison operator to match a range of values
Use the And and Or logical operators • Use multiple undo and redo • Perform calculations in a query using calculated fields, aggregate functions, and record group calculations