Matching

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

field properties

characteristics of a field that control how the field will display and how the data can be entered in the field.

information

data that is organized in a useful manner.

data

facts about people, events, things, or ideas.

datasheet view

the access view that displays an object organized in a format of columns and rows similar to an excel spreadsheet.

design view

the access view that displays the underlying structure of an object.

populate

the action of filling a database table with records

zoom

the action of increasin or decreasing the viewing area of the screen

navigation pane

the area of the access window that displays and organizes the names of the objects in a database, and from where you open objects for use

navigation pane

the area of the access window that displays and organizes thenames of the objects in a database; from here you open objects for use.

objects

the basic parts of a database, which include tables, forms, queries, reports, and macros.

data type

the characteristic that defines the kind of data that can be entered into a field, such as numbers, text, or dates.

primary key

the field that uniquely identifies a record in a table - for example, a student id number at a college.

table design

the number of fields, and the type of content within each field, in an access table.

object window

the portion of the Access window that displays open objects.

object window

the portion of the access window that displays open objects.

run

the process in which access searches the records in the table included in a query design, finds the records that match the specified criteria, and then displays those records in a datasheet; only the fields that have been included in the query design display.

Data Source

the table or tables from which a query selects its data.

database

an organized collection of facts about people, events, things, or ideas related to a particular topic or purpose.

simple select query

another name for a selected query

.Jason Carter

7th period.

table

The Acces object that stores your data organized in an arrangement of columns and rows.

field

a category that describes each piece of data stored in a table

query

a database object that retrieves specific data from one or more tables and then displays the specified data in datasheet view.

select query

a database object that retrieves specific data from one or more tables and then displays the specified data in datasheet view.

reports

a database object that summarizes the fields and records from a table, or from a query, in an easy to read format suitable for printing.

wizard

a feature in microsoft office programs that walks you step by step through a process

multiple items form

a form in which multiple records can be entered into or displayed from a table.

portrait orientation

a page orientation in which the printed page is taller than it is wide.

landscape orientation

a page orientation in which the printed page is wider than it is tall.

table template

a prebuilt table format for common topics such as contacts, issues, and tasks.

form

a window for displaying and collecting information

record

all of the categories of data pertaining to one person, place, thing, event, or idea.

autonumber

an access feature that sequentially numbers entered records creating a unique number for each field and which is useful for data that has no distinct field that is unique.

table + View category

an arrangement of objects in the navigation pane in which the objects are grouped by the table to which they are related.


Ensembles d'études connexes

AP Psychology Chapter 13.1 Key Terms

View Set

module six - metabolic pathways: biology 1308 (textbook)

View Set

Fundamentals - Archer Review (2/3) - Basic Care and Comfort

View Set