Shared Flashcard Set

Details

Databases
Computer Applications I: Databases
29
Computer Science
9th Grade
01/04/2011

Additional Computer Science Flashcards

 


 

Cards

Term
What is a database?
Definition
A tool for organizing, storing, retrieving, and communicating groups of information that have similar characteristics
Term
What are the four database objects?
Definition
Tables, queries, forms and reports
Term
What does a table do?
Definition
Stores data for the database.
Term
What do all databases contain at least one of?
Definition
A table
Term
What is a row called in a database?
Definition
Record
Term
What is a column called in a database?
Definition
Field
Term
What is a record?
Definition
A group of related fields
Term
What is a field?
Definition
One bit of information in a record; comprised by entries
Term
What is an entry?
Definition
Data typed into a field; made up of characters
Term
What is the function of the data type?
Definition
Defines the value of the cell.
Term
What is the function of a field property?
Definition
Defines the format of the data within the cell.
Term
Why are data types important?
Definition
To control the sorting of data.
Term
What is text?
Definition
Characters that do not require calculations.
Term
What is a memo?
Definition
Lengthy text or combinations of text and numbers
Term
What is a number?
Definition
Characters used in mathematical calculations.
Term
What is currency?
Definition
Values and numeric data used in mathematical calculations involving data with four or more decimal places.
Term
What is autonumber?
Definition
Unique sequential number or random numbers
Term
What is yes/no?
Definition
Answers that contain only two values (also known as true/false)
Term
What is the lookup wizard?
Definition
Creates a field that allows you to choose a value from another table or from a list of values using a list box or combo box.
Term
When should you change the default data type?
Definition
If you need to control how the data in a particular field will be searched, sorted or used on calculations.
Term
What is field size?
Definition
The maximum number of characters you can put in the field (255)
Term
What is format?
Definition
A display layout for the field; can customize the way numbers, dates, times and text are displayed and printed
Term
What is the inpuit mask?
Definition
Makes data easier and to control the values users can enter.
Term
What is a caption?
Definition
A label that gives a brief description to the user.
Term
When should you set a field property?
Definition
If you want to specify how the data will be entered, what data will be entered and how the data will appear.
Term
What is the first step to making a database?
Definition
Sketch it out.
Term
What is always the last step to making a database?
Definition
Entering the data
Term
What should you do as soon as you open a database?
Definition
Save it
Term
What do you do after you have saved the database?
Definition
Create a table
Supporting users have an ad free experience!