Microsoft Access Databases Vocabulary
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Columns are the vertical divisions of a table. Fields are represented in tables as columns. Each column in the table represents one field.
🗑
|
|||||
| Criteria are specifications that you want matched when you are searching for or querying records. You specify criteria by using comparison operators.
🗑
|
|||||
| A field's data type specifies and limits what kind of data may be entered into that field (e.g. text, numerical, yes/no).
🗑
|
|||||
| Use a table or form's Datasheet View to view, edit, or add data in tabular form; also useful for formatting some types of subforms.
🗑
|
|||||
| Design view allows you to make changes to the overall formatting, properties, and structure of database objects.
🗑
|
|||||
| A field is a single category of information, such as a phone number, product name, or unit cost, relevant to the entire set of data. Fields of data are the columns in Access tables.
🗑
|
|||||
| A filter is a feature that provides a quick way to select and view designated records. Filters may be applied from within tables, forms, or the datasheet of a query.
🗑
|
|||||
| A form is a feature that shows only the information you want to see, in the order you want to see it. A form is used to view data in a database, enter new data into the database, or edit data.
🗑
|
|||||
| -An input mask is a property that helps to control and format the values entered into a field and might include special characters, spaces, or other formatting.
🗑
|
|||||
| A database object that can be used to view, change, and analyze data in different ways; essentially, it is a question that you ask about the data in your table(s).
🗑
|
|||||
| A record is all of the information collected about a specific event, thing, product, or person. A record consists of as many fields as are in the table or query.
🗑
|
|||||
| A report is a database object used to view and print selected information from a table or query in a customized format.
🗑
|
|||||
| Rows are the horizontal divisions of a datasheet. Each row contains a separate record.
🗑
|
|||||
| Table | A table is a feature, comprised of parallel columns and rows, that is used to store, organize, and view data on a particular topic.
🗑
|
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:
gingerarm
Popular Computers sets