Theory test_Mod7
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| show | saved with the database
🗑
|
||||
| If you add a record to a form, the record will also get added to the table. | show 🗑
|
||||
| To arrange database information in alphabetical order, it is best to... | show 🗑
|
||||
| show | a & b
🗑
|
||||
| If you click the first record in the State column and then click the Align Text Left button in the Text Formatting group on the Home tab, the formatting will be applied to... | show 🗑
|
||||
| show | Run
🗑
|
||||
| show | Alternate Row Color button in the Text Formatting group
🗑
|
||||
| show | Sort row&then click Ascending
🗑
|
||||
| show | Delete Record
🗑
|
||||
| show | is automatically updated whenever changes are made to those objects
🗑
|
||||
| show | column of data
🗑
|
||||
| show | False
🗑
|
||||
| If you want to add the amounts in the Expenses column... | show 🗑
|
||||
| show | Add a group
🗑
|
||||
| When creating a new record that is almost identical to an existing record, it is best to... | show 🗑
|
||||
| To view what your printed report will look like... | show 🗑
|
||||
| When you use the Form Design button to create a new form, it displays in ____ view. | show 🗑
|
||||
| show | a or b
🗑
|
||||
| show | <$1000
🗑
|
||||
| What is the maximum number of characters a Text field can store? | show 🗑
|
||||
| Which of the following field types allows you to set a maximum field size to prevent data entry errors? | show 🗑
|
||||
| show | Ascending
🗑
|
||||
| You can add fields to a table in Design View and Datasheet view. | show 🗑
|
||||
| To change a street address, locate the appropriate record, double-click the Street Address field, enter the new address, and then press... | show 🗑
|
||||
| show | ==
🗑
|
||||
| When you use the Report button to create a report, the report is displayed in ___ view. | show 🗑
|
||||
| show | a & b
🗑
|
||||
| Records can be added to... | show 🗑
|
||||
| If you are querying a data type field for all employees hired on January 1, 2010, you would enter the criteria as... | show 🗑
|
||||
| When you create a query... | show 🗑
|
||||
| show | a or b
🗑
|
||||
| show | save your report as a PDF
🗑
|
||||
| show | Format
🗑
|
||||
| show | records in the related form are not sorted
🗑
|
||||
| show | all of the above
🗑
|
||||
| show | all of the above
🗑
|
||||
| show | AutoNumber
🗑
|
||||
| show | All Access Objects
🗑
|
||||
| show | Filter button in the Sort & Filter group
🗑
|
||||
| show | Show Table dialog box
🗑
|
||||
| show | Layout
🗑
|
||||
| When you are creating a query in Design View, a _____ displays at the bottom of the screen. | show 🗑
|
||||
| What happens if you press the Tab key after you enter data in the last field of a form? | show 🗑
|
||||
| show | a or b
🗑
|
||||
| show | Queries group on the Create tab
🗑
|
||||
| Which of the following row is NOT part of the query design grid? | show 🗑
|
||||
| show | Toggle Filter
🗑
|
||||
| show | Text
🗑
|
||||
| show | extracting
🗑
|
||||
| When you open an Access database, you see a... | show 🗑
|
||||
| To return sorted data to its original order, click the _____ button. | show 🗑
|
||||
| show | a or b
🗑
|
||||
| show | ascending
🗑
|
||||
| show | Navigation
🗑
|
||||
| To show the amount contributed by each donor to your organization's charity, you would use the _____ button in the Group, Sort, and Total pane. | show 🗑
|
||||
| show | form
🗑
|
||||
| When creating a new field in a table, filling in the field in the _____ column is optional. | show 🗑
|
||||
| show | scroll through the records in a form
🗑
|
||||
| show | Query Wizard
🗑
|
||||
| show | click the single right arrow button (>)
🗑
|
||||
| show | tab at the top of the object
🗑
|
||||
| show | black bar with left&right pointing arrows; double-click
🗑
|
||||
| show | run the query
🗑
|
||||
| When you open a form from the Navigation pane, it opens in _____ view. | show 🗑
|
||||
| Which of the following Access objects provides the most user-friendly data entry method displaying one record at a time? | show 🗑
|
||||
| You can change the font, font size, text color, or fill color by using the options on the... | show 🗑
|
||||
| show | Form view
🗑
|
||||
| To create a new table in Design view, click the _____ button in the Tables group on the Create tab. | show 🗑
|
||||
| show | Criteria
🗑
|
||||
| show | table
🗑
|
||||
| show | Gridlines
🗑
|
||||
| show | populating
🗑
|
||||
| show | the field is not wide enough to display all of the data
🗑
|
||||
| show | Record Navigation
🗑
|
||||
| show | find records that meet a certain condition
🗑
|
||||
| When you add two tables to a query, _____ appears between their common fields. | show 🗑
|
||||
| show | scroll through the records in a form
🗑
|
||||
| show | a and b
🗑
|
||||
| show | primary key
🗑
|
||||
| Temporarily displays only those records meeting a certain condition. | show 🗑
|
||||
| show | Reports
🗑
|
||||
| show | Navigation Pane
🗑
|
||||
| One piece of information that creates the columns in a table. | show 🗑
|
||||
| The view used to enter data into a table. | show 🗑
|
||||
| show | sort it
🗑
|
||||
| show | Detail button
🗑
|
||||
| To display a list of relationships in a ____, click the Relationships button in the Relationships group on the Database Tools tab and then click the All Relationships button. | show 🗑
|
||||
| show | a or b
🗑
|
||||
| You have more options and more control if you create your query using the ... | show 🗑
|
||||
| show | Access saves the data automatically
🗑
|
||||
| show | the Tab key
🗑
|
||||
| An advantage of creating a query is that.... | show 🗑
|
||||
| You can adjust the size of all the fields in a form by hovering the mouse pointer over the right border of a field until it becomes a _____ and then dragging the horde to the desired size. | show 🗑
|
||||
| show | an organized collection of related data
🗑
|
||||
| A collection of related ____ make up a record. | show 🗑
|
||||
| show | tables
🗑
|
||||
| show | a and b
🗑
|
||||
| The most important step in creating a table is... | show 🗑
|
||||
| show | click the double right arrow button (>>)
🗑
|
||||
| Because accuracy is extremely important in working with a database, you should always... | show 🗑
|
||||
| If you want to list peoples whose name begins with R in your query, type _____ of the Name field. | show 🗑
|
||||
| The correct data type to apply to the field "part number" (Ex: 12345) is... | show 🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
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
Created by:
ibenoit95
Popular Computers sets