Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
itsc test 4
| Question | Answer |
|---|---|
| You can click the________ button on the Query datasheet toolbar to sort records in ascending alphabetical order by values in a selected field. | Ascending |
| In Datasheet view, clicking a row selector selects an entire ______. | record |
| In Datasheet view, the star symbol that appears in the record selector area always identifies the ___________ in the database. | next available row for a new record |
| When you first open a(n) _________, Access selects the first field value in the first record. | datasheet |
| A _______ is a question you ask about data stored in a database. | query |
| The first step in organizing data into a database is to define the ________. | fields |
| A database is a convenient way to _____, _____ and ________ related data. | enter, retrieve, and maintain |
| The three basic steps to creating a database, in order, are: ____________. | identify the individual fields, group fields in table, enter field values for record. |
| The content of any given field is the _________. | field value |
| All fields for a specific individual or place can be grouped together as a(n) _______. | table |
| Which of the following could be defined as a field in a database? | ** all of the above |
| A field can be described as a(n) _______. | attribute |
| A field, or a combination of fields, that has a unique value is a ___________. | primary keys |
| The ________ determines what field values are allowed and what other properties the field will have. | data type |
| A _________ name must be unique within a database. | table |
| When you use the number data type to define a field, you should set the field's ________ property based on the largest value you expect to store in that field. | field size |
| The maximum size of a Text data type is _______ characters. | 255 |
| The Decimal property setting for Number fields stores positive and negative numbers to precisely ___ decimal places and uses 12 bytes. | 28 |
| It would be wasteful to use the Long Integer setting when defining a field that will only store whole numbers ranging from o to 255, because the Long Integer setting will use _____ bytes of storage. | 4 |
| You can specify a name for a table after you click the ______ button on the Table Design toolbar. | save |
| The final step in the creation of a table is to save the table ________ to disk. | structure |
| A primary key ________________________________. | uniquely identifies each row in a table |
| Access assigns the AutoNumber as the default ___ value for the primary key field when a new table is created. | ID |
| You should carefully design your _________ to meet the needs of those who will use it. | database |
| A table can be logically connected to another table by defining a ___________. | common field |
| In PowerPoint an easy way to apply several formats at once to an object is to apply a ________ to it. | style |
| A query can be run at any time during the creation of the query by clicking the _______ button in the Results group on the Query Tools Design tab. | view |
| ___________ relationship exists between two tables when one record in the first table matches zero, one, or many records in the second table. | a many-to-one |
| Referential ___________ is a feature built in to Access to prevent data inconsistency in related tables. | integrity |
| ________ tables are separate tables but you can use the data in them as if they were one table. | joined |
| ________ fields can be unique or non-unique. | sort |
| When you sort a field with a Yes/No data type in ____________ sort order, the no values display first, followed by the yes values. | descending |
| Operators used in selection criteria in a query, such as equal, not equal, or greater than, are known as __________ operators. | comparison |
| A Range of values may be specified as selection criteria by using the _________________. | between... and operator |
| PowerPoint _________ are faint blue, dashed lines that appear as you drag an object near a drawn shape. | smart guides |
| In PowerPoint _________ are words or phrases that describe the clip art part of a slide. | keywords |
| Queries can be created by using the __________, which prompts you for the information required to build the query. | query wizard |
| When using PowerPoint, changing a first-level bulleted item into a slide title, is called __________ the item. | promoting |
| PowerPoint allows you to rearrange the slides by using the ___________ view which displays all slides in the presentation as thumbnails. | slide sorter |
| The options at the bottom of the AutoFormat dialog box allow you to apply the selected AutoFormat or just its, __________ and ______. | font, color, and style |
| In PowerPoint a ___________ is a region of a slide reserved for inserting text or graphics. | placeholder |
| In PowerPoint the ___________ feature automatically corrects certain words and typing errors. | autocorrect |
| When using PowerPoint, a ________ can be a picture, shape, design, graph, chart or diagram. | graphic |
| In PowerPoint, you can modify the text of a slide in the ________ tab as well as the _________. | outline. slide pane. |
| When using PowerPoint the ___________ view displays each slide so that it fills the entire screen, with no toolbars or other Windows elements visible on the screen. | slideshow |
| In PowerPoint, ________ notes help the speaker remember what to say when a particular slide appears during a presentation. | speaker |
| A _________ is a grid of square colored dots that form picture on a PowerPoint slide. | bitmap |
| To make the slide show more interesting you can add transitions between the slides. | To make the slide show more interesting you can add transitions between the slides. |
| A __________ is a PowerPoint file that contains a theme, sample text, and graphics to guide you as you develop your content. | template |
| In PowerPoint _________ view displays each slide so that it almost fills the entire screen. | reading |
| access data can be exported to a ____ table then formatted | word |
| when linking Excel worksheet data to a word document start the ______ program first | source |
| with integration, the program used to create the file where you want to insert the object is the __________________ | destination program |
| with integration, when you ____ an object a copy of the object along with a link to the source program becomes part of the destination file. | embed |
| an _______ is anything that can be manipulated as a while such as a chart, table, picture, video, sound clip or almost anything you can create on a computer | object |
Created by:
EmilyWatlington