CS-1011, Spring 2000, Midterm Exam III NAME_________________________ SECTION______

    1. A query defined in Access can
      1. display selected fields and records from one or more tables.
      2. sort records and perform calculations.
      3. generate data for forms and reports.
      4. all of the above.
    2. The results of a query are returned in a
      1. form.
      2. datasheet.
      3. file.
      4. report.
    3. Generalized queries that specify fields and records to be selected are called __________ queries.
      1. simple
      2. select
      3. criteria
      4. normal
    4. To see the results of a query, you must __________ it.
      1. save
      2. sort
      3. run
      4. catalog
    5. When two tables are related, data can be extracted from both tables using one query even though the tables are
      1. both primary tables.
      2. both related tables.
      3. separate.
      4. unique.
    6. You can use a common field to create relationships between tables by performing a(n)
      1. hyperlink.
      2. connection.
      3. expression.
      4. join.
    7. The __________ table is the "one" table in a one-to-many relationship.
      1. primary
      2. related
      3. results
      4. control
    8. To make a query available to be run anytime you need it, you must
      1. catalog it.
      2. be certain at least one primary key is included.
      3. save it.
      4. copy it to the clipboard.
    9. When multiple sort keys are selected, the first field selected is the primary sort key and the others are called __________ sort keys.
      1. secondary
      2. alternate
      3. nonunique
      4. adjacent
    10. When you save a query with sort keys defined in it, the sort keys
      1. are saved with the query.
      2. are discarded.
      3. must be redefined the next time the query is run.
      4. are saved as a separate object.
    11. You can tell Access which records are to be selected by specifying a(n)
      1. join.
      2. expression.
      3. filter.
      4. condition.
    12. The __________ operator will cause a record to be selected only if two or more conditions are satisfied.
      1. Or
      2. If..Or
      3. range
      4. And
    13. When you define a query that performs a calculation, you must add a __________ field.
      1. result
      2. control
      3. calculated
      4. dynamic
    14. The Max function determines
      1. the highest field value for the selected records.
      2. if too many fields have been defined for the query.
      3. when too many sort keys have been specified.
      4. when memory needs to be refreshed.
    15. Statistical information, such as totals and averages, can be calculated in a query by using a(n)
      1. expression.
      2. condition.
      3. Aggregate function.
      4. all of the above.
    16. Forms can contain data from more than one table if the tables are
      1. open.
      2. related.
      3. consistent.
      4. in different databases.
    17. A form that shows only one record at a time is a __________ layout.
      1. tabular
      2. datasheet
      3. basic
      4. columnar
    18. If you want to use a form on a frequent basis, you must
      1. catalog it.
      2. save it.
      3. define it.
      4. re-run it.
    19. You can move from field to field within a form by using the
      1. navigation buttons.
      2. Page Up or Page Down keys.
      3. Tab key.
      4. Ctrl+Shift keys.
    20. Bob needs to locate a particular customer record and view it in a form. What command would he use to locate the record?
      1. Seek.
      2. Find.
      3. Locate.
      4. Query.
    21. A search value can be an exact value or it can contain a
      1. logical operator.
      2. relational operator.
      3. wildcard character.
      4. comparison operator.
    22. A form that accesses data from two tables has a main form and a(n)
      1. secondary form.
      2. subform.
      3. related form.
      4. alternate form.
    23. A report is a means of providing a __________ printout of the data in one or more tables.
      1. condensed
      2. related
      3. compacted
      4. formatted
    24. It is a good idea to __________ a database before it is compacted.
      1. make a backup copy of
      2. sort
      3. resequence
      4. remove all filters from
    25. Deleting a record from a table removes it from the display
      1. but does not release the space it occupied.
      2. and releases the space it occupied.
      3. causes the database to be resequenced.
      4. none of the above.
    26. You can rearrange the data and objects in a database and make it smaller as well by __________ it.
      1. compressing
      2. compacting
      3. closing
      4. sorting
    27. If you want a logo to appear on every slide in a presentation, you should include it on the:
      1. slide template.
      2. slide master.
      3. slide document.
      4. slide file.
    28. PowerPoint is a powerful presentation __________ program.
      1. graphics
      2. database
      3. word processing
      4. spreadsheet
    29. Which of the following is an element of a presentation that should be planned?
      1. Type of presentation
      2. Audience needs
      3. Location of the presentation
      4. All of the above.
    30. Which of the following can you NOT create with PowerPoint?
      1. Color overheads
      2. 35mm photographic slides
      3. Videotapes
      4. On-screen slides
    31. In which view can you set special features for your slide show?
      1. Slide Sorter View
      2. Slide Show View
      3. Outline View
      4. Slide View
    32. In which view do you present your slide show?
      1. Slide Sorter View
      2. Slide Show View
      3. Outline View
      4. Slide View
    33. In which view can you see and edit text and graphics on an individual slide?
      1. Slide Sorter View
      2. Slide Show View
      3. Outline View
      4. Slide View
    34. What should you always do before you exit PowerPoint?
      1. Return to Outline View.
      2. Preview your presentation.
      3. Return to Slide View.
      4. Save your work.
    35. In a slide presentation, it's easier for audiences to read _________ phrases.
      1. flowerly
      2. short
      3. long
      4. disjointed
    36. You can delete slides in any view EXCEPT:
      1. Outline View.
      2. Slide View.
      3. Slide Sorter View.
      4. Slide Show View.
    37. What is the term that means to transfer a copy of an item from the Clipboard to a document?
      1. Transfer
      2. Adhere
      3. Glue
      4. Paste
    38. _________ slides are preformatted slides with placeholders already in them.
      1. AutoSlides
      2. AutoLayout
      3. Auto
      4. AutoDesign
    39. PowerPoint provides design _________, which are predetermined colors and formats of the background and type style of titles, accents, and other text.
      1. masters
      2. slides
      3. templates
      4. codes
    40. What are audience handouts?
      1. Refreshments
      2. Explanations of the slides
      3. Printouts of the slides
      4. Disks that contain the presentation file
    41. What should you do to all the slides and speaker notes before printing or presenting a slide show?
      1. Re-arrange.
      2. Spell check.
      3. Save as a Word file.
      4. Reduce the number of slides.
    42. To remove the background graphics from all the slides in a presentation, what button do you click in the Background dialog box?
      1. Apply
      2. Apply to all
      3. OK
      4. Apply to each
    43. Which of the following is NOT a principle for using graphics effectively?
      1. To present information that words can't communicate effectively
      2. To interest and motivate the reader
      3. To save effort in creating the presentation
      4. To increase understanding
    44. A(n) ________ is any item on a slide that you can move, resize, rotate, or otherwise manipulate.
      1. slide item
      2. object
      3. field
      4. placeholder
    45. After you insert a picture into a slide, the picture remains:
      1. enlarged.
      2. selected.
      3. in outline form.
      4. in black and white.
    46. Which view must you be in to insert a picture into a slide?
      1. Slide View
      2. Slide Show View
      3. Slide Sorter View
      4. Outline View
    47. A ________ is an image from a source other than that provided by Microsoft.
      1. picture
      2. graphic
      3. clip art
      4. figure
    48. You should consider file ________ when saving files with graphics on a floppy disk.
      1. type
      2. name
      3. size
      4. compression
    49. Fiber-optic cable has all of the following advantages over cables that use wire except __________.
      1. the capability of carrying significantly more signals
      2. less susceptibility to noise (interference) from other devices
      3. lower costs and easier installation and maintenance
      4. better security for signals during transmission
    50. Microwaves are __________.
      1. radio waves that provides a high-speed signal transmission from one station to another
      2. wireless transmission media that send signals using light waves
      3. space stations that receive earth-based signals and broadcast them over a large area
      4. forms of broadcast radio that are widely used for mobile communications
    51. A communications satellite is a __________.
      1. radio wave that provides a high-speed signal transmission from one station to another
      2. wireless transmission media that sends signals using light waves
      3. space station that receives earth-based signals and broadcasts them over a large area
      4. form of broadcast radio that is widely used for mobile communications
    52. Infrared (IR) is a __________.
      1. radio wave that provides a high-speed signal transmission from one station to another
      2. wireless transmission media that sends signals using light waves
      3. space station that receives earth-based signals and broadcasts them over a large area
      4. form of broadcast radio that is widely used for mobile communications
    53. Transfer rate usually is expressed as __________.
      1. bits per second (bps)
      2. packets per minute (ppm)
      3. cartons per second (cps)
      4. links per minute (lpm)
    54. Integrated Services Digital Network (ISDN), a popular type of digital leased lines, __________.
      1. is a set of standards for digital transmission of data over analog telephone lines
      2. uses sophisticated techniques to transmit a greater number of bytes on a standard twisted-pair cable
      3. is any of several types of digital lines that carry multiple signals over a single communications line
      4. is a service designed to carry voice, data, video, and multimedia at high speeds
    55. A digital subscriber line (DSL), a popular type of digital leased lines, __________.
      1. is a set of standards for digital transmission of data over analog telephone lines
      2. uses sophisticated techniques to transmit a greater number of bytes on a standard twisted-pair cable
      3. is any of several types of digital lines that carry multiple signals over a single communications line
      4. is a service designed to carry voice, data, video, and multimedia at high speeds
    56. T-carrier lines, a popular type of digital leased lines, __________.
      1. is a set of standards for digital transmission of data over analog telephone lines
      2. uses sophisticated techniques to transmit a greater number of bytes on a standard twisted-pair cable
      3. is any of several types of digital lines that carry multiple signals over a single communications line
      4. is a service designed to carry voice, data, video, and multimedia at high speeds
    57. The terminal emulation feature of communications software allows __________.
      1. a personal computer to act as a specific type of terminal so data and resources on a minicomputer or mainframe can be accessed
      2. telephone numbers to be stored, reviewed, selected, and dialed to connect to another computer
      3. one or more files to be sent from one computer to another, as long as each computer has the necessary software
      4. the computer to connect to the Internet to send e-mail, participate in chat rooms, and visit the World Wide Web
    58. A __________ is a network that connects computers in a limited geographical area, such as a school computer laboratory, office, or group of buildings.
      1. local area network (LAN)
      2. regional area network (RAN)
      3. wide area network (WAN)
      4. multiple area network (MAN)
    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.
      1. local area network (LAN)
      2. regional area network (RAN)
      3. wide area network (WAN)
      4. multiple area network (MAN)
    60. A __________ network is a network topology that consists of a single central cable, to which all computers and other devices connect.
      1. bus
      2. star
      3. cab
      4. ring
    61. A __________ is a network topology designed so a cable forms a loop, with all computers and devices arranged along the loop.
      1. bus network
      2. star network
      3. cab network
      4. ring network
    62. A __________ is a network topology in which all of the devices connect to a central computer.
      1. bus network
      2. star network
      3. cab network
      4. ring network
    63. A __________ protocol controls access to the network by requiring that a special signal is shared or passed among network devices.
      1. Ethernet
      2. TCP/IP (Transmission control protocol/Internet protocol)
      3. token ring
      4. ASP/IP (Asymmetric subscriber protocol/Internet protocol)
    64. __________, widely used on the Internet, is a set of protocols used to manage the transmission of data by breaking it up into packets.
      1. Ethernet
      2. TCP/IP (Transmission control protocol/Internet protocol)
      3. Token ring
      4. ASP/IP (Asymmetric subscriber protocol/Internet protocol)
    65. Organizations use __________ to deny network access to outsiders and to restrict employees' access to sensitive data such as payroll or personnel records.
      1. drywalls
      2. seawalls
      3. headwalls
      4. firewalls
    66. A student record would use __________ as a key field because it uniquely identifies each student.
      1. Student ID
      2. Last Name
      3. State
      4. Birthdate
    67. Two disadvantages of a file processing system are __________.
      1. data scarcity and integrated data
      2. data scarcity and isolated data
      3. data redundancy and integrated data
      4. data redundancy and isolated data
    68. The database approach has all of the following advantages except __________.
      1. improved data integrity
      2. increased data redundancy
      3. reduced development time
      4. easier reporting
    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.
      1. transaction processing system (TPS)
      2. decision support system (DSS)
      3. management information system (MIS)
      4. office information system (OIS)
    70. Expert systems are one part of an exciting branch of computer science called __________.
      1. natural intuition (NI)
      2. artificial intuition (AI)
      3. natural intelligence (NI)
      4. artificial intelligence (AI)
    71. __________ are the liaison between the users and the programmers; that is, they convert user requests into technical specifications.
      1. Systems analysts
      2. Network administrators
      3. Vendors
      4. Steering committees
    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.
      1. Computer-aided software engineering
      2. Performance monitoring
      3. Structured analysis and design
      4. Joint application design
    73. The project __________ helps those involved keep track of the huge amount of details in every system.
      1. dictionary
      2. request
      3. plan
      4. team
    74. The advantage of a prototype is that __________.
      1. it does not need to be documented
      2. users can work with the system before it is completed
      3. it eliminates or replaces activities within the life cycle
      4. all of the above
    75. A(n) __________ test verifies that all programs in an application work together properly.
      1. data
      2. systems
      3. integration
      4. acceptance
    76. A(n) __________ test, performed by end-users, checks that the new system works with actual data.
      1. data
      2. systems
      3. integration
      4. acceptance
    77. With __________ conversion, the user stops using the old system and begins using the new system on a certain date.
      1. parallel
      2. pilot
      3. phased
      4. direct
    78. __________ conversion consists of running the old system alongside the new system for a specified period of time.
      1. Parallel
      2. Pilot
      3. Phased
      4. Direct
    79. __________ conversion is used with larger systems that are split into individual sites.
      1. Parallel
      2. Pilot
      3. Phased
      4. Direct
    80. With a __________ conversion, only one location in the organization uses the new system - so it can be tested.
      1. parallel
      2. pilot
      3. phased
      4. direct
 
ANSWER KEY

1.  D
2.  B
3.  B
4.  C
5.  C
6.  D
7.  A
8.  C
9.  A
10. A
11. D
12. D
13. C
14. A
15. C
16. B
17. D
18. B
19. C
20. B
21. C
22. B
23. D
24. A
25. A
26. B
27. B
28. A
29. D
30. C
31. A
32. B
33. D
34. D
35. B
36. D
37. D
38. B
39. C
40. C
41. B
42. B
43. C
44. B
45. B
46. A
47. A
48. C
49. C
50. A
51. C
52. B
53. A
54. A
55. B
56. C
57. A
58. A
59. C
60. A
61. D
62. B
63. C
64. B
65. D
66. A
67. D
68. B
69. B
70. D
71. A
72. C
73. A
74. B
75. B
76. D
77. D
78. A
79. C
80. B