ACCESS Chapter 1: End of Chapter Quiz, Access Chapter 1, Access Chapter 2, BCIS Review 9
Shift
Select multiple controls to format by holding down
Referential integrity
Set of rules that ensures that the data between related tables is valid.
Ascending
Sorting order that arranges text alphabetically (A to Z) and numbers from the lowest number to the highest.
Descending
Sorting order that arranges text in reverse alphabetical order (Z to A) and numbers from the highest to the lowest.
Comparison operators
Symbols of =,<, and >.
autonumber
The data type that describes a unique sequential or random number assigned by Access as each record is entered is:
currency
The data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places is:
short text
The data type that describes text, a combination of text and numbers or numbers that re not used in calculations, such as ZIP code is:
Table
The database object that stores the data, and which is the foundation of an Access database.
Do not keep group together on one page
The default setting for grouping of records in a report is
primary key
The field that uniquely identifies a record in a table is known as the:
Text box control
The graphical object on a form or report that displays the data from the underlying table or query
Control layout
The grouped arrangement of controls on a form or report
report
The object that displays fields and records from a table or query in a printable format is a:
query
The object that retrieves specific data and then displays only the data that you specify is a:
Tab order
The order in which the insertion point moves from one field to another in a form when you press the Tab key is
Normalization
The process of applying design rules and principles to ensure that a database performs as expected.
Filtering
The process of displaying only a portion of the total records (a subset) based on matching specific values to provide a quick answer is
Detail section
The section of a form or report that displays the records from the underlying table or query
Bound
The term used to describe objects and controls that are based on data that is stored in tables
structure
The underlying design of a table is referred to as the:
Object window
The window area that displays each open object on its own tab.
Navigation Pane
The window area that organizes the database objects and from which you open objects.
append
To add on to the end of an object, such as to add records to the end of an existing table, is to:
Design View
To align controls in a report, first display the report in
Unfiltered
To apply a filter that has been saved with a form, in the navigation area, click
Join line
Visual cue in the relationship window that indicates tables are related by connecting common fields
*
Wildcard character that serves as a placeholder for one or more unknown characters.
operating, application, utility
3 categories of software
cpu, clock speed, ram
3 components that determine comp speed
Field name, data type, field size
3 items to define a table
windows android macintosh
3 operating systems
quicken, numbers, calc
3 spreadsheet apps
Base, Dbase, Oracle
3 types of Database
notepad write pages
3 types of Word processing apps
micro server embedded
3 types of computers
antivirus system backup registry cleaner
3 utility programs
Labels, values, date, formulas, functions, links
6 items that go in a cell
Tables, Quieries, Forms, Reports, Pages, Macros, Modules
7 Objects of Database
AND
A condition in which records display only when all of the values are present in the selected fields is
Label control
A control on a form or report that contains descriptive information, typically a field name
Date control
A control on a form or report that inserts the current date each time the form or report is opened
Calculated control
A control that contains an expression, often a formula or function, that most often summarizes a field that contains numerical data
Unbound control
A control that does not have a source of data, such as a title in a form or report
Bound control
A control that retrieves the data from an underlying table or query
Group, Sort, & Total pane
An area that displays at the bottom of the window in which you can control how information is sorted and grouped in a report is the
Trust center
An area where you can view the security and privacy settings for your Access installation.
Relationship
An association that you establish between two tables based on common fields.`
Control
An object on a form or report that displays data, performs actions, and lets you work with information
Database
An organized collection of facts about people, events, things, or ideas related to a specific topic.
Message bar
Area directly below the ribbon that displays information such as security alerts.
25 GB 50 GB
Blu-Ray
700 MB
CD
field properties
Characteriestics of field that control how the field displays and how date is entered are:
Between and
Comparison operator that searches for values within a range.
Criteria
Conditions in a query that identify the specific data for which you're looking.
Parameter
Criteria that can be changed when a query is run.
Is null
Criteria that searches for fields that are empty.
4.7 GB
DVD
Information
Data that is organized in a useful manner.
Form header
Information, such as a form's title, that displays at the top of the screen in Form view and is printed at the top of the first page when records are printed as forms
And
Logical operator that requires all criteria to be met.
Design grid
Lower area of the query design window where criteria is entered.
Aggregate functions
Min, Max, Avg, and Sum are examples of..
the harddrive
Operating system manages
property sheet
Precise changes to the properties--characteristics of selected items in database can be made in the:
Foreign key
Primary key field is connected to this field in the related table to create a relationship.
Run
Process in which Access looks for records in a table based on the fields and criteria in the query design. Finds those records and then displays the records in a datasheet.
Sorting
Process of arranging data in a specific order based on the data in a field.
Parameter query
Query that prompts you for criteria when it is run.
Statistics, engineering, payroll, scheduling
Reasons to use Spreadsheets
One to many relationship
Relationship between 2 tables where one record in the first table corresponds to many records in the second table.
Cascade options
Relationship options that enable you to update records in related tables when referential integrity is enforced.
moves in the direction
Relative reference
volatile, fast, expensive
primary memory
nonvolatile, slow, inexpensive
secondary memory
Form
A database object that you can use to enter new records into a table, or to edit, delete, and display existing records in a table is a
Common field
A field in one or more tables that stores the same data.
Section bar
A gray bar in a form or report that identifies and separates one section from another
relational database
A more sophisticated type of database that stores multiple collections of data that are related to one another for example, data about the students, the courses, and the faculty members at a college is a:
Theme
A predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied to all of the objects in a database or to individual objects is a
First (principle of good database design)
A principle stating that data is organized in tables so that there is no redundant data.
Second (principle of good database design)
A principle stating that techniques are used to ensure the accuracy of data entered into a table.
Crosstab query
A query that uses an aggregate function and displays data grouped by two types of information.
Flat database
A simple database file that is not related or linked to any other collection of data.
Field
A single piece of information that is stored in every record and represented by a column in a table.
Layout selector
A small symbol that displays in the upper left corner of a selected control layout in a form or report that is displayed in Layout view or Design view and that is used to move or format an entire group of controls is the
Record
A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea.
stays the same
Absolute reference
Filter by Form
An Access command that filters the records in a form based on one or more fields, or based on more than one value in the field, is
Design view
An Access view that displays the detailed structure of a query, form, or report
Report wizard
An access tool that walks you step by step through the creation of a report is the
specific task
An application manages a
Data
Facts about people, events, things, or ideas.
Number, short text, currency, memo, attachment, date, hyperlink
Field Data types
Calculated field
Field that stores the value of a mathematical operation.
Colon
For a calculated field, the new field name must be followed by...
Subdatasheet
In Datasheet view, clicking the plus sign displays the related records in this format.
Outermost
In Datasheet view, when sorting using multiple fields, the field that is used for the 1st level of sorting.
Innermost
In Datasheet view, when sorting using multiple fields, the field that is used for the 2nd level of sorting.
Field list
In the query design window of the table area, the list of field names in a table.
Form footer
Information at the bottom of the screen in Form view that prints after the last detail section on the last page
Group Footer
Information printed at the end of each group of records in a report that is most commonly used to display summary information is the:
redundant
Information repeated in a database in a manner that indicates poor design is said to be:
Layout view
The Access view in which you can make changes to a form or report while viewing the data
Datasheet view
The Access view that displays data in columns and rows like an Excel worksheet is:
Populate
The action of filling a database with records.
Objects
The basic parts of a database; for example tables, forms, queries, and reports.
record selector box
The box at the left of a record in a Datasheet view that you click to select an entire record is the:
data type
The characteristic that defines the kind of data you can store in a field is the: