Access

Front 1

Objects

Back 1

the main components that are created and used to make the database function

Front 2

Field

Back 2

the smallest data element contained in a table

Front 3

Record

Back 3

a complete set of all of the data elements (fields) about one person, place, event, or concept

Front 4

Table

Back 4

the foundation of every database, a collection of related records

Front 5

Database

Back 5

one or more tables to store data, one or more forms to enter data into the tables, and one of more reports to output the tabled data as organized information

Front 6

Navigation pane

Back 6

organizes and lists the database objects in an Access database

Front 7

Data sheet view

Back 7

a grid containing columns (fields) and rows (records) similar to an Excel spreadsheet

Front 8

Design view

Back 8

used to create and modify a table’s design by specifying the fields it will contain, the fields’ data types, and their associated properties

Front 9

Form

Back 9

an object that enables you to enter, modify, or delete table data

Front 10

Query

Back 10

a question that you ask about the data in the tables of your database

Front 11

Criterion

Back 11

a number, text phrase, or an expression used to filter the records in a table

Front 12

Report

Back 12

a printed out document that displays information from a database in a format that provides meaningful information to its readers

Front 13

Access speed

Back 13

measures the time it takes for the storage device to make the file content available for use

Front 14

Compact and repair

Back 14

reduces the size of the database

Front 15

Backup

Back 15

creates a duplicate copy of the database

Front 16

Filter

Back 16

displays a subset of records based on specified criteria

Front 17

Comparison operator

Back 17

used to evaluate the relationship between two quantities to determine if they are equal or not

Front 18

Relationship

Back 18

a connection between two tables using a common field

Front 19

Relational database management system (RDBMS)

Back 19

manage groups of data (tables) then set rules (relationships) between tables

Front 20

Join Lines

Back 20

enable you to create a relationship between two tables using a common field

Front 21

Foreign key

Back 21

a field in one table that is also the primary key of another table

Front 22

Enforce referential integrity

Back 22

when checked, access ensures that dat cannot be entered into a related table unless it first exists in the primary table

Front 23

Data redundancy

Back 23

the unnecessary storing of duplicate data in two or more tables

Front 24

CamelCase notations

Back 24

instead of spaces, us uppercase letter to distinguish the first letter in a new word

Front 25

Data type

Back 25

determines the type of data that can be entered and the operations that can be performed on that data

Front 26

AutoNumber

Back 26

a number that automatically increments each time a record is added

Front 27

Field property

Back 27

a characteristic of a field that determines how the field looks and behaves

Front 28

Text data type

Back 28

can store either text or numerical character

Front 29

Number data type

Back 29

store only numerical data

Front 30

Caption property

Back 30

create a more readable label that appears in the top row in data sheet view and in forms and reports

Front 31

Validation rule

Back 31

checks the data entered when the user exits the field

Front 32

Regerential integrity

Back 32

cannot enter a foreign key value in a related table unless the primary ket value exists in the primary table

Front 33

Cascade update/delete

Back 33

automatically update/delete identical records in a table

Front 34

Index property

Back 34

enables quick sorting in primary key fields

Front 35

One to many relationships

Back 35

when the primary key value in the primary table can match many of the foreign key values in the related table

Front 36

Simply Query Wizard

Back 36

provides dialog boxes to guide you through the query design process

Front 37

Delimiter

Back 37

a special character that surrounds the criteron’s value. “ “ for text, # # for numbers

Front 38

Wildcards

Back 38

special characters that can represent one or more characters in a text value

Front 39

Multi table queries

Back 39

contain two or more tables, enable you to take advantage of the relationship that have been set in your database

Front 40

Related tables

Back 40

tables that are joined in a relationship using a common field

Front 41

Syntax

Back 41

the set of rules that access follows when evaluating expressions

Front 42

Expression builder

Back 42

tool to help you create more complicated expressions

Front 43

Function

Back 43

produces a result based on inputs known as arguments

Front 44

Argument

Back 44

a variable or constant that is needed to produce the output for ta function

Front 45

Aggregate functions

Back 45

perform calculations on an entire column of data and return a single value

Front 46

Totals query

Back 46

used to display only aggregate data

Front 47

Record source

Back 47

the table or query that supplies the records for a form or report

Front 48

Split form

Back 48

combines two views of the same record source

Front 49

Splitter bar

Back 49

devides form into two halves

Front 50

Layout control

Back 50

provides guides to help keep controls aligned horizontally and vertically, and five your form a uniform appearance