Shared Flashcard Set

Details

Managing and Creating Tables
Vocabulary
15
Business
12th Grade
09/08/2015

Additional Business Flashcards

 


 

Cards

Term
Access
Definition
a database management system software program used to organized, store, maintain, retrieve, sort, and print all types of business data.
Term
Database
Definition
comprised of a series of objects that you use to enter, manage, view, and print data,.
Term
Primary Key
Definition
holds data that uniquely identifies each record in a table and is usually an identification number
Term
Join lines or relationships
Definition
they represent links established between tables so that data can extracted from one or more tables
Term
Relational Database
Definition
a database with related tables
Term
Defining the table structure
Definition
process to creating a new table generally involves determining fields, assigning a data type to each field, modifying properties, designating the primary key
Term
Field
Definition
commonly called a column, is a one piece of information about a person, place, or item
Term
Record
Definition
all fields are one unit, such as a customer or product
Term
Table
Definition
a collection of records; organizes data in fields and rows
Term
Field Name
Definition
unique and describes the contents of the field
Term
Data Type
Definition
specifies the type of data that will be entered in the field, helps to manage and maintain the data
Term
Design View
Definition
used in a table to define field names and assign data types
Term
Datasheet View
Definition
used to enter data in fields and organizes fields into columns
Term
Entry
Definition
data for the field
Term
Format
Definition
the way data in a field is displayed
Supporting users have an ad free experience!