| Question |
Answer |
| 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. |
BIOL3326 Forms
