AR CBA Access Ch 2
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| alphanumeric data | combination off numbers and text
🗑
|
||||
| autonumber | automatically adds a unique number to the primary key field for each record in the table
🗑
|
||||
| blank database template | creates a database with no objects in it only an empty table
🗑
|
||||
| data type | determines the kind of data that you can enter into the field
🗑
|
||||
| default value property | design grid is an optional field property that you can use to describe what to enter in the field
🗑
|
||||
| design grid | top half of screen when in design view; has field name, data type, and description
🗑
|
||||
| design view | you can add, delete, and make changes to the way fields store data
🗑
|
||||
| field properties pane | bottom half of the table window in design view
🗑
|
||||
| field property | describes a field's contents beyond the field's basic data type
🗑
|
||||
| field size property | sets the number of characters you can store in a text, number, or autonumber field
🗑
|
||||
| primary key | field that contains a unique field value for each record in the table
🗑
|
||||
| required property | specifies whether you must enter a field value in a record
🗑
|
||||
| template | premode database with object sin it for you to enter data
🗑
|
||||
| format property | specifies how you want Access to display numbers, dates, times, and text
🗑
|
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:
Jamie.HenleyatLonoke
Popular Computers sets