Chapter 9 Using a Relational Database
How do you select data for copying?
Point to the left of a table entry until pointer changes to a plus sign > then click
What computer application is used for creating a database?
Relational database management system
What is it called when you place records in a specified order?
Sorting
What is a record selector?
A gray box to the left of each record.
What is a record?
A record is a set of data for the fields in a table.
What is a table?
A table is a database object that stores data.
What is it called when data is added to an existing table or used to create a completely new table?
Appended
How do you create a new table in design view?
Click create > table design
How do you copy and paste selected entries from a table to a word document?
Click home > copy, display word document > place insertion point where data is to appear > click home > paste
How do you delete an active record?
Click home > delete > delete record
How do you switch a displayed table from datasheet view to design view?
Click home > view > design view
How do you filter records based on the data in a field?
Click in the field > home > filter
How do you add a new record?
Click new (blank) record
What is is called when data is divided into tables to eliminate unnecessary data duplication?
Data redundancy
Where would you go to control all aspects of a table?
Design view
What is filtering?
Displaying records based on specific criteria.
What is a form?
Form is a database object used for entering records into a table and for viewing existing records.
What is a general number?
General number is the default and displays a number as typed.
How does descending order place records?
Highest to lowest
What does importing data mean?
Importing data means that a file created in one application is converted for use by receiving application.
where would a new form based on the selected table be displayed?
In layout view
What does datasheet view display?
It displays a table in a datasheet where fields are in columns and records in rows.
What is updating?
Modifying a record
What do number fields only store?
Numeric values
What is it called when you add records to a database?
Populating a database
What is assigned to each table to ensure that there no two records in a table are the same?
Primary key
How do you delete a field?
Right click a field name > select Delete Rows from menu
What is portrait?
The default page layout.
What is One Page?
The default view with just one page of the document being displayed at a time.
What is a database?
A database is an organized collection of related data.
