Understanding Access (And Additional MS Office Questions)

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Ppageegsd

Ppageegsd

Community Contributor

Quizzes Created: 14 | Total Attempts: 9,043

Questions: 10 | Attempts: 178 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

The objective portion of this test will assess your conceptual understanding of a relational database, and additional features and functions of other MS Office applications.

Questions and Answers

1.

Tables are set up to contain columns and rows of information. In a database table, the columns are called ____.
- A.
  
  Fields
- B.
  
  Records
- C.
  
  Data points
- D.
  
  Categories
Correct Answer
A. Fields

Explanation
In a database table, the columns are called fields. Fields represent the different categories or attributes of the data being stored in the table. They define the type of data that can be stored in each column and help organize and structure the information in the table.

Rate this question:
2.

A database and table are one in the same.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
The statement is false because a database and a table are not the same thing. A database is a collection of related data, while a table is a structure within the database that organizes and stores the data. A database can contain multiple tables, along with other objects such as queries, forms, and reports. Therefore, a database and a table are distinct entities within the context of database management systems.

Rate this question:
3.

In a database form, the blanks in which information is entered are called _________. When the blanks are filled in, the form represents a _______. (Note: There are two (2) correct answers, please select both in order for your answer to be scored correctly.)
- A.
  
  Fields
- B.
  
  Query
- C.
  
  Record
- D.
  
  Database
Correct Answer(s)
A. Fields
C. Record

Explanation
In a database form, the blanks in which information is entered are called fields. When the blanks are filled in, the form represents a record.

Rate this question:
4.

A macro in Access performs a function comparable to a conditional statement in Excel
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
A macro in Access does not perform a function comparable to a conditional statement in Excel. A macro in Access is a set of actions that are performed automatically in response to a specific event or trigger, such as opening a form or clicking a button. It is used to automate tasks and streamline processes in Access databases. On the other hand, a conditional statement in Excel is used to perform different actions based on a specified condition or set of conditions. They are used to control the flow of calculations and data in Excel spreadsheets. Therefore, the statement is false.

Rate this question:
5.

Examples of objects associated with a database include: ________________. Please check all the apply.
- A.
  
  Table
- B.
  
  Query
- C.
  
  Report
- D.
  
  Form
Correct Answer(s)
A. Table
B. Query
C. Report
D. Form

Explanation
The correct answer includes "table, query, report, form." These are all examples of objects that are commonly associated with a database. A table is used to store and organize data, a query is used to retrieve specific information from the database, a report is used to present data in a formatted manner, and a form is used to input or edit data in the database.

Rate this question:
6.

The unique identifier associated with each record is called a ______________
- A.
  
  Connector
- B.
  
  Primary key
- C.
  
  Conjoiner
- D.
  
  Id number
Correct Answer
B. Primary key

Explanation
A primary key is a unique identifier associated with each record in a database. It is used to uniquely identify each record and ensure its uniqueness and integrity. The primary key is a crucial component in database design as it allows for efficient data retrieval and manipulation. It is typically a column or a combination of columns that have unique values for each record in a table.

Rate this question:
7.

You want to create a new query that pulls fields from a table and an existing query within the same database. In order to pull data from these objects, you must first build a ________ between them. First, you should drag the table's _______ to the related field in the query. (Check the two(2) answers that best complete these sentences.)
- A.
  
  Connector
- B.
  
  Relationship
- C.
  
  Foreign link
- D.
  
  Primary key
Correct Answer(s)
B. Relationship
D. Primary key

Explanation
To pull data from both the table and the existing query, you need to establish a relationship between them. This can be done by dragging the table's primary key to the related field in the query. The primary key serves as a unique identifier in the table, allowing the query to reference and retrieve the corresponding data. This relationship ensures that the data from both objects can be accessed and combined effectively.

Rate this question:
8.

You decide to create a chart depicting your Excel data. You notice that "Chart Tools" now appear in the Title bar, and there are _________ tabs with functions that are available only when the chart is selected
- A.
  
  Easy access
- B.
  
  Graphic interface
- C.
  
  Contextual
- D.
  
  Extraneous
Correct Answer
C. Contextual

Explanation
When creating a chart in Excel, the "Chart Tools" appear in the Title bar, indicating that specific tools and options related to charts are now available. These tools are contextual, meaning they are only displayed and accessible when a chart is selected. This allows users to easily access and utilize functions specifically designed for chart editing and customization.

Rate this question:
9.

In PowerPoint 2007, it's important to remember that audio and video files are ________ .
- A.
  
  Imbedded not linked
- B.
  
  Linked not imbedded
- C.
  
  Imbedded and linked
Correct Answer
B. Linked not imbedded

Explanation
In PowerPoint 2007, audio and video files are linked, not embedded. This means that the files are not physically stored within the PowerPoint presentation, but rather, they are stored in a separate location on the computer or network. When the presentation is played, PowerPoint accesses the linked files to play the audio or video. This allows for smaller file sizes and easier management of the media files.

Rate this question:
10.

As a result of my active participation in this class, I can now ______________, ________________, and __________________. (Note: Your answer should reference three (3) specific features and functions of an application you learned or perhaps skills you developed or refined.)

Correct Answer
incorporate audio and video into presentations
use MS Word reference tab for in-text citations and bibliography

Explanation
The correct answer highlights the specific features and functions that the person has learned or developed through active participation in the class. They can now incorporate audio and video into presentations, which suggests they have learned how to add multimedia elements to their slides. Additionally, they can use the MS Word reference tab for in-text citations and bibliography, indicating they have gained knowledge on how to properly cite sources within their written work using the referencing tools in MS Word.

Rate this question:

4

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, 2023

Quiz Edited by
ProProfs Editorial Team
Jun 15, 2011

Quiz Created by
Ppageegsd

Understanding Access (And Additional MS Office Questions)

Tables are set up to contain columns and rows of information. In a database table, the columns are called ____.

A database and table are one in the same.

In a database form, the blanks in which information is entered are called ___. When the blanks are filled in, the form represents a _. (Note: There are two (2) correct answers, please select both in order for your answer to be scored correctly.)

A macro in Access performs a function comparable to a conditional statement in Excel

Examples of objects associated with a database include: ________________. Please check all the apply.

The unique identifier associated with each record is called a ______________

You decide to create a chart depicting your Excel data. You notice that "Chart Tools" now appear in the Title bar, and there are _________ tabs with functions that are available only when the chart is selected

In PowerPoint 2007, it's important to remember that audio and video files are ________ .

As a result of my active participation in this class, I can now , , and ____. (Note: Your answer should reference three (3) specific features and functions of an application you learned or perhaps skills you developed or refined.)

Understanding Access (And Additional MS Office Questions)

Tables are set up to contain columns and rows of information. In a database table, the columns are called ____.

A database and table are one in the same.

In a database form, the blanks in which information is entered are called _________. When the blanks are filled in, the form represents a _______. (Note: There are two (2) correct answers, please select both in order for your answer to be scored correctly.)

A macro in Access performs a function comparable to a conditional statement in Excel

Examples of objects associated with a database include: ________________. Please check all the apply.

The unique identifier associated with each record is called a ______________

You decide to create a chart depicting your Excel data. You notice that "Chart Tools" now appear in the Title bar, and there are _________ tabs with functions that are available only when the chart is selected

In PowerPoint 2007, it's important to remember that audio and video files are ________ .

As a result of my active participation in this class, I can now ______________, ________________, and __________________. (Note: Your answer should reference three (3) specific features and functions of an application you learned or perhaps skills you developed or refined.)

In a database form, the blanks in which information is entered are called ___. When the blanks are filled in, the form represents a _. (Note: There are two (2) correct answers, please select both in order for your answer to be scored correctly.)

As a result of my active participation in this class, I can now , , and ____. (Note: Your answer should reference three (3) specific features and functions of an application you learned or perhaps skills you developed or refined.)