Microsoft Office Access 2007- Mcs High School
To my 3rd year students
- 1.
An organized collection of data that is related to a particular subject or purpose.
- A.
Database
- B.
DBMS
- C.
Table
- D.
Primary Key
Correct Answer
A. Database -
- 2.
A computerized or electronic database is more commonly known as a database management system.
- A.
Database
- B.
DBMS
- C.
Table
- D.
Primary Key
Correct Answer
B. DBMS -
- 3.
A table is divided and structure into attributes, which known as:
- A.
Field
- B.
Book Table
- C.
Ribbon
- D.
Title
Correct Answer
A. Field -
- 4.
It is commonly used in the grocery or department store checkout counter. It records your transaction and generates updates reports for the store owner or manager.
- A.
Point-of-sales
- B.
Automated Teller Machine
- C.
Flight Reservation System
- D.
Computerized Inventory System
Correct Answer
A. Point-of-sales -
- 5.
Allows you to conduct banking transaction such as withdrawing and depositing money using your account or transferring money from your savings to your checking account or vice verse.
- A.
Point-of-sales
- B.
Automated Teller Machine
- C.
Flight Reservation System
- D.
Computerized Inventory System
Correct Answer
B. Automated Teller Machine -
- 6.
Allows you to see the details or description of flights, customers, bookings, and reservation.
- A.
Computerized Inventory System
- B.
Flight Reservation System
- C.
Automated Teller Machine
- D.
Point-of-sales
Correct Answer
B. Flight Reservation System -
- 7.
It is often used in warehouse operations to monitor the quantity, locations, and status of product.
- A.
Computerized Inventory System
- B.
Flight Reservation System
- C.
Automated Teller Machine
- D.
Point-of-sales
Correct Answer
A. Computerized Inventory System -
- 8.
It is often used for school to automate the computation of tuition and other school fees.
- A.
Automated Teller Machine
- B.
Enrollment System
- C.
Payroll Payment
- D.
None of the above
Correct Answer
B. Enrollment System -
- 9.
Keeping track of addresses and telephone numbers using a wall calendar can be form as:
- A.
Manual Database
- B.
Electronic Database
- C.
DBMS
- D.
Data Management
Correct Answer
D. Data Management -
- 10.
Simple notes on the refrigerator can be considered as:
- A.
Manual Database
- B.
Electronic Database
- C.
DBMS
- D.
Data Management
Correct Answer
A. Manual Database -
- 11.
It is designed to put all of your information in one table.
- A.
Flat-file database
- B.
Relational database
- C.
Table
- D.
Record
Correct Answer
A. Flat-file database -
- 12.
It is a set of field for a specific item, it represent one entry in a table.
- A.
Flat-file database
- B.
Relational database
- C.
Table
- D.
Record
Correct Answer
D. Record -
- 13.
It is a type of database wherein one or more tables are linked or related to other tables in a database, such as in the library system.
- A.
Flat-file database
- B.
Relational database
- C.
Table
- D.
Record
Correct Answer
B. Relational database -
- 14.
It is the stage where you gather and list all the necessary fields for the database.
- A.
Data Definition
- B.
Data Refinement
- C.
Primary Key
- D.
Relationship
Correct Answer
A. Data Definition -
- 15.
After defining the necessary data needed for the database, some fields might have to be broken down to even more specific fields.
- A.
Data Definition
- B.
Data Refinement
- C.
Primary Key
- D.
Relationship
Correct Answer
B. Data Refinement -
- 16.
In this stage, we analyze the table more tables more closely and think on how relationships between tables can be established so that viewing and accessing of records across tables can be made possible.
- A.
Data defining
- B.
Establish relationship between tables
- C.
Primary Key
- D.
Relationship
Correct Answer
B. Establish relationship between tables -
- 17.
It is an associated established between common fields in two tables. It can be one-to-one, one to many, or many-to-many.
- A.
Data defining
- B.
Relationship
- C.
Establish relationship between tables
- D.
Primary Key
Correct Answer
B. Relationship -
- 18.
It is database management software used to create small and midsize computer-base database.
- A.
Microsoft Office Access
- B.
Microsoft Excel
- C.
Microsoft Paint
- D.
Facebook.com
Correct Answer
A. Microsoft Office Access -
- 19.
It works like the database window which displays all the database objects such as tables, forms, queries, reports, and macros.
- A.
New UI look
- B.
Navigation Pane
- C.
Attachment Data type
- D.
Ribbon
Correct Answer
B. Navigation Pane -
- 20.
It allows you to easily store any supported type of file, including pictures, charts, text files, and so on.
- A.
New UI look
- B.
Navigation Pane
- C.
Attachment Data type
- D.
Ribbon
Correct Answer
C. Attachment Data type -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2022Quiz Edited by
ProProfs Editorial Team -
Aug 16, 2011Quiz Created by
Johnwyne
Back to top