MS Access 2007: Tools And Functions! Quiz
Are you looking for an MS Access 2007: Tools and Functions Test to help you know just how much you understood about using this Application? You are in luck, as the quiz below is perfectly designed to help you do just that. Microsoft Access is a very good tool you can use when it comes to creating database templates. Give it a shot!
- 1.
What relationship most suitable for the table that includes secret and privacy data?
- A.
One to one
- B.
One to many
- C.
Many to many
- D.
Many to one
Correct Answer
A. One to oneExplanation
A one-to-one relationship is the most suitable for a table that includes secret and privacy data because it ensures that each record in one table corresponds to only one record in the other table. This means that each secret or privacy data can be uniquely linked to a specific record, maintaining confidentiality and preventing unauthorized access or sharing of sensitive information.Rate this question:
-
- 2.
Which one is not valid as a data type in MS Access 2007?
- A.
Text
- B.
Lookup Wizard
- C.
Attachment
- D.
XML Object
Correct Answer
D. XML ObjectExplanation
In MS Access 2007, the XML Object is not a valid data type. MS Access supports various data types such as Text, Number, Date/Time, Yes/No, etc., but XML Object is not one of them. XML Object refers to an object that stores XML data, and it is not a standalone data type in MS Access. Therefore, XML Object is not a valid data type in MS Access 2007.Rate this question:
-
- 3.
What is the purpose of the Edit List button on the Input Mask dialog box?
- A.
To create lookup wizard
- B.
To create OLE Object
- C.
To create new/edit input mask
- D.
To create warning
Correct Answer
C. To create new/edit input maskExplanation
The purpose of the Edit List button on the Input Mask dialog box is to create or edit an input mask. An input mask is a feature that allows you to specify a specific format for data entry in a field, such as phone numbers or social security numbers. By clicking the Edit List button, you can customize the input mask to fit your specific needs and requirements.Rate this question:
-
- 4.
To control from entering data twice/duplicate, we can use _____________
- A.
Primary Key
- B.
Lookup Wizard
- C.
Input Mask
- D.
Relationship
Correct Answer
A. Primary KeyExplanation
A primary key is a unique identifier for each record in a database table. By defining a primary key, we ensure that no two records can have the same value for the primary key field. This prevents duplicate data from being entered into the table. Therefore, using a primary key can effectively control and prevent the entry of data twice or duplicates.Rate this question:
-
- 5.
Which one is false about import/export data from or to MS Access 2007?
- A.
Import Table from Excel into Access
- B.
Export Table from Access into excel
- C.
Import Form from Excel into Access
- D.
Import Data from Access into Access
Correct Answer
C. Import Form from Excel into AccessExplanation
Importing a form from Excel into Access is not a feature available in MS Access 2007. Importing a table from Excel into Access allows users to transfer data from an Excel spreadsheet into an Access table. Similarly, exporting a table from Access into Excel enables the transfer of data from an Access table to an Excel spreadsheet. Importing data from Access into Access is also possible, allowing users to transfer data between different Access databases. However, importing a form from Excel into Access is not a valid option.Rate this question:
-
- 6.
What means of this icon?
- A.
To run from Access
- B.
To Run/Test Query
- C.
To Run Form
- D.
To Run Input Mask
Correct Answer
B. To Run/Test QueryExplanation
This icon represents the action of running or testing a query. It is commonly used in database management systems to execute a query and retrieve the results. By clicking on this icon, users can test the functionality and accuracy of their queries before implementing them in the system.Rate this question:
-
- 7.
There are two types of wildcards in Access which are
- A.
! and &
- B.
! and *
- C.
* and ?
- D.
& and ?
Correct Answer
C. * and ?Explanation
The correct answer is * and ?. In Access, the * wildcard represents any number of characters, while the ? wildcard represents a single character. These wildcards are commonly used in queries or searches to match patterns or retrieve data that meets certain criteria. For example, if you want to find all names starting with "J" and ending with "n", you can use the pattern "J*n" where * represents any number of characters and ? represents a single character.Rate this question:
-
- 8.
Using the aggregate function _______ is useful when a simple count or tally of information is required.
- A.
Count
- B.
Sum
- C.
Min
- D.
Max
Correct Answer
A. CountExplanation
The aggregate function "Count" is useful when a simple count or tally of information is required. It allows us to calculate the number of values in a specific column or field, disregarding any null values. This function is commonly used to determine the total number of records or occurrences in a dataset, providing a basic numerical summary of the data.Rate this question:
-
- 9.
What will Queries do?
- A.
Add, delete, update data
- B.
Create relationship
- C.
Edit Form interface
- D.
Close Program
Correct Answer
A. Add, delete, update dataExplanation
Queries are used in databases to perform operations on data. The given correct answer states that queries will "Add, delete, update data". This means that queries can be used to add new data to a database, delete existing data from the database, and update the existing data in the database. Queries are an essential part of managing and manipulating data in a database system.Rate this question:
-
- 10.
What is True about data validation?
- A.
Data Validation will create a relationship
- B.
1 to Many is example of Data Validation
- C.
Suitable for number and date data type
- D.
There is no Data Validation in Access
Correct Answer
C. Suitable for number and date data typeExplanation
Data validation is a process used to ensure that data entered into a system is accurate, complete, and within specified parameters. It helps to maintain data integrity and reliability. The statement "Suitable for number and date data type" is true because data validation is commonly used to validate and restrict input for number and date data types. It allows for setting specific rules and conditions for these data types, such as range limits, format requirements, or specific values. This helps to ensure that only valid and appropriate data is entered into the system.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 23, 2012Quiz Created by
Naldsauza
Back to top