CS-1011, Spring 2000, Midterm Exam III Study Guide
    1. A query defined in Access can
    2. The results of a query are returned in a
    3. Generalized queries that specify fields and records to be selected are called __________ queries.
    4. To see the results of a query, you must __________ it.
    5. When two tables are related, data can be extracted from both tables using one query even though the tables are
    6. You can use a common field to create relationships between tables by performing a(n)
    7. The __________ table is the "one" table in a one-to-many relationship.
    8. To make a query available to be run anytime you need it, you must
    9. When multiple sort keys are selected, the first field selected is the primary sort key and the others are called __________ sort keys.
    10. When you save a query with sort keys defined in it, the sort keys
    11. You can tell Access which records are to be selected by specifying a(n)
    12. The __________ operator will cause a record to be selected only if two or more conditions are satisfied.
    13. When you define a query that performs a calculation, you must add a __________ field.
    14. The Max function determines
    15. Statistical information, such as totals and averages, can be calculated in a query by using a(n)
    16. Forms can contain data from more than one table if the tables are
    17. A form that shows only one record at a time is a __________ layout.
    18. If you want to use a form on a frequent basis, you must
    19. You can move from field to field within a form by using the
    20. Bob needs to locate a particular customer record and view it in a form. What command would he use to locate the record?
    21. A search value can be an exact value or it can contain a
    22. A form that accesses data from two tables has a main form and a(n)
    23. A report is a means of providing a __________ printout of the data in one or more tables.
    24. It is a good idea to __________ a database before it is compacted.
    25. Deleting a record from a table removes it from the display
    26. You can rearrange the data and objects in a database and make it smaller as well by __________ it.
    27. If you want a logo to appear on every slide in a presentation, you should include it on the:
    28. PowerPoint is a powerful presentation __________ program.
    29. Which of the following is an element of a presentation that should be planned?
    30. Which of the following can you NOT create with PowerPoint?
    31. In which view can you set special features for your slide show?
    32. In which view do you present your slide show?
    33. In which view can you see and edit text and graphics on an individual slide?
    34. What should you always do before you exit PowerPoint?
    35. In a slide presentation, it's easier for audiences to read _________ phrases.
    36. You can delete slides in any view EXCEPT:
    37. What is the term that means to transfer a copy of an item from the Clipboard to a document?
    38. _________ slides are preformatted slides with placeholders already in them.
    39. PowerPoint provides design _________, which are predetermined colors and formats of the background and type style of titles, accents, and other text.
    40. What are audience handouts?
    41. What should you do to all the slides and speaker notes before printing or presenting a slide show?
    42. To remove the background graphics from all the slides in a presentation, what button do you click in the Background dialog box?
    43. Which of the following is NOT a principle for using graphics effectively?
    44. A(n) ________ is any item on a slide that you can move, resize, rotate, or otherwise manipulate.
    45. After you insert a picture into a slide, the picture remains:
    46. Which view must you be in to insert a picture into a slide?
    47. A ________ is an image from a source other than that provided by Microsoft.
    48. You should consider file ________ when saving files with graphics on a floppy disk.
    49. Fiber-optic cable has all of the following advantages over cables that use wire except __________.

    50. Microwaves are __________.
    51. A communications satellite is a __________.
    52. Infrared (IR) is a __________.
    53. Transfer rate usually is expressed as __________.
    54. Integrated Services Digital Network (ISDN), a popular type of digital leased lines, __________.
    55. A digital subscriber line (DSL), a popular type of digital leased lines, __________.
    56. T-carrier lines, a popular type of digital leased lines, __________.
    57. The terminal emulation feature of communications software allows __________.
    58. A __________ is a network that connects computers in a limited geographical area, such as a school computer laboratory, office, or group of buildings.
    59. A __________ is a network that covers a large geographical area using a communications channel that combines telephone lines, microwaves, satellites, or other transmission media.
    60. A __________ network is a network topology that consists of a single central cable, to which all computers and other devices connect.
    61. A __________ is a network topology designed so a cable forms a loop, with all computers and devices arranged along the loop.

    62. A __________ is a network topology in which all of the devices connect to a central computer.
    63. A __________ protocol controls access to the network by requiring that a special signal is shared or passed among network devices.
    64. __________, widely used on the Internet, is a set of protocols used to manage the transmission of data by breaking it up into packets.
    65. Organizations use __________ to deny network access to outsiders and to restrict employees' access to sensitive data such as payroll or personnel records.

    66. A student record would use __________ as a key field because it uniquely identifies each student.
    67. Two disadvantages of a file processing system are __________.
    68. The database approach has all of the following advantages except __________.
    69. A __________ would help provide the information a sales manager needs to determine how high to set yearly sales quotas based on increased sales and lowered production costs.
    70. Expert systems are one part of an exciting branch of computer science called __________.
    71. __________ are the liaison between the users and the programmers; that is, they convert user requests into technical specifications.
    72. __________ uses tools such as entity-relationship diagrams, data flow diagrams, and the project dictionary to document specifications of an information system in the project notebook.
    73. The project __________ helps those involved keep track of the huge amount of details in every system.
    74. The advantage of a prototype is that __________.
    75. A(n) __________ test verifies that all programs in an application work together properly.
    76. A(n) __________ test, performed by end-users, checks that the new system works with actual data.
    77. With __________ conversion, the user stops using the old system and begins using the new system on a certain date.
    78. __________ conversion consists of running the old system alongside the new system for a specified period of time.
    79. __________ conversion is used with larger systems that are split into individual sites.
    80. With a __________ conversion, only one location in the organization uses the new system - so it can be tested.