ECDL Module 5 Tables Quiz

11 Questions | By Lathe | Last updated: Apr 29, 2016 | Total Attempts: 8583

Questions

Settings

or Create Online Exam

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)
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
3.

Tables have two views. They are Datasheet view and ................ view.
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 ............

Discuss
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.

Discuss
6.

Which one of the following is not part of a database
- A.
  
  A record
- B.
  
  A chart
- C.
  
  A field
- D.
  
  A table
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
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
9.

Validation rules can be applied to fields. They ................. what users can enter in a table field.
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
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