MS Access 2007 - Basic (Pre Test)

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 15,457
Questions: 7 | Attempts: 1,091

SettingsSettingsSettings
MS Access 2007 - Basic (Pre Test) - Quiz

Answer all question either True, False or I Dont Know


Questions and Answers
  • 1. 

    Ms Access is a software to manage data to produce information  which is called Database Management System or DBMS.

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    A. True
    Explanation
    Ms Access is indeed a software that is used to manage data and produce information, making it a Database Management System (DBMS). It allows users to create and manipulate databases, perform queries, generate reports, and automate tasks. Therefore, the statement "Ms Access is a software to manage data to produce information which is called Database Management System or DBMS" is correct.

    Rate this question:

  • 2. 

    Table- The central framework of a database that stores data in fields (columns) and records (rows).

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    A. True
    Explanation
    The given statement is true. A table is indeed the central framework of a database that stores data in fields (columns) and records (rows). In a database, tables are used to organize and store data in a structured manner, allowing for efficient retrieval and manipulation of information. Each column in a table represents a specific attribute or field, while each row represents a record or instance of data. Therefore, the given answer is correct.

    Rate this question:

  • 3. 

    Query- Allows for table inquiries. A query can change, delete, add, arrange data in tables. Also aids gathering information for forms and reports.

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    A. True
    Explanation
    A query is a command or request for data from a database. It allows users to retrieve, manipulate, and analyze data stored in tables. Queries can be used to change, delete, add, or arrange data in tables. Additionally, queries are helpful in gathering information for forms and reports. Therefore, the given statement, "Allows for table inquiries. A query can change, delete, add, arrange data in tables. Also aids gathering information for forms and reports," is true.

    Rate this question:

  • 4. 

    There are three types of relationships in Microsoft Access: One-to-many Many-to-many One-to-one

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    A. True
    Explanation
    The statement "There are three types of relationships in Microsoft Access: One-to-many, Many-to-many, One-to-one" is true. In Microsoft Access, a one-to-many relationship is when one record in a table can have multiple related records in another table. A many-to-many relationship is when multiple records in one table can be related to multiple records in another table. A one-to-one relationship is when one record in a table is related to only one record in another table. These relationships are important for organizing and linking data in a database.

    Rate this question:

  • 5. 

    Primary keys uniquely identify each record in a table. An advantage of a primary key is that it does not allow duplication of information.

    • A.

      True

    • B.

      False

    • C.

      I DOnt Know

    Correct Answer
    A. True
    Explanation
    A primary key is a unique identifier for each record in a table. It ensures that each record is distinct and cannot be duplicated. This uniqueness helps in maintaining data integrity and avoiding data redundancy. Therefore, the statement that a primary key does not allow duplication of information is true.

    Rate this question:

  • 6. 

    A form is used to simply display and enter data in a fitted format

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    A. True
    Explanation
    A form is indeed used to display and enter data in a fitted format. Forms are commonly used in various applications and websites to collect information from users. They provide a structured layout with fields and labels, allowing users to easily input their data. The data entered into the form can then be processed or stored for further use. Therefore, the statement "A form is used to simply display and enter data in a fitted format" is correct.

    Rate this question:

  • 7. 

    It is important to assign appropriate data types to a field since they specify what type of data can be entered into a field.

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    A. True
    Explanation
    Assigning appropriate data types to a field is indeed important because it determines the type of data that can be entered into that field. By specifying the data type, it helps ensure data integrity and accuracy. For example, if a field is assigned a numerical data type, it will only accept numbers and not allow any other type of data to be entered. This helps maintain consistency and prevents errors in data entry and analysis. Therefore, the statement "It is important to assign appropriate data types to a field since they specify what type of data can be entered into a field" is true.

    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 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 22, 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.