ECDL Module 5 Tables Quiz

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 Lathe
L
Lathe
Community Contributor
Quizzes Created: 1 | Total Attempts: 10,348
Questions: 11 | Attempts: 10,348

SettingsSettingsSettings
ECDL Module 5 Tables Quiz - Quiz

Take this quiz to check your understanding of tables within databases. A member of each team will be nominated to answer. If they get it right on their own then the team gets 2 points. If the person nominated confers with their team and get it right they get 1 point. If anyone other than the nominated person shouts out the answer they will lose a team point. Good Luck


Questions and Answers
  • 1. 

    What is the file extension for a Microsoft Access 2007 database

    • A.

      .ppt(x)

    • B.

      .doc(x)

    • C.

      .accdb(x)

    • D.

      .xls(x)

    Correct Answer
    C. .accdb(x)
    Explanation
    ppt(X) is Powerpoint
    doc(x) is Word
    accdb is Access database 2007
    xls(x) is Excel spreadsheet

    Rate this question:

  • 2. 

    A Database is...

    • A.

      A set of information related to another application

    • B.

      A table of records with no relevance

    • C.

      A set of information ( names, addresses) with no structure

    • D.

      A collection of information about a particular subject

    Correct Answer
    D. A collection of information about a particular subject
    Explanation
    Drawing on your own experience and knowledge can you identify any instances where databases are used?

    Rate this question:

  • 3. 

    Tables have two views. They are Datasheet view and  ................     view.

    Correct Answer
    Design
    Explanation
    Tables have two views: Datasheet view and Design view. In Datasheet view, the table is displayed as a grid with rows and columns, allowing users to enter and view data. Design view, on the other hand, provides a more detailed and structured view of the table's design. It allows users to define the table's structure, set field properties, and specify relationships with other tables. In Design view, users can add, modify, or delete fields, set primary keys, and define data types and validation rules.

    Rate this question:

  • 4. 

    A ........... is a collection of information that stores all of the data about one person or one thing. For instance a ........... in student table would contain all of the data about one student i.e. their name, address, home phone number, d.o.b. medical history. Each student would have a ............

    Correct Answer
    record
    Explanation
    Within each table there are records. A record is a collection of information that stores all of the data about one person or one thing. For instance a record in student table would contain all of the data about one student i.e. their name, address, home phone number, d.o.b. medical history. Each student would have a record.

    Rate this question:

  • 5. 

    Each item within a record is called a ...... In the example of a student table, a......... would be first name or surname or student number.

    Correct Answer
    field
    Explanation
    Each item within a record is called a field.

    Fields are the individual items that make up a record within your database. In the example of a student table, a field would be first name or surname or student number.

    Rate this question:

  • 6. 

    Which one of the following is not part of a database

    • A.

      A record

    • B.

      A chart

    • C.

      A field

    • D.

      A table

    Correct Answer
    B. A chart
    Explanation
    A chart is not part of a database because a chart is a visual representation of data, typically used for analysis or presentation purposes. In a database, data is organized and stored in tables, which consist of records (rows) and fields (columns). A chart is a separate entity that can be created using the data from a database, but it is not an inherent component of the database structure itself.

    Rate this question:

  • 7. 

    Which of the following is not true. In design view you can...

    • A.

      Add records to a table

    • B.

      Add a Field Name

    • C.

      Select a data type

    • D.

      Increase the field size

    Correct Answer
    A. Add records to a table
    Explanation
    Design view is for entering and formatting fields.
    Datasheet view is for entering and editing records.

    Rate this question:

  • 8. 

    A primary key allows a user to

    • A.

      Lock a table

    • B.

      Password a database

    • C.

      Assign each record a unique field

    • D.

      Create a query

    Correct Answer
    C. Assign each record a unique field
    Explanation
    A primary key is a reference that uniquely identifies each record such as a membership number or a student number.

    Rate this question:

  • 9. 

    Validation rules can be applied to fields. They ................. what users can enter in a table field.

    Correct Answer
    limit, control, format, decide
    Explanation
    For example in a title field you could limit the entry to be Mr,Mrs,Miss,Ms or Dr

    Rate this question:

  • 10. 

    Changing the number of characters in a field from 50 to 20 will..

    • A.

      Allow up to 20 characters to be entered in a field

    • B.

      Allow up to 20 words to be entered in a field

    • C.

      Decrease the font size from 50 to 20

    • D.

      Only allow numbers up to 20 to be entered in the field

    Correct Answer
    A. Allow up to 20 characters to be entered in a field
    Explanation
    Be aware that if you do not set the field length to an appropriate size when you set the table up and then try to reduce the field length at a later date, you may lose some of the data you have entered. i.e. if you have entered an address that has 30 characters and then change the field size to 20, you would lose the last 10 characters in the address. It is better to get the text field sizes set up correctly right at the start.

    Rate this question:

  • 11. 

    When changing table view Microsoft Access will automatically ask you if you want to save the table if...

    • A.

      You have assigned a Primary Key

    • B.

      You switch from data view to design view

    • C.

      You have not saved the table for 5 minutes

    • D.

      You switch from design view to dataview

    Correct Answer
    A. You have assigned a Primary Key
    Explanation
    Every time you switch the table view if you have made any changes then you will be asked if you wish to save the table. If you have not made any changes then you will not be prompted to save the table.

    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
  • Feb 25, 2009
    Quiz Created by
    Lathe

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.