Creating a Database
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 | Data containing numbers, text, or a combination of numbers and text.
🗑
|
||||
| AutoNumber | Data type that automatically adds a unique field value to each record in a table.
🗑
|
||||
| Blank database template | A template that creates a database that contains only an empty table.
🗑
|
||||
| Data type | The property of a field that determines the type of data that you can enter into the field, such as numbers or text.
🗑
|
||||
| Default Value property | A field property that lets you specify the value to enter into that field for each record in a table.
🗑
|
||||
| Description property | An optional field property that you can use to describe the data to store in the field.
🗑
|
||||
| Design grid | The top half of the Table window in Design view that displays the name, data type, and optional Description property for each field in a table.
🗑
|
||||
| Design view | The view of a table that lets you add, delete, and rearrange field. You can also use Design view to make changes to the way that fields store data.
🗑
|
||||
| Field Properties pane | The bottom half of the Table window in Design view that displays properties for the selected field in a table.
🗑
|
||||
| Field property | An additional description of a field beyond the field's data type specifying how to store data in the field, like the number of characters the field can store.
🗑
|
||||
| Field Size property | Property identifying the number of characters that a Text, and Number, or an AutoNumber field can store.
🗑
|
||||
| Format property | Property for a field specifying how to display numbers, dates, times, and text.
🗑
|
||||
| Primary key | Field in a database table containing a unique field value for each record in the table.
🗑
|
||||
| Required property | Field property specifying whether a value must be entered into the field.
🗑
|
||||
| Template | An object that you can use to create a database, table, or field in a database.
🗑
|
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:
KatMead
Popular Computers sets