MS Access (Database Management System)

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 Johnwyne
J
Johnwyne
Community Contributor
Quizzes Created: 16 | Total Attempts: 6,288
Questions: 20 | Attempts: 306

SettingsSettingsSettings
Management Quizzes & Trivia

This online quiz is intended for the Merry Child School Students.


Questions and Answers
  • 1. 

    The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables.

    Explanation
    In the third stage of designing a database, we analyze our tables more closely and create a relationship between tables. This means that we establish a connection or association between different tables in the database. By creating relationships, we can define how the data in one table is related to the data in another table. This allows us to efficiently organize and retrieve information from the database, ensuring data integrity and avoiding redundancy.

    Rate this question:

  • 2. 

    In a database table, the category of information is called ____________.

    Explanation
    In a database table, the category of information is called a field. A field represents a specific piece of data that is stored in a table. It is used to define the type of data that can be stored in a particular column of the table. Each field typically has a name and a data type associated with it, which determines the kind of information that can be stored in that field. Fields are essential for organizing and categorizing data within a database table.

    Rate this question:

  • 3. 

    Computerized database is __________; since records stored in filing cabinets can be stored in  just a single  floppy disk.

    Explanation
    A computerized database is considered compact because it can store a large number of records in a very small space, such as a single floppy disk. This is in contrast to storing records in filing cabinets, which would require a significant amount of physical space. The compact nature of a computerized database allows for efficient storage and retrieval of information.

    Rate this question:

  • 4. 

    Data definition is the stage when one gathers and list all necessary ___________ for our database.

    Explanation
    In the data definition stage, one collects and lists all the necessary fields for the database. Fields are the individual pieces of information that will be stored in the database, such as name, age, address, etc. By identifying and defining the fields, we are determining the specific data that will be stored and organized in the database. This step is crucial in creating a well-structured and functional database.

    Rate this question:

  • 5. 

    In creating an effective database management system, careful _____________ is crucial.

    Explanation
    In creating an effective database management system, careful planning is crucial. Planning allows for the organization and structuring of the database, ensuring that it meets the needs and requirements of the users. It involves determining the goals and objectives of the system, identifying the data that needs to be stored, and designing the overall structure and layout. Without proper planning, the database may lack coherence, efficiency, and may not effectively serve its intended purpose. Therefore, planning is essential in creating an effective database management system.

    Rate this question:

  • 6. 

    This key uniquely identifies each record  in table.

    • A.

      Primary key

    • B.

      Key record

    • C.

      Unique key

    • D.

      Field name

    Correct Answer
    A. Primary key
    Explanation
    A primary key is a field or combination of fields in a database table that uniquely identifies each record in the table. It ensures that there are no duplicate records and allows for efficient retrieval and manipulation of data.

    Rate this question:

  • 7. 

    It is an association established between common  fields (columns) in two tables.

    • A.

      Line

    • B.

      Relationship

    • C.

      Primary key

    • D.

      Records

    Correct Answer
    B. Relationship
    Explanation
    A relationship is a connection or association between common fields (columns) in two tables. It allows for the linking of related data between the tables, enabling the retrieval and manipulation of information from multiple tables simultaneously. By establishing relationships, data can be efficiently organized and accessed, ensuring data integrity and reducing redundancy.

    Rate this question:

  • 8. 

    It is stage where we break down some fields to more specific fields so we can store information in the smallest logical parts.

    • A.

      Data definition

    • B.

      Data refinement

    • C.

      Establishing relationship

    • D.

      None of the above

    Correct Answer
    B. Data refinement
    Explanation
    Data refinement is the correct answer because it refers to the process of breaking down larger fields into smaller, more specific fields. This allows for the storage of information in the smallest logical parts, making it easier to manage and analyze the data. The other options, such as data definition and establishing relationships, do not directly relate to this process of breaking down fields.

    Rate this question:

  • 9. 

    This is the stage in database design where one gathers and list all the necessary fields for the database project.  

    • A.

      Data definition

    • B.

      Data refinement

    • C.

      Establishing relationship

    • D.

      None of the above

    Correct Answer
    A. Data definition
    Explanation
    The stage in database design where one gathers and lists all the necessary fields for the database project is called data definition. This involves identifying and specifying the data elements or attributes that need to be stored in the database. Data refinement refers to the process of improving the quality and structure of the data. Establishing relationships involves defining the connections or associations between different data entities in the database. None of the above options accurately describe the stage of gathering and listing necessary fields.

    Rate this question:

  • 10. 

    A column in a table is called a _________________.

    • A.

      Record

    • B.

      Column

    • C.

      Field

    • D.

      Horizontal

    Correct Answer
    C. Field
    Explanation
    A column in a table is called a field. In a database, a field represents a specific piece of information within a record. Each field is assigned a specific data type, such as text, number, or date, and holds a value that corresponds to the type. Fields are used to organize and categorize data within a table, allowing for efficient storage and retrieval of information.

    Rate this question:

  • 11. 

    It refers to row in a database table.

    • A.

      Record

    • B.

      Column

    • C.

      Vertical

    • D.

      Horizontal

    Correct Answer
    A. Record
    Explanation
    A record refers to a row in a database table. In a database, information is organized into tables, and each table consists of rows and columns. Each row represents a record, which contains a set of related data. Therefore, the correct answer is "record" because it accurately describes a row in a database table.

    Rate this question:

  • 12. 

    It is a type of database where one or more tables are connected to other tables in the database, such as in the library system .

    • A.

      Relational database

    • B.

      List database

    • C.

      Flat-file database

    • D.

      None of the above

    Correct Answer
    A. Relational database
    Explanation
    A relational database is a type of database that uses tables to store and organize data. In this type of database, tables are connected to each other through relationships, such as in the library system where tables for books, authors, and borrowers may be connected. This allows for efficient storage and retrieval of data, as well as the ability to perform complex queries and analysis on the data.

    Rate this question:

  • 13. 

    What do you call the database that works with one set of database records at a time, such as the list of products in a Microsoft Excel file?

    • A.

      Relational database

    • B.

      List database

    • C.

      Flat file database

    • D.

      None of the above

    Correct Answer
    C. Flat file database
    Explanation
    A flat file database is the correct answer because it is a type of database that works with one set of database records at a time, such as the list of products in a Microsoft Excel file. Unlike a relational database, which allows for relationships between multiple sets of data, a flat file database is a simple, single-file database that stores all information in a single table. It is commonly used for small-scale applications or when the data does not need to be linked or manipulated in complex ways.

    Rate this question:

  • 14. 

    It stands for POS in a checkout counter.

    • A.

      Point-of-System

    • B.

      Proof-of-Sales

    • C.

      Point-of-Sales

    • D.

      None of the above

    Correct Answer
    B. Proof-of-Sales
  • 15. 

    It is a collection of data that is related to a particular subject or purpose.

    • A.

      Database

    • B.

      List

    • C.

      Table

    • D.

      Group

    Correct Answer
    A. Database
    Explanation
    A database is a collection of data that is organized and stored in a structured manner, allowing for efficient retrieval, manipulation, and management. It is designed to hold information related to a specific subject or purpose, such as customer records, inventory data, or financial transactions. A database provides a centralized and coherent storage solution, enabling users to easily access and analyze the data it contains.

    Rate this question:

  • 16. 

    It is used to copy a text.

    Correct Answer
    Ctrl + C
    ctrl+c
    Ctrl+C
    Explanation
    The correct answer is Ctrl + C, ctrl+c, Ctrl+C. This keyboard shortcut is commonly used to copy a selected text or object. By pressing Ctrl + C, the selected content is copied to the clipboard, allowing the user to paste it elsewhere using the Ctrl + V shortcut. The variations in capitalization (Ctrl + C, ctrl+c, Ctrl+C) indicate that the answer is case-insensitive, meaning it can be typed in any combination of uppercase and lowercase letters.

    Rate this question:

  • 17. 

    It is used to undo text.

    Correct Answer
    Ctrl + Z
    ctrl+z
    Explanation
    Pressing Ctrl + Z or ctrl+z is a keyboard shortcut commonly used to undo an action in various software applications. This action allows the user to revert changes made to text, such as deleting or modifying it. The Ctrl key, when pressed along with the Z key, triggers the undo function, enabling the user to reverse their previous action and restore the text to its previous state. This shortcut is widely known and used across different platforms and applications, making it a convenient and efficient way to undo text edits.

    Rate this question:

  • 18. 

    It is used to create new file.

    Correct Answer
    Ctrl + N
    Ctrl+N
    Explanation
    Pressing Ctrl + N or Ctrl+N is a keyboard shortcut that is commonly used to create a new file. This shortcut is often supported by various software applications, including text editors, word processors, and graphic design programs. By pressing this combination of keys, users can quickly and easily create a new blank file without having to navigate through menus or use a mouse. This shortcut saves time and increases productivity by providing a convenient way to start a new project or document.

    Rate this question:

  • 19. 

    It is used to close single file.

    Correct Answer
    Ctrl + W
    Explanation
    Ctrl + W is a keyboard shortcut commonly used in computer applications to close a single file or document. By pressing Ctrl + W, the user can quickly close the active window or tab without having to navigate through menus or use the mouse. This shortcut is particularly useful when working with multiple documents or files simultaneously, allowing for efficient organization and management of open windows.

    Rate this question:

  • 20. 

    It is used to close a program application.

    Correct Answer
    Alt + F4
    Explanation
    Alt + F4 is a keyboard shortcut commonly used to close a program application in Windows operating systems. When this key combination is pressed, it sends a signal to the active window requesting it to close. This shortcut is convenient as it allows users to quickly exit applications without having to navigate through menus or click on the close button. It is a widely known and frequently used shortcut for closing programs, making it an efficient way to end tasks and free up system resources.

    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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 10, 2010
    Quiz Created by
    Johnwyne
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.