Module 5 PowerPoint/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

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

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

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

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

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

By indexing a field, Access can A. speed up searching and sorting records in the table B. store 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 searching and sorting records in the table

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

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

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

By default, Access 2016 saves your file in what format? A. PPT B. ACCDB C. ACC D. HTML

B. ACCDB

By default, PowerPoint 2016 saves your file in what format? A. PPT B. PPTX C. PDF D. HTML

B. PPTX

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

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

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

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.

The outer edge or line around a table is referred to as its: A. membrane B. border C. shell D. outline

B. border

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 table D. change the field's data type

B. hide the field

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

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

RDBMS is an acronym for: A. relative databook manager system B. relational database management system C. reporting databank management system D. reversible database manager system

B. relational database management system

T/F: A single field in a table can have more than one data type defined.

False*

T/F: Because of possible copyright infringements, PowerPoint does not allow song clips or music to be added to presentations.

False,

T/F: PowerPoint requires that all inserted pictures come from the local computer, browsing Internet resources for pictures is not allowed

False, one can browse for pictures online through Bing

T/F The animation effects are numbered on the slide so you know the order in which they take effect.

True, each animation is numbered in order of the sequence

T/F: 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, once inserted the user can format the picture to their needs

The data type of an item price, such as $10.50 is : A. AutoNumber. B. Number. C. Text. D. Currency.

D. Currency.

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 Text

D. Field Validation Text

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

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. Insert D. Review

D. Review

The data type for a telephone number field is: A. Memo B. AutoNumber C. Number D. Short Text

D. Short Text

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

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

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

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

If a relationship is established between two tables they will share a common: A. layout. B. record. C. title. D. field

D. field

PowerPoint is used to create: A. documents B. spreadsheets C. databases D. presentations

D. presentations

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

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

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 tables

T/F Tables in PowerPoint are limited to alphanumeric content and cannot contain media content such as images or video clips.

False

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.

Each of the following is an Access data type, EXCEPT: A.Number B. Short Text C. Data D. Currency

C. Data

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

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

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

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

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. subjective B. manipulative C. contextual D. magnifiers

C. contextual

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

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

To reduce the size of your PowerPoint presentation, you should _____ video clips. A. refrain from using B. embed C. link to

C. link to

Each row in a table contains a(n): A. object. B. field. C. record. D. view.

C. record

Each row in an Access table contains a(n) _____ which consists of multiple fields of information. A. object. B. field. C. record. D. view.

C. record.

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.

Each "page" of a PowerPoint presentation is referred to as a: A. worksheet B. table C. slide D. document

C. slide

PowerPoint identifies a possible misspelled word by: A. circling it with red ink B. highlighting it 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