Understanding Access (and additional MS Office questions)

2.

A database and table are one in the same.

True
False

Correct Answer

A. 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.)

Fields
Query
Record
Database

Correct Answer(s)

A. Fields
A. 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

True
False

Correct Answer

A. 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.

Table
Query
Report
Form

Correct Answer(s)

A. Table
A. Query
A. Report
A. 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 ______________

Connector
Primary key
Conjoiner
Id number

Correct Answer

A. 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.)

Connector
Relationship
Foreign link
Primary key

Correct Answer(s)

A. Relationship
A. 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

Easy access
Graphic interface
Contextual
Extraneous

Correct Answer

A. 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 ________ .

Imbedded not linked
Linked not imbedded
Imbedded and linked

Correct Answer

A. 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:

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 ____.

Quiz Preview

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 ____.

Quiz Preview

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.)