Week 6 Access Quiz 3
Questions and Answers
- 1.
A DATABASE IS MADE UP OF
- A.
TABLES, QUERIES, OBJECTS, REPORTS
- B.
TABLES, QUERIES, FORMS, REPORTS
- C.
TABLES, QUERIES, OBJECTS, FORMS
Correct Answer
B. TABLES, QUERIES, FORMS, REPORTSExplanation
A database is made up of tables, which store the actual data in a structured format. Queries are used to retrieve and manipulate the data stored in the tables. Forms provide a user-friendly interface for entering and viewing data in the tables. Reports are used to present the data from the tables in a formatted and organized manner. Therefore, a database is made up of tables, queries, forms, and reports.Rate this question:
-
- 2.
A TABLE IS
- A.
USED TO AUTOMATE TASKS
- B.
USED TO RETRIEVE SPECIFIC DATA
- C.
A SET OF COLUMNS AND RECORDS
Correct Answer
C. A SET OF COLUMNS AND RECORDSExplanation
The correct answer is "A SET OF COLUMNS AND RECORDS." A table is a data structure used in databases to organize and store data. It consists of rows, which are also called records, and columns, which represent different attributes or fields of the data. Each column contains a specific type of data, and each row represents a single record or instance of the data. By organizing data into tables, it becomes easier to retrieve and manipulate specific information when needed.Rate this question:
-
- 3.
UNDO AND REDO APPEAR ON THE QUICK ACCESS TOOLBAR
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Undo and Redo are commonly used commands in software applications, especially in word processing and graphic design programs. These commands allow users to reverse or repeat their previous actions, providing a way to correct mistakes or make changes to their work. The Quick Access Toolbar is a customizable toolbar that typically appears at the top of the application window, providing quick access to commonly used commands. Since Undo and Redo are frequently used commands, it is common for them to appear on the Quick Access Toolbar for easy access and convenience. Therefore, the statement "Undo and Redo appear on the Quick Access Toolbar" is true.Rate this question:
-
- 4.
EXAMPLES OF A PAPER DATABASE ARE TELEpHONE AND ADDRESS BOOKS
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A paper database refers to a physical collection of information or records that are stored on paper. Telephone and address books are examples of paper databases because they contain contact information of individuals or businesses, which is recorded on paper. These books serve as a reference for finding phone numbers and addresses. Therefore, the statement "Examples of a paper database are telephone and address books" is true.Rate this question:
-
- 5.
THE ABILITY TO AUTOMATE TASKS AND ADD FUCTIONALITY TO A FORM, REPORT, OR CONTROL IS CALLED
- A.
QUERY
- B.
MACROS
- C.
MODULES
Correct Answer
B. MACROSExplanation
Macros are a set of instructions or commands that can be recorded and executed to automate repetitive tasks or add functionality to a form, report, or control. They allow users to perform complex actions with a single click or keystroke, saving time and effort. Macros can be used to automate data entry, generate reports, perform calculations, and much more. They are a powerful tool in enhancing the functionality and efficiency of various applications.Rate this question:
-
- 6.
IN ACCESS 2007, YOU USE THE _______________________ TO ISSUE COMMANDS
- A.
RIBBONS
- B.
TOOLBAR
- C.
COMMAND BUTTON
Correct Answer
A. RIBBONSExplanation
In Access 2007, the ribbons are used to issue commands. Ribbons are a user interface element that contain various tabs, each with different commands and options. They replaced the traditional toolbar and menu system in Access 2007 and provide a more organized and intuitive way to access commands and features. By clicking on the tabs and buttons on the ribbons, users can easily execute commands and perform various tasks in Access 2007.Rate this question:
-
- 7.
PLEASE SELECT THE CORRECT STATEMENT FROM BELOW
- A.
A DATASHEET DISPLAYS THE INFORMATION STORED IN A TABLE IN COLUMNS AND TABLES.
- B.
A FORM GIVES YOU THE ABILITY TO CHOOSE THE TABLE AND ARRANGEMENT OF FIELDS.
- C.
MODULES, LIKE MACROS GIVES YOU THE ABILITY TO ADD FUNCTIONALITY TO A REPORT.
Correct Answer
C. MODULES, LIKE MACROS GIVES YOU THE ABILITY TO ADD FUNCTIONALITY TO A REPORT.Explanation
Modules, like macros, give you the ability to add functionality to a report. This means that by using modules or macros, you can enhance the capabilities of a report by adding custom functions or automating certain tasks.Rate this question:
-
- 8.
What Is The Below Item
- A.
ACCESS TOOLBAR
- B.
DESIGN MENU
- C.
NAVIGATION PANE
Correct Answer
C. NAVIGATION PANEExplanation
The correct answer is "NAVIGATION PANE". The navigation pane is a feature in various software applications that provides a way to easily navigate through different sections or elements of the application. It typically displays a list or hierarchy of options or sections that the user can click on to navigate to a specific area or perform a specific action. In this context, the navigation pane is likely referring to a feature or element in a software application that allows the user to navigate through different menus or options.Rate this question:
-
- 9.
A DATABASE ALLOWS YOU TO STORE INFORMATION UNRELATED TO A SPECIFIC TOPIC IN A ORGANIZED WAY
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
A database is a collection of related data that is organized and structured in a way that allows for efficient storage, retrieval, and manipulation of information. It is designed to store information related to a specific topic or subject, not unrelated information. Therefore, the statement is false.Rate this question:
-
- 10.
OTHER SPREADSHEET SOFTWARE HAVE LIMITATIONS BECAUSE THEY
- A.
JUST DON'T WORK
- B.
USE THIN DATA
- C.
ARE A FLAT FILE
Correct Answer
C. ARE A FLAT FILEExplanation
Other spreadsheet software have limitations because they are a flat file. This means that they can only store and manipulate data in a two-dimensional format, with rows and columns. This limitation can make it difficult to organize and analyze complex data sets. In contrast, other types of software, such as databases, can store and manipulate data in a more flexible and structured manner, allowing for more advanced data analysis and organization.Rate this question:
-
- 11.
ACCESS IS CALLED A RESPONSIVE DATABASE MANAGEMENT SYSTEM
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement "Access is called a responsive database management system" is false. Access is a relational database management system (RDBMS) developed by Microsoft. While it does provide responsive features such as forms, reports, and queries, it is not specifically referred to as a "responsive" database management system.Rate this question:
-
- 12.
TO GET SPECIFIC RESULTS FROM A TABLE I MUST RUN A
- A.
RACE
- B.
QUESTION
- C.
QUERY
Correct Answer
C. QUERYExplanation
In order to obtain specific results from a table, one must run a query. A query is a request for information from a database that matches certain criteria. It allows the user to extract specific data from a table based on the conditions specified in the query. By running a query, one can filter and retrieve only the desired information, making it an essential tool for obtaining specific results from a table.Rate this question:
-
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 20, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 14, 2011Quiz Created by
PCDAC
Back to top