1 / 9

Week 9

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

Gideon
Download Presentation

Week 9

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related