Access Vocabulary Terms Lesson 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 | a combination of numbers and text
🗑
|
||||
| Auto Number | automatically adds a unique number to the primary key field for each table
🗑
|
||||
| Blank Database Template | creates a blank database with an empty table on it
🗑
|
||||
| Data Type | determines the kind of data that you can enter in the field
🗑
|
||||
| Default Value Property | enters the same field value in a field every time a new record is added to the table
🗑
|
||||
| Description Property | an optional field property that you can use to describe what to enter in a field
🗑
|
||||
| Design Grid | field names and data types that appear at the top half of the table
🗑
|
||||
| Design View | can add, delete, and make changes to the way that fields store data
🗑
|
||||
| Field Properties Pane | bottom half of the table window, displays only certain properties for the field type
🗑
|
||||
| Field Property | describes a field's contents beyond the fields basic data type
🗑
|
||||
| Field Size Property | sets the number of characters you can store in a Text Number, or Auto Number field
🗑
|
||||
| Format Property | specify how you want Acces to display numbers, dates, times, and text
🗑
|
||||
| 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 | to create database, template and one or more table, query, form, and report objects that you use to enter and view data
🗑
|
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:
Tradams
Popular Computers sets