Shared Flashcard Set

Details

Creating Database Tables-Chapter 1
Vocabulary
21
Computer Science
11th Grade
11/30/2010

Additional Computer Science Flashcards

 


 

Cards

Term
Access
Definition
Datacase management system software program used to organize, store, maintain, retrieve, sort, and print all types of buisness data.
Term
Database
Definition
Comprised of a series of objects such as tables,forms, reports, and queries that you use to enter, manage, view, and print data.
Term
Table
Definition
Organizes data in fields (column) and (records). A database must contain at least one table. The table is the base upon which other objects are created.
Term
Query
Definition
used to display data from a table or related tables that meets a conditional statement and/or to preform calculations. For example, display only those records in which the city is Vancouver.
Term
Form
Definition
Allows fields and records to be presented in a different layout than the datasheet. Used to facictate data and maintenance.
Term
Report
Definition
Prints data from tables or queries.
Term
Field
Definition
Describe a person, customer,client, object, place, idea, or event.
Term
Field Name
Definition
Unique and describes the contents of the field; can contain up to 64 characters.
Term
Data Type
Definition
Specfies the type of data you can enter in a field; helps to manage and maintain data.
Term
Field Size
Definition
Consider the data that will be entered in the field than sorten or lengthen the number fo accomodate any possible entries.
Term
Active Database
Definition
Is saved automatically on a periodic basis; also when another record is made active, a table or database is closed.
Term
Add a mew recprd tp table
Definition
Click the New Button in the Records group inHome tab or Ctrl+Shift++.
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; organizes fields; organizes fields into columns.
Term
Text Fields
Definition
Store characters (letters, symbols, words, a combination of letters and numbers)
Term
Single Size
Definition
Fields that store a number with a decimal portion.
Term
Long Integer
Definition
Fields that store only whole numbers.
Term
Autonumber Field
Definition
Field that automatically stores a numeric value that is onw greater thatn that in the last record added.
Term
Entry
Definition
Data for a field.
Term
Format
Definition
The way data in a field is displayed.
Term
Record
Definition
Information about one person or thing.
Supporting users have an ad free experience!