ECDL Module 5 Tables 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 Lathe
L
Lathe
Community Contributor
Quizzes Created: 1 | Total Attempts: 10,401
| Attempts: 10,410
SettingsSettings
Please wait...
  • 1/11 Questions

    Which one of the following is not part of a database

    • A record
    • A chart
    • A field
    • A table
Please wait...
About This 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

ECDL Module 5 Tables Quiz - Quiz

Quiz Preview

  • 2. 

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

    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:

  • 3. 

    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.

    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:

  • 4. 

    What is the file extension for a Microsoft Access 2007 database

    • .ppt(x)

    • .doc(x)

    • .accdb(x)

    • .xls(x)

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

    Rate this question:

  • 5. 

    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:

  • 6. 

    A primary key allows a user to

    • Lock a table

    • Password a database

    • Assign each record a unique field

    • Create a query

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

  • 7. 

    A Database is...

    • A set of information related to another application

    • A table of records with no relevance

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

    • A collection of information about a particular subject

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

  • 8. 

    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:

  • 9. 

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

    • Allow up to 20 characters to be entered in a field

    • Allow up to 20 words to be entered in a field

    • Decrease the font size from 50 to 20

    • 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:

  • 10. 

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

    • Add records to a table

    • Add a Field Name

    • Select a data type

    • 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:

  • 11. 

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

    • You have assigned a Primary Key

    • You switch from data view to design view

    • You have not saved the table for 5 minutes

    • 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 (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
  • Feb 25, 2009
    Quiz Created by
    Lathe
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.