1.
Table in Microsoft Access can be create by using all below except
Correct Answer
D. Input Mask
2.
Which data type can store more than 255 character?
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.
3.
You can use Input Mask and set the data as _______________ to make sure all data are valid to enter and not duplicate.
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.
4.
There are 3 type of Relationship that valid in Ms Access 2007, Except
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.
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
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.
6.
What type of queries is a queries that select records from tables based on criteria.
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.
7.
What Queries are used to summarise data in tables
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.
8.
Special form called Switchboard, can set up such that anybody can use your database even if they know nothing about Access
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.
9.
A macro holds a series of instructions (commands) such that all the instructions can be carried out simply by running the one macro.
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.
10.
You can __________ macros setting so that the macros run automatically for any database you open.
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.