Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
12 Cards in this Set
- Front
- Back
|
What is a database?
|
It is an organized collection of data
|
|
|
What is the difference between a flat database and a rational database?
|
A flat data base is not related or linked to any other collection of data such as a address book. On the other hand multiple collections are related to one another. An example would be the students the courses and the faculty members at a college.
|
|
|
What is database management system (DMS) is Microsoft 2010 an example of?
|
a relational database management system.
|
|
|
What is datasheet view?
|
It displays data as columns and rows similar to excel worksheet. is found in the view option under fields.
|
|
|
What a table row called?
|
a record
|
|
|
What is a table column called?
|
a field
|
|
|
What is the first principle of a good database design?
|
It is to organize data in the tables so that redundant duplicate data does not occur.
|
|
|
What is the second principle of a good database design?
|
It is to use techniques that ensure the accuracy of the data when it is entered into the table.
|
|
|
What is a common field?
|
a field in one or more tables that store the same data.
|
|
|
What are the advantages of databases?
|
Data Integrity – ensure that the data is accurate and reliable
Information Sharing – one database that several departments can use Flexible Use of Data – organize the information based on your needs. |
|
|
What are the six objects in access and what they do?
|
Tables – Data in rows and columns like a spreadsheet when in Datasheet View
Queries – Request to database, ask a question Forms – View one record at a time Reports – Professional looking output Modules – Collection of programming procedures Macros – Sequence of instructions with click of a mouse |
|
|
What is a primary key?
|
The field that uniquely identifies a record in a table. An example would be a Student ID number at a college.
|
