Access - CIS

Helpfulness: 0
Set Details Share
created 5 years ago by CapriciousCiara
157 views
updated 5 years ago by CapriciousCiara
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:
1

Datasheet View

A view that enables you to add, edit, and delete the records of a table.

2

Design View

A view that enables you to create tables, add and delete fields, and modify field properties; or to change advanced design settings not seen in Layout view, such as a background image.

3

Field

The smallest data element in a table, such as first name, last name, address, or phone number.

4

Filter

Displays a subset of records based on a specified criterion.

5

Form

A database object that is also a primary key of another table.

6

Relationship

A connection between two tables using a common field.

7

Primary Key

The field (or combinations of fields) that uniquely identifies each record in a table.

8

Navigation Pane

An interface element that organizes and lists database objects.

9

Query

Enables you to ask questions about the data stored in a database and then provides the answers to the questions by providing subsets or summaries of data.

10

Record

A group of related fields representing on entity, such as data for one person, place, event, or concept.

11

Report

An object that contains professional-looking formatted information from underlying tables or queries.

12

Sort

The process of listing records or text in a specific sequence, such as alphabetically by last name.

13

Criterion

A number, text phrase, or an expression used to select records.

14

Table

An object used to store and organize data in series of records.

15

Calculated Field

Produces a value from an expression or function that references one or more existing fields.

16

Caption Property

Used to create a more readable label that appears in the top row in Datasheet View and in forms and reports.

17

Criteria Row

A row in the Query Design view that determines which records will be selected.

18

Referential Integrity

Rules in a database that are used to preserve relationships between tables when records are changed.

19

Data Type

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

20

Null

The term Access uses to describe a blank field.

21

Simple Query Wizard

Provides dialog boxes to guide you though the query design process.

22

One-To-Many Relationship

A relationship established when the primary key value in the primary table can match many of the foreign key values in the related table.

23

Validation Rule

Prevents invalid data from being entered into a field.

24

Argument

Any data needed to produce output for a function.

25

Order of Operations

Determines the sequence by which operations are calculated in an expression.

26

Property Sheet

Enables you to change settings such as number format, number of decimal places, and caption, among many others.

27

Expression

A formula used to calculate new fields from the values in existing fields.

28

Expression Builder

An Access tool that helps you create more complicated expressions.

29

Function

A predefined computation that simplifies creating a complex calculation and produces a result based on inputs known as arguments.

30

Constant

A value that does not change.

31

Syntax

The rules that dictate the structure and components required to preform the necessary calculations in an equation or to evaluate expressions.

32

PMT Function

A predefined formula in Excel that calculates he periodic loan payment.

33

Total Row

A table row that displays below the last row of records in an Excel table, or in Datasheet view of a table or query, and displays summary or aggregate statistics, such as a sum or an average.

34

Totals Query

Makes an additional row available in the query design grid. Used to display aggregate data when the query is run.

35

Control

The text boxes, buttons, boxes, and other tools you use to add, edit, and display the data in a form or report.

36

Report View

Enables you to see what a printed report will look like in a continuous page layout.

37

Report Tool

Used to instantly create a tabular based on the table or query currently selected.

38

Report Wizard

Asks you questions and uses your answers to generate a customized report.

39

Record Source

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

40

Form Tool

Used to create data entry forms for customers, employees, products, and other primary tables.

41

Form View

A simplified interface primarily used for data entry. Does not allow you to make changes to the layout.

42

Layout View

Enables users to make changes to a layout while viewing the data on the form or report.

43

Layout Control

Provides guides to help keep controls aligned horizontally and vertically and give your form a uniform appearance.

44

Split Form

Combines two views of the same record source--one section is displayed in a stacked layout, and the other section is displayed in a tabular layout.

45

Stacked Layout

Displays fields in a vertical column.

46

Tabular Layout

Displays data horizontally.

47

Theme

A collection of design choices that includes colors, fonts, and special effects used to give a consistent look to a document, workbook, database form or report, or presentation.