Maplewood Rice Comp Access Ch 1
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| database | a collection of data that allows access, retrieval, and use
🗑
|
||||
| field | a specific piece of information within a record
🗑
|
||||
| record | a row in a table containing information about a person, product, event
🗑
|
||||
| primary key | a unique identifier in a record, usually a number
🗑
|
||||
| data type | indicates the type of data that can be stored in a field such as text, number, currency
🗑
|
||||
| Access work area | large area for working on objects such as tables, queries, reports
🗑
|
||||
| Navigation pane | pane on the left that contains a list of all objects in the database
🗑
|
||||
| Shutter Bar | an Open/Close button for the Navigation Pane
🗑
|
||||
| Object tab | tabs that appear in the work area when an object is open
🗑
|
||||
| One-to-many relationship | each row in a table may be associated with many rows in another table
🗑
|
||||
| Status bar | lower left bar of Access window, presents information about the object
🗑
|
||||
| Row selector | the small box to the left of the record, when clicked indicates current record with a border
🗑
|
||||
| Number | a field data type that contains only numbers
🗑
|
||||
| Currency | a field data type that contains only monetary values
🗑
|
||||
| Design view | a view for creating fieldnames and data types for a database table
🗑
|
||||
| Datasheet view | a view for entering record information into the database table
🗑
|
||||
| Navigation buttons | buttons used to move within a table
🗑
|
||||
| Field Properties | general and lookup options for each field name and data type
🗑
|
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:
lrice@penncrest.org
Popular Computers sets