wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Database P4

Total questions: 12

Worksheet time: 6mins

Name
Class
Date
1.

Each item from this list is classified as...

Name

Birthdate

Social Security No.

Street

City

a)

table

b)

record

c)

field Name

d)

Data Type

2.

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

a)

Currency

b)

Number

c)

Date/Time

d)

Yes/No

3.

Microsoft's version of a Database Management System

a)

Excel

b)

Access

c)

Word

d)

PowerPoint

4.

Where do you configure the field properties of a Table?

a)

Design View

b)

Datasheet View

c)

Access View

d)

Create table

5.

The ___________field is exactly like number fields, but formatted to display decimal places and a currency symbol.

a)

text

b)

currency

c)

name

d)

date

6.

The best data type to choose for a postcode would be

a)

Number

b)

Text

c)

Date/Time

d)

Currency

7.

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

a)

Number

b)

Text

c)

Date/Time

d)

Currency

8.

Which data type would you choose for a field if you wanted to enter data like "small", "medium" and "large" in the field?

a)

currency

b)

number

c)

date/time

d)

text

9.

In the table which customer has the Customer ID "3?"

a)

Jeff smith

b)

ava Torres

c)

carl Wilcox

d)

Larry winters

10.

what is a database?

a)

organized graph

b)

organized table

c)

organized collection of data

d)

collection of notes

Show answersExplanationPreviousNext

11.

What's a field?

a)

a column

b)

a table

c)

a row

d)

a section

12.

What is Microsoft access

a)

software

b)

database management software

c)

picture drawing program  

d)

storage