MS Access 2007 - Intermediate (Post Test)
-
Table in Microsoft Access can be create by using all below except
-
Design View
-
Datasheet View
-
Table Wizard
-
Input Mask
-
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.
Quiz Preview
- 2.
Which data type can store more than 255 character?
-
Memo
-
Text
-
Long Integer
-
Lookup Wizard
Correct Answer
A. MemoExplanation
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.
-
Primary Key
-
Query
-
Macro
-
Lookup Wizard
Correct Answer
A. Primary KeyExplanation
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
-
One to one
-
One to Many
-
Many to Many
-
Interdeminate
Correct Answer
A. InterdeminateExplanation
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
-
True
-
False
Correct Answer
A. TrueExplanation
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.
-
Action Queries
-
Select Queries
-
CrossTab Queries
-
Cascade Queries
Correct Answer
A. Select QueriesExplanation
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
-
CrossTab
-
Action
-
Select
-
Cascade
Correct Answer
A. CrossTabExplanation
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
-
True
-
False
Correct Answer
A. TrueExplanation
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.
-
True
-
False
Correct Answer
A. TrueExplanation
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.
-
Disable
-
Enable
-
Ignoring
-
Cancelling
Correct Answer
A. EnableExplanation
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:
-
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, 2023Quiz Edited by
ProProfs Editorial Team -
May 14, 2012Quiz Created by
Naldsauza
Back to top