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,335
| Attempts: 558 | Questions: 10
Please wait...
Question 1 / 10
0 %
0/100
Score 0/100
1. 2 ways to identify inconsistencies between data in two or more tables are either modify the join line or use a special Query Wizard

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.

Submit
Please wait...
About This Quiz
MS Access 2007 - Intermediate (Post Test) - 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... see morelearners can handle Access databases effectively. see less

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

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.

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

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.

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

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.

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

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.

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

Explanation

not-available-via-ai

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

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.

Submit
8. What Queries are used to summarise data in tables

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.

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

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.

Submit
10. Which data type can store more than 255 character?

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.

Submit
View My Results

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
Cancel
  • All
    All (10)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
2 ways to identify inconsistencies between data in two or more tables...
A macro holds a series of instructions (commands) such that all the...
There are 3 type of Relationship that valid in Ms Access 2007, Except
Special form called Switchboard, can set up such that anybody can use...
You can __________ macros setting so that the macros run automatically...
Table in Microsoft Access can be create by using all below except
You can use Input Mask and set the data as _______________ to make...
What Queries are used to summarise data in tables
What type of queries is a queries that select records from tables...
Which data type can store more than 255 character?
Alert!

Advertisement