CGS1060 Exam 3
(Access) The ______ of a field tells Access what kind of data may be stored in the field. A. Data type B. Unique setting C. Required setting D. Index setting
A. Data type
(Access) Which of the following views in Microsoft Access is used for entering actual data into records? A. Datasheet view B. Preview C. Design view D. Query view
A. Datasheet view
(Access) Each individual chunk of data that collectively make up a record in a database is called a: A. Field B. Query C. Cell D. Record
A. Field
(Access) A field in a table that contains identifiers for records in another table, to whose primary key it is joined is known as a ____ . A. Foreign key B. Descriptor C. Link object D. Relator object
A. Foreign key
(PowerPoint) Which view is most commonly used to edit your presentations slide by slide? A. Normal B. Slide sorter C. Reading D. Slide show
A. Normal
(PowerPoint) If you want to save your presentation so it is backward compatible with versions 97 to 2003, then save your file in this format: A. PPT B. PPTX C. PDF D. HTML
A. PPT
(PowerPoint) A PowerPoint compilation, editing, and organizing feature that allows the user to compile groups of pictures for use in presentations or on the Web. A. Photo album B. ClipArt C. Theme D. SmartArt
A. Photo album
(Access) Since each Social Security Number is unique per person, in the past many companies and organizations used it as a _____ field to uniquely identify their patients, employees, and so on. A. Primary key B. Action key C. Expression D. Identifier
A. Primary key
(PowerPoint) Which PowerPoint tool could be used to quickly and easily depict a series of steps or levels using a pyramid shape with the ability to add your own text to the diagram? A. SmartArt B. WordArt C. ClipArt D. Animation studio
A. SmartArt
(Access) By indexing a field, Access can A. Speed up teaching and sorting records in the table B. Sore a variety of different data types in a particular field C. Ensure that data is being securely stored and backed up D. Make its data available to anyone on the Internet
A. Speed up teaching and sorting records in the table
(PowerPoint) PowerPoint automatically adds placeholders called _______ on your slides that enable you to insert text, pictures, tables, charts, or even videos anywhere in your presentation. A. Text boxes B. Tabs C. Insert tags D. Templates
A. Text boxes
(PowerPoint) A slide design that contains matching complementary colors, major and minor fonts, as well as specific effects, like shadows or reflections is referred to as a: A. Theme B. Cascading design sheet C. Uniform resource pool D. Color-coordinated outfit
A. Theme
(Access) Formatting the appearance of the table will not change the data, just the way you're looking at it. True or False? A. True B. False
A. True
(PowerPoint) After a picture has been inserted into a slide, PowerPoint allows the user to format the picture by changing its brightness, cropping it, or changing its contrast. True or False? A. True B. False
A. True
(PowerPoint) Animations are always applied to objects; they are not applied to the slide itself. True or False? A. True B. False
A. True
(PowerPoint) PowerPoint allows you to narrate your presentation for playback at a later time. True or False? A. True B. False C. D.
A. True
(PowerPoint) The ability to translate your presentation into several different languages is built right into the PowerPoint program. You do not have to download any Add-ons to the program to enable this feature. True or False? A. True B. False
A. True
(PowerPoint) The animation effects are numbered on the slide so you know the order in which they take effect. True or False? A. True B. False
A. True
(PowerPoint) Transitions may also include audio clips, so that when a slide transition occurs, a sound clip will play. True or False? A. True B. False
A. True
(PowerPoint) When an Excel spreadsheet has been inserted into a slide from within PowerPoint, you will have access to some of the Excel functions. True or False? A. True B. False
A. True
(PowerPoint) A simulation of movement added to graphics or text on a slide is called: A. Video B. Animation C. WordArt D.Shape effects
B. Animation
(Access) The purpose of a query is to: A. Display and organize your database objects B. Ask questions and display specific data from a table C. Display the structure of the table object D. Create a new blank database
B. Ask questions and display specific data from a table
(PowerPoint) The outer edge or line around a table is referred to as its: A. Membrane B. Border C. Shell D. Outline
B. Border
(PowerPoint) Graphics that are pre-fabricated and shipped with Microsoft Office for use in its applications and presentations. A. Custom animation B. Clip art C. Text boxes D. AutoFill
B. Clip art
(Access) A single field in a table can have more than one data type defined. A. True B. False
B. False
(PowerPoint) Because of possible copyright infringements, PowerPoint does not allow song clips or music to be added to presentations. True or False? A. True B. False
B. False
(PowerPoint) PowerPoint requires that all inserted pictures come from the local computer, browsing Internet resources for pictures is not allowed. True or False? A. True B. False
B. False
(PowerPoint) Tables in PowerPoint are limited to alphanumeric content and cannot contain media content such as images or video clips. True or False? A. True B. False
B. False
(PowerPoint) Transitions and animations mean the same thing in PowerPoint. True or False? A. True B. False
B. False
(PowerPoint) When a transition effect is chosen, it must be applied to all slides in the presentation. True or False? A. True B. False
B. False
(Access) If there is important calculated data being stored in a field that you do not want displayed to the user, then you may choose to: A. Delete the field B. Hide the field C. Sort the field D. Change the field's data types
B. Hide the field
(Access) A(n) ____ is a combination of literal and mask characters that specifies the format that Access allows users to use when inputting data into a field in a table and is useful for inputting such things as telephone numbers and social security numbers. A. Index B. Input mask C. Data type D. Query
B. Input mask
(Access) When referring to external sources of data, which Microsoft Access method, importing or linking, will allow changes to data from another application to automatically be reflected in the Access database tied to it? A. Importing B. Linking
B. Linking
(PowerPoint) By default, PowerPoint 2013 saves your file in what format? A. PPT B. PPTX C. PDF D. HTML
B. PPTX
(Access) The field that uniquely identifies each record in a table is called a: A. Private key B. Primary key C. Field key D. Personal key
B. Primary key
(PowerPoint) The very top left portion of the window contains icons representing commonly used commands such as save, undo, or start with the presentation from beginning is known as the: A. Navigation pane B. Quick access toolbar C. Backstage view D. Status bar
B. Quick access toolbar
(Access) RDBMS is an acronym for: A. Relative DataBook Manager System B. Relational DataBase Management Systems C. Reporting DataBank Management System D. Reversible DataBase Manager System
B. Relational DataBase Management Systems
(PowerPoint) Which view makes it easy to see all the slides at once and to rearrange the order of the slides in your presentation? A. Normal B. Slide sorter C. Reading D. Slide show
B. Slide sorter
(PowerPoint) The new default slide layout aspect ratio is _____ which reflects the growing use of widescreen displays and HD formats. A. 4:3 B. 12:5 C. 16:9 D. 256:512
C. 16:9
(PowerPoint) WordArt is: A. A step-by-step guide to a procedure such as creating a table or a switchboard. B. A toolbar that displays by default, the Save, Undo, and Repeat buttons and can be customized to display other frequently-used commands. C. A range of visually striking, decorative styles and effects including shadows, reflections, and bevelled edges applied to text in PowerPoint presentations. D. A Linked object, such as a word, phrase, symbol, or image, that you can click to move to a different place in the same document, another document, or a web site; or to open an e-mail message window.
C. A range of visually striking, decorative styles and effects including shadows, reflections, and bevelled edges applied to text in PowerPoint presentations
(PowerPoint) A feature that allows the duplication of animation effects between objects. A. Clipboard B. Format painter C. Animation painter D. Slide sorter
C. Animation painter
(PowerPoint) When you click on an object on your slide such as a table or picture, you will be presented with one or more new tabs on the PowerPoint ribbon. These tabs are called _____ because they are specific to the type of item or object you have selected on the slide. A. Subject B. Manipulative C. Contextual D. Magnifiers
C. Contextual
(Access) Each of the following is an Access data type, EXCEPT: A. Number B. Short text C. Data D. Currency
C. Data
(Access) In order to restrict the data that is inputted into a field, Access can use A. Indexing B. Filtering C. Data validation rules D. Error correction codes
C. Data validation rules
(Access) Which of the following views in Microsoft Access is used for changing the design and structure of tables? A. Datasheet view B. Preview C. Design view D. Query view
C. Design view
(Access) Suppose you want to view only the records in a table that have a value of "FL" in the state field. What can you do to quickly display only those records that meet that criteria? A. Sort the table in ascending order B. Sort the table in descending order C. Filter the table on the state field D. Manually delete all records that do not have FL in the state field
C. Filter the table on the state field
(PowerPoint) To reduce the size of your PowerPoint presentation, you should _____ video clips. A. Refrain from using B. Embed C. Link to
C. Link to
(PowerPoint) If you want to send your presentation to people who don't have Microsoft PowerPoint and you also don't want people to make changes to the presentation, then save your file in this format: A. PPT B. PPTX C. PDF D. XLS
C. PDF
(Access) Each row in a table contains a(n): A. Object B. Field C. Record D. View
C. Record
(Access) Each row in an Access table contains a(n) _____ which consists of multiple fields of information. A. Object B. Fields C. Records D. View
C. Records
(Access) A database object that summarizes the fields and records from a table in an attractive, easy-to-read format is a: A. Form B. Filter C. Report D. Datasheet
C. Report
(PowerPoint) Each "page" of a PowerPoint presentation is referred to as a: A. Worksheet B. Table C. Slide D. Document
C. Slide
(Access) To quickly rearrange a table's records, you can do this to the table data. A. Filter B. Query C. Sort D. Crosstab Query
C. Sort
(Access) Information in a database is typically stored in this, which consists of vertical columns and horizontal rows. A. Field B. Record C. Table D.File
C. Table
(PowerPoint) To find a synonym for a word, use the following tool from the Review tab: A. Spelling B. Comments C. Thesaurus D. Language
C. Thesaurus
(PowerPoint) PowerPoint identifies a possible misspelled word by: A. Circling it with red ink B. Highlighting it with blue and underlining it with a straight blue line C. Underlining it with a red wavy line D. Underlining it with a green wavy line
C. Underlining it with a red wavy line
(Access) The maximum field size for a Short Text field is ___ characters. A. 25 B. 200 C. 15 D. 255
D. 255
(PowerPoint) WMA, MP3, MP4 and WAV are examples of compatible _____ files that may be inserted into PowerPoint presentations. A. Web B. Video C. Animation D. Audio
D. Audio
(PowerPoint) PowerPoint allows you to insert tables into your slides. Tables are organized by columns and rows, the intersection of which is called a: A. Border B. Pane C. Header D. Cell
D. Cell
(PowerPoint) Suppose that you would like to include data in your presentation that comes from an existing Excel spreadsheet. You also want the ability to change data in the PowerPoint presentation table and have it also make the corresponding change in the Excel spreadsheet file. How can you do this? A. It can not be done B. Simply copy and paste dad from Excel into PowerPoint C. Choose "Insert Object" in Powerpoint and insert the spreadsheet directly into the slide D. Choose "Insert Object" in Powerpoint and "link: the spreadsheet to the slide
D. Choose "Insert Object" in Powerpoint and "link: the spreadsheet to the slide
(PowerPoint) Which command group from the Review tab allows us to merge two copies of a presentation so that we may either accept or reject changes that have been made to it by another person? A. Proofing B. Language C. Comments D. Compare
D. Compare
(Access) The data type of an item price, such as $10.50 is : A. AutoNumber B. Number C. Text D. Currency
D. Currency
(Access) When designing a table, each field must have a defined ______ which identifies the kind of data that may be stored in that field. A. Sequence number B. Auto number C. Security ID D. Data type
D. Data type
(Access) If a relationship is established between two tables they will share a common: A. Layout B. Record C. Title D. Field
D. Field
(Access) A ______ can be used to add a custom error message for users when they enter an invalid entry for a data field. A. Report B. Query C. Form D. Field Validation Message
D. Field Validation Message
(Access) The 348 exchange has been moved to the 704 area code. To quickly update the telephone number field of all the records in a table, use this feature in Access. A. Drag and drop B. Hide and seek C. Cut and paste D. Find and Replace
D. Find and Replace
(PowerPoint) PowerPoint is used to create: A. Documents B. Spreadsheets C. Database D. Presentations
D. Presentations
(Access) If you want to sort a table by the price field with the highest prices coming first, you should sort on the: A. Price field in ascending order B. First field in descending order C. Quantity field is ascending order D. Price field in descending order
D. Price field in descending order
(PowerPoint) Which PowerPoint ribbon tab gives you access to the Comments and Compare command groups which are helpful when collaborating with a group on a presentation? A. File B. Home C. Inset D. Review
D. Review
(Access) The data type for a telephone number field is: A. Memo B. AutoNumber C. Number D. Short text
D. Short text
(Access) This data type is used to store up to 255 alphanumeric characters, spaces, and symbols. A. Number B. Date/Time C. Currency D. Short text
D. Short text
(PowerPoint) Which ribbon tab may be used to rehearse and adjust the settings for you presentation delivery? A. Home B. Insert C. Review D. Slide show
D. Slide show
(PowerPoint) Which view gives you an idea of how your presentation will look when you deliver it? A. Normal B. Slide sorter C. Reading D. Slide show
D. Slide show
(PowerPoint) A special effect that marks how one slide moves off and the next slide moves onto the screen is called a(n): A. Phase shift B. Animation C. Justification D. Transition
D. Transition
(Access) The main purpose of a form is to: A. Retrieve specific data from one or more tables or reports B. Display the fields and records from a report in easy-to-read format C. To organize your database objects D. View and enter data into tables
D. View and enter data into table
