MS Access 2007 - Intermediate (Post Test)

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 Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 15,293
Questions: 10 | Attempts: 545

SettingsSettingsSettings
MS Access 2007 - Intermediate (Post Test) - Quiz

.


Questions and Answers
  • 1. 

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

    • A.

      Design View

    • B.

      Datasheet View

    • C.

      Table Wizard

    • D.

      Input Mask

    Correct Answer
    D. Input Mask
  • 2. 

    Which data type can store more than 255 character?

    • A.

      Memo

    • B.

      Text

    • C.

      Long Integer

    • D.

      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:

  • 3. 

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

    • A.

      Primary Key

    • B.

      Query

    • C.

      Macro

    • D.

      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:

  • 4. 

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

    • A.

      One to one

    • B.

      One to Many

    • C.

      Many to Many

    • D.

      Interdeminate

    Correct Answer
    D. 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:

  • 5. 

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

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The statement is true because modifying the join line or using a special Query Wizard are indeed two ways to identify inconsistencies between data in two or more tables. Modifying the join line allows for adjusting the criteria used to match records between tables, which can help identify inconsistencies. Additionally, using a special Query Wizard provides a guided tool that can assist in comparing and identifying inconsistencies between tables.

    Rate this question:

  • 6. 

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

    • A.

      Action Queries

    • B.

      Select Queries

    • C.

      CrossTab Queries

    • D.

      Cascade Queries

    Correct Answer
    B. 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:

  • 7. 

    What Queries are used to summarise data in tables

    • A.

      CrossTab

    • B.

      Action

    • C.

      Select

    • D.

      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:

  • 8. 

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

    • A.

      True

    • B.

      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:

  • 9. 

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

    • A.

      True

    • B.

      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:

  • 10. 

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

    • A.

      Disable

    • B.

      Enable

    • C.

      Ignoring

    • D.

      Cancelling

    Correct Answer
    B. 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:

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.