The first business information systems used in the late 50’s and 60’s.
a. File Processing System
b. Database Technology
c. Distributed DBMS
d. Object-Oriented DBMS
What is File Processing System
100
different parts of each record
What is fields
100
To sort from the smallest to the largest (from A to Z and 0 to 9)
What is Ascending?
100
Each row in access
What is Record
200
Complete the following lines: The more things we record, the more we need for _________
a. Data
b. Information
c. Storage
d. None of the above
What is a Storage?
200
Persons throughout the organization who add, delete, and modify data in the database and who request or receive information from it
a. Programmer
b. System Analyst
c. End-user
d. None of the above
What is an End-user?
200
used just for money
What is currency
200
The view of a table that shows you the data in each record. Like a spreadsheet, the datasheet shows rows(records) and columns (fields)
What is Datasheet View?
200
first and last name are usually used as one field together in a database
True or False
What is false (one field for each)
300
Collection of records; composed of fields; created by application.
a. Database
b. File
c. Record
d. Field
What is a File?
300
Also called update file.
a. Master File
b. Transaction File
c. Table File
d. History File
What is a Transaction File?
300
This contains the records and fields of a database
What is table
300
A view in which you can add, edit, and delete fields from the table, change field types and descriptions, set a primary key, and more.
What is a Table Design View?
300
fields are columns (true/false)
What is true
400
Contains records of permanent, semi-permanent data.
a. Master File
b. Transaction File
c. Table File
d. History File
What is a Master File?
400
The resources that enable the collection, management, control and dissemination of Information throughout the organization.
a. Database Systems
b. Information Technology (IT)
c. Information System (IS)
d. Management Information System (MIS)
What is a Information System (IS)?
400
A collection of database fields designed to be used together.
What is a table?
400
Listing of all the objects (table, form, report, query, macros) in the database.
What is Navigation Pane?
400
To sort from the largest to the smallest. (from Z to A or 9 to 0)
What is Descending?
500
How many different types of Inferential Integrity are there for linking between two tables
What is two (Cascade Delete and Cascade Update)
500
Process of monitoring and maintaining system following installation.
a. Operation Maintenance
b. Prototyping
c. Testing
d. Implementation
What is a Operation Maintenance ?
500
A field that uniquely identifies each record in a table.
What is a primary key?
500
A window showing the data in a tale with one record's field appearing at a time in individually labeled boxes.
What is a form?
500
a database file that does not yet contain any objects (tables, queries, reports, and so on)?