wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database Recap

Total questions: 65

Worksheet time: 1hrs 3mins

Name
Class
Date
1.
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
a)
Query
b)
Report
c)
Database 
d)
Spreadsheet
2.
A Primary Key is a code that uniquely identifies a _____________ in a Database.
a)
Record 
b)
Field 
c)
Text 
d)
Number
3.
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
a)
Cell
b)
Field
c)
Column
d)
Record
4.

In a database table, rows are called __________

a)

Fields

b)

Records

c)

Primary Keys

d)

Foreign Keys

5.

Forms, queries, and reports are created based on the data in the _________

a)

Forms

b)

Tables

c)

Reports

d)

Spreadsheets

6.
To sort from the smallest to the largest (from A to Z and 0 to 9)
a)
Ascending
b)
Descending
c)
Auto Sort
d)
Advanced Sort/Filter
7.

Each item of information within a record.

a)

form

b)

field

c)

record

d)

report

8.

View that shows the “background” or working of a table

a)

design view

b)

datasheet view

c)

form view

d)

layout view

9.

View that is similar to a spreadsheet, place to enter data

a)

form

b)

datasheet

c)

design

d)

detail

10.

What is a suitable data type for usage?

a)

Text

b)

Number

c)

Currency

d)

Yes/No

11.

Which data type would be most suitable for the 'Age' field?

a)

Currency

b)

Date & Time

c)

Number

d)

Memo

12.

The command for "not equal to" is...

a)

<>

b)

<=

c)

>=

d)

><

13.

Which software do you use to make database?

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft Publisher

d)

Microsoft Access

14.
Jennifer needs to create a presentation that summarizes the data in her database. Which of the following does she need to create?
a)
Query
b)
Report
c)
Field
d)
Record
15.

Where in the report is the calculated control added?

a)

Header

b)

Footer

c)

In the body of the report

d)

On the right

16.

What is included in a control?

a)

A label

b)

A text box

c)

Both of these

17.

How do you import or export data using Microsoft Access?

a)

Datasheet tab

b)

External Data tab

c)

Database Tools tab

d)

Create tab

18.
A text file where each record appears on a separate line and the fields are separated by a single character.
a)
Fixed-Width File
b)
Specification
c)
Delimited file
d)
Front-End File
19.
Which tab contains the import and export commands?
a)
File 
b)
Home
c)
External Data
d)
Database Tools 
20.
What is the process of transferring data from an Microsoft Access database for use in another application called?
a)
Exporting 
b)
Importing 
c)
Pasting 
d)
Distributing 
21.
I control data entry. I am also used for data entry.
a)
table
b)
query
c)
form
d)
report
22.
I can perform an advanced search. I am very similar to asking a detailed question. 
a)
report
b)
query
c)
table
d)
form
23.
I store data in rows and columns. I am considered the basic building block of a relational database. I am used to organize information within a database.
a)
form
b)
table
c)
query
d)
report
24.
Which is the best example of a primary key?
a)
Driver's License Number
b)
Home Runs Hit
c)
Price
d)
First and Last Name
25.
Data _____ helps ensure that an incorrect entry isn't made.
a)
validation
b)
checks
c)
accuracy
d)
integrity
26.

What three are data types?

a)

Text

b)

Number

c)

Boolean

d)

Shape

27.

To Enter Data in a Database showing only ONE record at a time, what must you create ?

a)

A Record

b)

A Report

c)

A Form

d)

A Query

28.

A Primary Key is a code that uniquely identifies a _____________ in a Database.

a)

Record

b)

Field

c)

Number

d)

Text

29.

Who might use a database?

a)

School

b)

Police

c)

Employer

d)

All of the above

30.

What is a unique identifying field called?

a)

Field

b)

Primary Key

c)

Record

d)

Query

31.

Short text, date, long text and number are all examples of what?

a)

Data types

b)

Headings

c)

Fields

d)

Records

32.

A query is used to

a)

Sort the database in alphabetical order

b)

Search the database

c)

Delete records

d)

Create a form

33.

If we are running a query and looking for all records with a date before 1999, we type what into the criteria?

a)

>1999

b)

>01/01/1999

c)

<01/01/1999

d)

<1999

34.

DBMS stands for-

a)

Data basic maintenance system

b)

Data base maintenance system

c)

Data base management system

d)

Data base managed system

35.

Ms-Access is a ___________ database

a)

Flat File

b)

Relational

c)

Object Oriented

d)

Flat

36.

What you understand by data redundancy?

a)

Assurance of the accuracy of data

b)

Duplicate values in database

c)

Security of Data

d)

None of these

37.

What you understand by data redundancy?

a)

Assurance of the accuracy of data

b)

Duplicate values in database

c)

Security of Data

d)

None of these

38.

Which view of table is used to insert a field name in table.

a)

Date sheet

b)

Design

c)

Database

d)

all of the above

39.

The best data type to choose for date of birth would be

a)

Number

b)

Date/Time

c)

Text

d)

Currency

40.
In a database, a "form" allows you to...
a)
create a query
b)
enter data and edit it in a simple form that consists of the fields from a table
41.
The swim coach is looking for swim team purchase orders  that are greater than $200. What criteria would give her this info?
a)
>200 OR swimming
b)
>=200 OR swimming
c)
>200 AND swimming
42.

A Primary Key is a code that uniquely identifies a _____________ in a Database.

a)

Record

b)

Field

c)

Text

d)

Number

43.

Where do you configure the field properties of a Table?

a)

Design View

b)

Datasheet View

c)

Access View

44.

Access can import a table of data from Excel.

a)

True

b)

False

45.
The ___________field is exactly like number fields, but formatted to display decimal places and a currency symbol.
a)
text
b)
currency
c)
name
46.
_________ are used to select information meeting specified conditions.
a)
Text
b)
Numbers
c)
Queries
47.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
48.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
49.
What is letter "A" showing?
a)
Where to configure the Join properties
b)
Where to Run the query
c)
Where to configure which fields and criteria are used for the Query
50.
What is letter "B" showing?
a)
Where to click to Run the Query
b)
Where to Configure the Fields returned and criteria to be used
c)
Where to click to configure the Join properties
d)
Where to click to Save this Query
51.
What is letter "C" showing?
a)
Where to click to Run the Query
b)
Where to Click to Save the Query
c)
Where to configure the Fields returned and the criteria to be used
d)
Where to configure the Join properties
52.
A _______ query displays a dialog box that prompts the user to enter criteria when the query is run.
a)
Top Values
b)
Pattern Match
c)
List of Values
d)
Parameter
53.
A query can get its data from
a)
a. one or more tables.
b)
b. existing queries.
c)
c. a combination of a and b.
d)
d. all of the above.
54.
Which Boolean operator will narrow your results
a)
AND
b)
OR
c)
NOT
d)
BUT
55.
Which Boolean operator will expand your results
a)
AND
b)
OR
c)
NOT
d)
BUT
56.
A football team keeps a database about its players. Which query would allow them to produce a query showing players who are strikers and who have scored 20 goals or more?
a)
Position = "Striker" OR Goals = 20
b)
Position = "Striker" AND Goals = 20
c)
Position = "Striker" or Goals >=20
d)
Position = "Striker" AND Goals >= 20
57.
Wildcard that represents any collection of characters
a)
Asterisk
b)
Question Mark
c)
Query
d)
Equal Sign
58.
A teacher keeps pupil test results in a database.  Each pupil has sat multiple tests.  The teacher wants to run a query that shows each student and the average score they have achieved across the year.  What would be the correct query to use:
a)
Parameter Query
b)
GroupBy
c)
Wildcard
d)
Selection
59.
A bookshop owner is using the shop's database to help a customer.  The customer is looking for a particular author but cannot remember their full name.  The customer remembers that the surname of the author starts with the letters "Co".  What kind of query could the bookshop owner use to find this information?
a)
Parameter
b)
GroupBy
c)
Wildcard
d)
Selection
60.
Which datatype can store both text and numbers
a)
Boolean
b)
Image 
c)
number
d)
Text
61.
Which datatype would you use for a car registration number?
a)
Boolean
b)
Image 
c)
number
d)
Text
62.
What datatype is used for yes/no?
a)
text
b)
boolean
c)
numbers
d)
memo
63.
Which datatype is suitable for your date of birth?
a)
TEXT
b)
NUMBER
c)
DATE
d)
TIME
64.
Which datatype would be the best choice to store if  have you passed your driving test.
a)
text
b)
boolean
c)
memo
d)
number
65.
Select the correct definition for "Field"
a)
This stores all the records for a particular field
b)
A collection of data stored in logical order
c)
One piece of data or information about a person or object

Similar Resources on Wayground

Quiz Dedicated Server

60 questions

Quiz Dedicated Server

quiz

Worksheet

•

12th Grade

Computer Science Essentials Semester Exam 2021

60 questions

Computer Science Essentials Semester Exam 2021

quiz

Worksheet

•

9th - 12th Grade

Prueba de Hardware de Computadoras

60 questions

Prueba de Hardware de Computadoras

quiz

Worksheet

•

12th Grade

R081 - Revision Quiz

68 questions

R081 - Revision Quiz

quiz

Worksheet

•

9th - 10th Grade

Doors

60 questions

Doors

quiz

Worksheet

•

1st Grade - Professio...

ÔN TẬP Giữa Kỳ Môn Tin Học 8

62 questions

ÔN TẬP Giữa Kỳ Môn Tin Học 8

quiz

Worksheet

•

7th Grade - University

Year 11 Progress test 2

61 questions

Year 11 Progress test 2

quiz

Worksheet

•

9th - 10th Grade