CHS Exam: MS Access Database Quiz!
Questions and Answers
- 1.
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
- A.
Database
- B.
Spreadsheet
- C.
Word processor
- D.
Report
Correct Answer
A. DatabaseExplanation
A database is a computerized filing system that is used to organize and maintain a collection of information for future use. It is designed to efficiently store, retrieve, and manage large amounts of data in a structured format. Unlike spreadsheets, word processors, or reports, a database is specifically designed for data storage and retrieval purposes, making it the most suitable option for organizing and maintaining a collection of information.Rate this question:
-
- 2.
Tables are set up to contain columns and rows of information. In a database table, the columns are called fields.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
In a database table, the columns are called fields. This is because each column in a table represents a specific type of information or attribute, such as a person's name or age. These columns, or fields, are used to organize and store data in a structured manner, allowing for easy retrieval and manipulation of information. Therefore, the statement "In a database table, the columns are called fields" is true.Rate this question:
-
- 3.
In a database table, rows are called __________
- A.
Field
- B.
Report
- C.
Records
- D.
Table
Correct Answer
C. RecordsExplanation
In a database table, rows are called records. Each row in a table represents a single record or data entry. Records contain information about a specific entity, such as a customer, product, or transaction. They are used to store and organize data in a structured manner, allowing for efficient retrieval and manipulation of information.Rate this question:
-
- 4.
Forms, queries, and reports are created based on the information in the _________
- A.
Report
- B.
Form
- C.
Table
- D.
None
Correct Answer
C. TableExplanation
Forms, queries, and reports are created based on the information in the table. Tables are used to store and organize data in a database. Forms allow users to input data into the table, queries retrieve specific data from the table, and reports present the data from the table in a formatted manner. Therefore, the table is the source of information for creating forms, queries, and reports.Rate this question:
-
- 5.
A database and a table is the same thing.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
A database and a table are not the same thing. A database is a collection of related data, while a table is a specific structure within a database where data is organized in rows and columns. A database can contain multiple tables along with other objects like views, indexes, and stored procedures. Therefore, it is incorrect to say that a database and a table are the same thing.Rate this question:
-
- 6.
The _________ _______ is used to identify each record in the table with a number.
- A.
Foreign key
- B.
Autonumber
- C.
Primary key
- D.
None
Correct Answer
C. Primary keyExplanation
A primary key is used to identify each record in the table with a number. It is a unique identifier that ensures each record in the table has a distinct value. By using a primary key, it becomes easier to search, sort, and retrieve specific records from the table. It also helps to maintain data integrity and enforce referential integrity in a relational database system.Rate this question:
-
- 7.
Select the option which best describes a table.
- A.
The part of the database in which information is entered in a user friendly way
- B.
The part of the database in which information is stored
- C.
The part of the database which allows you to take out the information you wish to work with
- D.
The part of the database which looks great when it is printed
Correct Answer
B. The part of the database in which information is storedExplanation
A table in a database is the part where information is stored. It is a structured collection of data organized in rows and columns. Tables store data in a way that allows for efficient storage, retrieval, and manipulation of information. It is the fundamental component of a database system where data is stored in a structured format.Rate this question:
-
- 8.
Use this view to display a table in columns and rows.
- A.
Form view
- B.
Design view
- C.
Datasheet view
- D.
Layout view
Correct Answer
C. Datasheet viewExplanation
The datasheet view is used to display a table in columns and rows. It allows users to view and edit data in a tabular format, similar to a spreadsheet. This view is particularly useful when working with large amounts of data and when performing data entry or data manipulation tasks. The form view, design view, and layout view are other views in database software that serve different purposes, but the datasheet view specifically focuses on displaying data in a table format.Rate this question:
-
- 9.
The first step in designing a new database is:
- A.
Entering data
- B.
Printing reports
- C.
Planning the tables
- D.
Creating forms
Correct Answer
C. Planning the tablesExplanation
The first step in designing a new database is planning the tables. This involves determining the different entities or objects that need to be represented in the database and organizing them into tables. Planning the tables helps in defining the structure and relationships between the data, which is essential for the overall functionality and efficiency of the database.Rate this question:
-
- 10.
The first step in designing a new database is:
- A.
Entering data
- B.
Planning the tables
- C.
Printing reports
- D.
Building relationships
Correct Answer
B. Planning the tablesExplanation
The first step in designing a new database is planning the tables. This involves determining the different entities or objects that need to be represented in the database and organizing them into tables. By planning the tables, the database designer can define the structure and relationships between the tables, which lays the foundation for the rest of the database design process. This step is crucial as it ensures that the database is well-organized and efficient in storing and retrieving data.Rate this question:
-
- 11.
It used to perform an action or set of actions when clicked.
- A.
Label
- B.
Text box
- C.
Combo box
- D.
Action button
Correct Answer
D. Action buttonExplanation
An action button is used to perform an action or set of actions when clicked. It is typically used to trigger a specific function or process in a software application or on a website. When the user clicks on an action button, it initiates the desired action, such as submitting a form, saving data, or navigating to another page. The label, text box, and combo box do not have the same functionality as an action button.Rate this question:
-
- 12.
It is an association established between common fields in two tables.
- A.
Primary key
- B.
Relationship
- C.
Database
- D.
Reports
Correct Answer
B. RelationshipExplanation
A relationship is an association established between common fields in two tables. It allows for the connection and interaction between different tables in a database. By defining relationships, data can be linked and accessed across multiple tables, enabling the generation of meaningful reports and analysis.Rate this question:
-
- 13.
A special form called Switchboard can set up such that anybody can use your database even if they know nothing about Access.
- A.
True
- B.
False
- C.
I Dont Know
Correct Answer
A. TrueExplanation
Switchboard is a feature in Microsoft Access that allows users to create custom menus and forms for their databases. By setting up a Switchboard, anyone, even those with no knowledge of Access, can easily navigate and use the database. This feature simplifies the user experience and makes it more accessible to a wider range of individuals. Therefore, the statement that Switchboard can be set up so that anybody can use the database even if they know nothing about Access is true.Rate this question:
-
- 14.
The database is essential for any type of business. Type the following steps on how to make a database. Step 1 is = Open the MS Access Program Now, type step 2
Correct Answer
type file nameExplanation
After opening the MS Access program, the next step is to type the file name for the database. This is an essential step as it helps in identifying and organizing the database files. By typing the file name, the user can create a new database or open an existing one. It is important to provide a meaningful and descriptive file name that accurately represents the purpose or content of the database.Rate this question:
- 15.
The database is essential for any type of business. Type the following steps on how to make a database. Step 1 is = Open the MS Access Program Now, type step 3
Correct Answer
create table
design tableExplanation
To make a database, the first step is to open the MS Access program. After opening the program, the next step is to create a table, which involves defining the structure and fields of the table. Once the table is created, the next step is to design the table by adding and defining the necessary columns and data types. These steps are crucial in creating a functional and organized database for a business.Rate this question:
- 16.
The database is essential for any type of business. Type the following steps on how to make a database. Step 1 is = Open the MS Access Program Now, type step 4
Correct Answer
create form
design formExplanation
The correct answer is "create form, design form". These steps involve creating and designing a form in the MS Access program, which is a crucial part of creating a database. Forms allow users to input and view data in a more user-friendly manner. By creating a form and designing it according to the specific needs of the business, one can ensure efficient data entry and retrieval within the database.Rate this question:
- 17.
The database is essential for any type of business. Type the following steps on how to make a database. Step 1 is = Open the MS Access Program Now, type step 5
Correct Answer
create report - 18.
MS Access is the same as MS Excel.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
MS Access and MS Excel are both Microsoft Office applications, but they serve different purposes. MS Access is a database management system that allows users to store, organize, and manipulate large amounts of data. On the other hand, MS Excel is a spreadsheet program used for calculations, data analysis, and visualization. While both applications can handle data, they have distinct features and functionalities that set them apart. Therefore, the statement that MS Access is the same as MS Excel is false.Rate this question:
-
- Accreditation Quizzes
- Advanced Placement Quizzes
- AED Exam Quizzes
- Art Exam Quizzes
- Banking Exam Quizzes
- BISC Exam Quizzes
- CADET Exam Quizzes
- CAE Listening Quizzes
- Computer Operator Exam Quizzes
- Cosmetology State Board Quizzes
- CSAT Quizzes
- CVS Exam Quizzes
- EHR Exam Quizzes
- Engineering Exam Quizzes
- English Exam Quizzes
- Entrance Exam Quizzes
- FSHN Exam Quizzes
- GATE Quizzes
- IGCSE Quizzes
- IT Certification Quizzes
- JEE Exam Quizzes
- Management Exam Quizzes
- Ministerial Exam Quizzes
- OCA Exam Quizzes
- Online Test Quizzes
- Physical Exam Quizzes
- Police Exam Quizzes
- Practice Exam Quizzes
- Prelim Exam Quizzes
- Professional Certification Quizzes
- SNAP Quizzes
- SSC Quizzes
- SSC CGL Quizzes
- UGC NET Exam Quizzes
- UPSC Quizzes
Back to top