Access Lesson 2 Review Questions
Help!
|
|
||||
|---|---|---|---|---|---|
| The bottom part of design view is called what? | Field Properties
🗑
|
||||
| The _________ buttons are used to move around the datasheet. | Navigation buttons
🗑
|
||||
| What is the record pointer? | A tool the computer uses to keep track of the current record
🗑
|
||||
| True or False: When the data in a cell is highlighted, you can replace the text by simply typing over it. | True
🗑
|
||||
| What are the 3 ways to "Undo" changes to a cell? | 1. Undo button on toolbar 2. Esc key 3. Undo on Edit menu
🗑
|
||||
| _________ selectors are at the top of a table and contain the field name | Field Selectors
🗑
|
||||
| How can you select all records in a database? | Clicking the upper-left corner of table
🗑
|
||||
| Where are record selectors located? | to the left of a record's first field
🗑
|
||||
| To select multiple fields, hold down the ______ key and select the field selectors. | Shift
🗑
|
||||
| What are three ways to delete a record. | 1. Delete Record button on toolbar 2. right click and Delete Record 3. Delete key
🗑
|
||||
| True or False: You can delete fields in design view only. | True
🗑
|
||||
| True or False: You can undo the deletion of a record. | False
🗑
|
||||
| You must use the _________ _________ option when you wish to cut or copy an entire record as a new record. | Paste Append
🗑
|
||||
| True or False: Changing the width of one column changes all columns. | False
🗑
|
||||
| True or False: Changing the height of one row changes all rows. | True
🗑
|
||||
| What are 3 ways to change the height of a row? | 1. Format menu, Row Height 2. Right click, row height 3. Hold mouse over row border for double arrow
🗑
|
||||
| What are two ways to "Best Fit" a column? | 1. Format menu, Column width, Best Fit 2. Double click on right border of column selector
🗑
|
||||
| True or False: When rearranging columns, a vertical bar follws your mouse pointer to show the new location. | True
🗑
|
||||
| __________ __________ allow you to further customize a field beyond merely choosing a data type. | Field properties
🗑
|
||||
| The default size for text data type is ____. | 50
🗑
|
||||
| The maximum size for a text data type is _____. | 255
🗑
|
||||
| True or False: You can determine a field size for all data types. | False
🗑
|
||||
| The _______ field property specifies how you want Access to display numbers, dates, times, and text. | Format
🗑
|
||||
| A _______ _______ allows you to control the data pattern or format allowed in the field. | Input Mask
🗑
|
||||
| Give a few examples of what kinds of data input masks are used for. | Phone numbers, social security numbers, dates, etc.
🗑
|
||||
| True or False: When you type in the "Caption" field property, the text replaces the field name. | True
🗑
|
||||
| You would use the _________ _________ field property when you have a field that usually contains the same value. | Default Value
🗑
|
||||
| What is the "Required" field property? | Specifies whether you must enter a value in the field.
🗑
|
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:
lmsmissy
Popular Computers sets