Understanding Access (And Additional MS Office Questions)

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Ppageegsd
P
Ppageegsd
Community Contributor
Quizzes Created: 14 | Total Attempts: 9,701
| Attempts: 183
SettingsSettings
Please wait...
  • 1/10 Questions

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

    • Fields
    • Records
    • Data points
    • Categories
Please wait...
About This Quiz


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.

Understanding Access (And Additional MS Office Questions) - Quiz

Quiz Preview

  • 2. 

    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:

  • 3. 

    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:

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

    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:

  • 6. 

    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:

  • 7. 

    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:

  • 8. 

    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:

  • 9. 

    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:

  • 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:

Quiz Review Timeline (Updated): Jan 29, 2025 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jan 29, 2025
    Quiz Edited by
    ProProfs Editorial Team
  • Jun 15, 2011
    Quiz Created by
    Ppageegsd
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.