Access Ch. 1

¡Supera tus tareas y exámenes ahora con Quizwiz!

Relational Database

Sophisticated database that stores multiple collections of data that are related to one another.

Table

The database object that stores the data and is the foundation of a database.

Primary key

The field that uniquely identifies a record in a table.

Report

The object that displays fields and records from a table or query in printable format.

Query

The object that retrieves specific data and then displays only that data

Normalization

The process of applying design rules and principles to ensure the database performs as expected

Structure

The underlying design of a table

Object Window

The window area that displays each 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

Database

An organized collection of facts about people places or things

Objects

Basic parts of a database including tables, queries, forms, and reports.

Field Properties

Characteristics of a field that control how the field displays and how data is entered

Information

Data that is organized in a useful manner

Autonumber

Data type that describes a unique sequential or random number assigned by Access

Currency

Data type that describes monetary value

Short text

Data type that is a combination of text and numbers

Property sheet

Precise changes to the characteristics of selected items

Redundant

Repeated information

Data type

The characteristic that defines the kind of data you can store in a field.

Common field

A field in one or more tables that stores the same data

Record

A table row that contains all of the categories of data relating to one person place or thing

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.

Daya

Facts about people places or things

Data sheet view

The Access view that displays data in columns and rows.

Populate

The action of filling a database with records

Record selector box

The box at the left in Datasheet View that allows you to select an entire record


Conjuntos de estudio relacionados

VB Management- Recruiting, Resumes & Hiring

View Set

CHAPTER 5, CHAPTER 6, CHAPTER 7, CHAPTER 8

View Set

Research Methods I - Practice Exam 2

View Set

Chs. 4, 5, 6, 8, 10, 11, Presenting Results FINAL EXAM PSYCH 1B

View Set

Chemistry: ch. 4 quantum numbers part 1

View Set

(C2W4): Start the UX Design Process: Empathize, Define, and Ideate - Weekly Challenge 4: Define user problems

View Set