MS Access 2007: Tools And Functions! Quiz

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,239
| Attempts: 900
SettingsSettings
Please wait...
  • 1/10 Questions
    What means of this icon? - ProProfs

    What means of this icon?

    • To run from Access
    • To Run/Test Query
    • To Run Form
    • To Run Input Mask
Please wait...
About This 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!

MS Access 2007: Tools And Functions! Quiz - Quiz

Quiz Preview

  • 2. 

    What relationship most suitable for the table that includes secret and privacy data?

    • One to one

    • One to many

    • Many to many

    • Many to one

    Correct Answer
    A. One to one
    Explanation
    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:

  • 3. 

    To control from entering data twice/duplicate, we can use _____________

    • Primary Key

    • Lookup Wizard

    • Input Mask

    • Relationship

    Correct Answer
    A. Primary Key
    Explanation
    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:

  • 4. 

    What is the purpose of the Edit List button on the Input Mask dialog box?

    • To create lookup wizard

    • To create OLE Object

    • To create new/edit input mask

    • To create warning

    Correct Answer
    A. To create new/edit input mask
    Explanation
    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:

  • 5. 

    Using the aggregate function _______ is useful when a simple count or tally of information is required.

    • Count

    • Sum

    • Min

    • Max

    Correct Answer
    A. Count
    Explanation
    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:

  • 6. 

    What will Queries do?

    • Add, delete, update data

    • Create relationship

    • Edit Form interface

    • Close Program

    Correct Answer
    A. Add, delete, update data
    Explanation
    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:

  • 7. 

    There are two types of wildcards in Access which are

    • ! and &

    • ! and *

    • * and ?

    • & and ?

    Correct Answer
    A. * 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. 

    Which one is not valid as a data type in MS Access 2007?

    • Text

    • Lookup Wizard

    • Attachment

    • XML Object

    Correct Answer
    A. XML Object
    Explanation
    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:

  • 9. 

    What is True about data validation?

    • Data Validation will create a relationship

    • 1 to Many is example of Data Validation

    • Suitable for number and date data type

    • There is no Data Validation in Access

    Correct Answer
    A. Suitable for number and date data type
    Explanation
    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:

  • 10. 

    Which one is false about import/export data from or to MS Access 2007?

    • Import Table from Excel into Access

    • Export Table from Access into excel

    • Import Form from Excel into Access

    • Import Data from Access into Access

    Correct Answer
    A. Import Form from Excel into Access
    Explanation
    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:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 23, 2012
    Quiz Created by
    Naldsauza
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.