 | Term | Definition |
| |
Tables, Queries, Forms, Reports, Pages, Macros, Modules |
Seven Types of objects in Access database |
| |
Datasheet, Design, PivotTable, PivotChart |
Four views in Access database |
| |
appears when you open a table or query, resembling a worksheet with rows and columns |
datasheet view |
| |
displays in its own row |
record |
| |
shows in its own column |
field |
| |
includes field properties with formatting options, default values, validation rules, and other field specific chacterizations |
design view |
| |
enter and edit data, find and sort records, resize rows and columns, move rows and columns |
Do this in datasheet view: |
| |
create or modify the layout or structure of a table or query |
Do this in design view: |
| |
a field list and design grid with sorting directions and criteria |
See this in a design view query: |
| |
a grid list of field names, type of data contained in each field, and description of the field |
See this in a design view table: |
| |
number, text, currency, and so on |
Types of data in each field: |
| |
displays information in a table format with columns and rows |
pivot table view |
| |
summarize and analyze data in a table, query, or form; use different levels of detail or organize data |
Do this in pivot table view: |
| |
drag fields and items, and show or hide itemsin drop-down lists for fields |
ways to use detail levels or organize data in pivot table view and pivot chart view: |
| |
displays information ini chart form |
pivot chart view |
| |
run a series of commands, used in repetitive activities and frequent automated procedures |
macros |
| |
contain Visual Basic for Applications' functions or procedures |
modules |
| |
store records about a person, place, thing, or event within fields of information |
tables |
| |
records |
rows |
| |
fields |
columns |
| |
to find answers to questions about specific criteria or conditions in the database AND to calculate totals or averages of information in a table |
purpose of queries |
| |
looks like a paper layout of a record |
forms |
| |
used to easily print out attractive data |
purpose of reports |
| |
designed for use in a Web browser, html documents that are linked to data |
pages |
Share on Facebook
Share on MySpace