ECDL Module 5 Tables 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
- 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 spreadsheetRate 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 subjectExplanation
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
DesignExplanation
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
recordExplanation
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
fieldExplanation
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 chartExplanation
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 tableExplanation
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 fieldExplanation
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, decideExplanation
For example in a title field you could limit the entry to be Mr,Mrs,Miss,Ms or DrRate 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 fieldExplanation
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 KeyExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 25, 2009Quiz Created by
Lathe
Back to top