MS Access 2007 - Intermediate (Post Test)

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 Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 16,239
| Attempts: 558
SettingsSettings
Please wait...
  • 1/10 Questions

    2 ways to identify inconsistencies between data in two or more tables are either modify the join line or use a special Query Wizard

    • True
    • False
Please wait...
About This Quiz

This intermediate-level post-test for MS Access 2007 assesses skills in database management. It covers topics such as table creation, data types, input masks, query types, and relationships, ensuring learners can handle Access databases effectively.

MS Access 2007 - Intermediate (Post Test) - Quiz

Quiz Preview

  • 2. 

    A macro holds a series of instructions (commands) such that all the instructions can be carried out simply by running the one macro.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A macro is a set of instructions or commands that can be executed together by running the macro itself. This means that instead of manually carrying out each individual instruction, the macro allows for the automation of multiple instructions with just one command. Therefore, the given statement that a macro holds a series of instructions that can be carried out simply by running the one macro is true.

    Rate this question:

  • 3. 

    There are 3 type of Relationship that valid in Ms Access 2007, Except

    • One to one

    • One to Many

    • Many to Many

    • Interdeminate

    Correct Answer
    A. Interdeminate
    Explanation
    The given answer "Interdeminate" is the correct answer because it is not a valid type of relationship in MS Access 2007. The three valid types of relationships in MS Access 2007 are one-to-one, one-to-many, and many-to-many. "Interdeminate" is not a recognized type of relationship in the context of MS Access 2007.

    Rate this question:

  • 4. 

    Special form called Switchboard, can set up such that anybody can use your database even if they know nothing about Access

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because a special form called Switchboard can be set up in Access to allow anyone to use the database without any knowledge of Access. This form acts as a user-friendly interface that provides easy-to-understand options and buttons for navigating and interacting with the database. By utilizing the Switchboard, individuals who are not familiar with Access can still access and utilize the database effectively.

    Rate this question:

  • 5. 

    You can __________ macros setting so that the macros run automatically for any database you open.

    • Disable

    • Enable

    • Ignoring

    • Cancelling

    Correct Answer
    A. Enable
    Explanation
    To ensure that macros run automatically for any database you open, you need to enable the macros setting. By enabling this setting, the system will allow macros to execute without any manual intervention. This means that whenever a database is opened, the macros will be triggered and run automatically, providing the desired functionality or automation.

    Rate this question:

  • 6. 

    Table in Microsoft Access can be create by using all below except

    • Design View

    • Datasheet View

    • Table Wizard

    • Input Mask

    Correct Answer
    A. Input Mask
  • 7. 

    You can use Input Mask and set the data as _______________ to make sure all data are valid to enter and not duplicate.

    • Primary Key

    • Query

    • Macro

    • Lookup Wizard

    Correct Answer
    A. Primary Key
    Explanation
    To ensure that all data entered is valid and not duplicated, you can use the Primary Key. A Primary Key is a unique identifier for each record in a database table. It ensures that no two records have the same value for the Primary Key field. By setting the data as the Primary Key, you can enforce data integrity and prevent duplicate entries in the table.

    Rate this question:

  • 8. 

    What Queries are used to summarise data in tables

    • CrossTab

    • Action

    • Select

    • Cascade

    Correct Answer
    A. CrossTab
    Explanation
    CrossTab queries are used to summarize data in tables. They allow users to create a summary report that displays the intersection of two or more fields in a table. This type of query is commonly used in data analysis and reporting to provide a concise summary of information. By using CrossTab queries, users can easily aggregate and analyze data from multiple perspectives, making it a valuable tool in summarizing and presenting data in a meaningful way.

    Rate this question:

  • 9. 

    What type of queries is a queries that select records from tables based on criteria.

    • Action Queries

    • Select Queries

    • CrossTab Queries

    • Cascade Queries

    Correct Answer
    A. Select Queries
    Explanation
    Select queries are a type of queries that select records from tables based on criteria. These queries are used to retrieve specific data from a database by specifying conditions or criteria that the records must meet. Select queries allow users to extract information from one or more tables and display the desired results. They are commonly used in database management systems to retrieve data for reporting, analysis, or any other purpose where specific data needs to be extracted based on certain conditions.

    Rate this question:

  • 10. 

    Which data type can store more than 255 character?

    • Memo

    • Text

    • Long Integer

    • Lookup Wizard

    Correct Answer
    A. Memo
    Explanation
    The correct answer is Memo. A Memo data type in a database can store more than 255 characters. Memo fields are typically used to store large amounts of text or notes, and they have a much higher character limit compared to other data types like Text or Long Integer.

    Rate this question:

Quiz Review Timeline (Updated): Mar 16, 2023 +

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

  • Current Version
  • Mar 16, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 14, 2012
    Quiz Created by
    Naldsauza
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.