click below
click below
Normal Size Small Size show me how
Access Lesson 2
Access Lesson 2 Review Questions
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. |