Download
week 9 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Week 9 PowerPoint Presentation

Week 9

245 Vues Download Presentation
Télécharger la présentation

Week 9

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Week 9 What you need to know:

  2. 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?

  3. 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?

  4. What are commonly used communications devices? • How can a home network be set up? • What are various physical and wireless transmission media?

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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