NP Access 4
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Conditional Formatting | Special formatting applied to field values that meet specified conditions.
🗑
|
||||
| Control | An item on a form, report, or other database object that you can manipulate to modify the object’s appearance.
🗑
|
||||
| Control Layout | A set of controls grouped together in a form or report so that you can manipulate the set as a single control.
🗑
|
||||
| Detail Record | In a report based on two tables, the set of field values displayed for each field in the related table.
🗑
|
||||
| Form View | The Access view you use to view, enter, and maintain data in the table on which a form is based.
🗑
|
||||
| Form Wizard | The Access utility that allows you to choose some or all of the fields in a table or query to use as the basis for a form, choose fields from other tables and queries, and display the selected fields in any order on the form.
🗑
|
||||
| Grouped Report | A report in which the data from a record in the primary table appears as a group, followed on subsequent lines of the report by the joined records from the related table.
🗑
|
||||
| Layout View | The Access view that allows you to modify many aspects of a form’s layout and design.
🗑
|
||||
| Main Form | In a form based on two related tables, the form that contains data from the primary table.
🗑
|
||||
| Report Wizard | The Access utility that asks you a series of questions and then creates a report based on your answers.
🗑
|
||||
| Subform | In a form based on two related tables, the form that contains data from the related table.
🗑
|
||||
| Wildcard Character | A placeholder you use when you know only part of a search value or when you want the search value to start or end with a specific character or match a certain pattern.
🗑
|
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:
skindawg
Popular Business sets