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)
- 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 ............
- 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.
- 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
Featured Quizzes
Popular Topics
- ACIS Quizzes
- CBAP Quizzes
- CCENT Quizzes
- CCT Quizzes
- CSQA Quizzes
- IBM Certification Quizzes
- LPI Quizzes
- MCSA Quizzes
- MCSE Quizzes
- MCTS Quizzes
- Microsoft Certification Quizzes
- MTA Quizzes
- Nocti Quizzes
- PEGA CSA Certified Quizzes
- RCDD Quizzes
- SAP Quizzes
- SAS Quizzes
- SOCRA Quizzes
Back to top