wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 10 Access Quiz

Total questions: 87

Worksheet time: 49mins

Name
Class
Date
1.

What is a Key field?

a)

A data item which uniquely identifies a record in a table.

b)

A data item which points to another record in a related table.

c)

A link between two tables.

d)

A single collection of data.

2.

$789.00 is an example of which data type

a)

Text

b)

Currency

c)

Boolean

d)

Decimal

3.

A search using the criteria =A*

a)

Will find any word with an A in it

b)

Words starting with an A

c)

Nothing

4.

What field type would be used to store the following data "0125-5221"

a)

Text

b)

Number

c)

Time/Date

5.

What does the data values from a field need to be in order for it to be named as a Primary Key

a)

Values need to be number

b)

Values need to be even

c)

Values need to be unique

d)

Values need to be a combination of letters and numbers

6.

Which field is the best fit to be a primary key?

a)

FilmName

b)

FilmID

c)

AverageRating

d)

Director

7.

How is the table being sorted?

a)

YearReleased Ascending

b)

AverageRating Descending

c)

AverageRating Ascending

d)

FilmName Ascending

8.
Film title is a suitable Primary key, true or false?
a)
True
b)
False
9.

A field is...?

a)

A specific piece of information in a database.

b)

A category of data in a database, eg First Name or Date of Birth.

c)

A large, open area usually covered in grass.

d)

A box in a database.

10.

Which is not an advantage for using computer based databases?

a)

Can easily sort data into order e.g. alphabetic

b)

Can easily make back-up copies

c)

If there is a power-cut, you can’t use it

d)

Can import or export data to/from other packages

11.

When looking at a database how can you easily spot fields and records?

a)

Fields are the rows of the database and records are the headings.

b)

Fields are the headings of a database and records are the rows.

12.

What is a 'database'?

a)

A database is a collection of data or information which is stored in a logical and structured way.

b)

A database is a place where all of the data in the world is stored.

c)

A database is something that does not store data.

d)

A database is a collection of data but not information.

13.
A sports club needs to store information about each member.  The individual information about each member is called a:
a)
Field
b)
File
c)
Table
d)
Record
14.

The HD field is using the data type Boolean

a)

True

b)

False

15.

What am I? I am a way of searching for data or information in a database.

a)

Table

b)

Record

c)

Query

d)

Field

16.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
17.

A database is a large collection of related data and computerised ones are used because....

a)

Paper filing cabinets are outdated and take up too much room

b)

Computerised databases are much better then paper ones

c)

Computerised databases take up less space, can be easily edited and are faster at searching and sorting information

d)

Computerised databases are much more efficient than paper ones, there are fewer errors and its faster to find all the data you need

18.

Which best explains the differences between a flat file and a relational database?

a)

Flat files only have one table

b)

Flat files only have one table and are prone to data inconsistencies unlike relational databases

c)

Relational databases have multiple tables to avoid data anomalies which are commonplace in flat file databases

19.

What is an example of a computerised database?

a)

Website

b)

Library system

c)

Powerpoint

d)

Word

20.
Which of these is not an advantage of using an electronic database?
a)
Faster to find information
b)
Easy to move information - portable
c)
Could be hacked
d)
Can keep a back-up copy
21.
Which of these is an advantage of a paper database?
a)
Easily damaged or lost
b)
Hard to update information
c)
Can share from one computer to another
d)
They are cheap to use
22.
I control data entry. I am also used for data entry.
a)
table
b)
query
c)
form
d)
report
23.
I give one the ability to present information in an easy-to-read format. I summarize and print information from the  query search.
a)
form
b)
table
c)
query
d)
report
24.
I can perform an advanced search. I am very similar to asking a detailed question. 
a)
report
b)
query
c)
table
d)
form
25.
maximum number of characters in a text field
a)
155
b)
255
c)
55
d)
355
26.
Before the used of database, organizations and individuals used....
a)
File Cabinets
b)
File Systems
c)
Printed Forms 
d)
Filing Systems
27.
AND, OR allow users to combine multiple ________ in querying a database:
a)
criteria
b)
tables
c)
records
28.

What is the correct data type:


17th January

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

29.

What is the correct data type:


2008

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

30.

What is the correct data type:


£1.25

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

31.

What is the correct data type:


Jodie

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

32.

What is the correct data type:


hot/cold

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

33.

What is the correct data type:


14/05/07

a)

Text

b)

Currency

c)

Date / Time

d)

number

e)

Yes / No

34.
__________ are used to provide a neat way of printing your data in many different ways.
a)
File
b)
Reports
c)
Computers
35.
_________ are on-screen windows that help you get data into your database and edit it on the way in
a)
forms
b)
guide
c)
tables
36.
Forms, queries, and reports are created based on the information in the _________
a)
Form
b)
Table
c)
Report
37.

In a database table, rows are called __________

a)

Field

b)

Record

c)

Primary Key

38.

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

39.
The sort feature is responsible for controlling the sequence, or order, of the records.
a)
True
b)
False
40.
A database and a table is the same thing.
a)
True
b)
False
41.
A number field uses _________ only.
a)
letters
b)
currency
c)
digits
42.
1. Filters can be used on query results 
a)
True 
b)
False 
43.
3. What is it called when you "ask the database a question"? 
a)
Relationship 
b)
Query 
c)
Data Integrity
d)
Report 
44.
4. What is the advantage of reports over queries? 
a)
A. Reports can be formatted 
b)
B. Reports can access more data 
c)
C. Queries can be formatted 
45.
8. Sorting from A-Z is also called a descending sort. 
a)
True 
b)
False 
46.
9. You cannot change the order of fields on a report. 
a)
True
b)
False
47.
10. What is it called when you view some records and hide others? 
a)
Report 
b)
Sort 
c)
Search 
d)
Filter 
48.
11. A query for a report can come from multiple tables. 
a)
True
b)
False
49.
12. What is it called when you want to see database records in a certain order? 
a)
Search 
b)
Filter 
c)
Sort 
d)
Report 
50.
15. In the image to the left, where would you click to look for a name in the database?
a)
A
b)
B
c)
C
51.
16. Look at the information in the database table to the left. What field is being used to SORT the table?
a)
Name 
b)
Phone 
c)
Address 
d)
City 
52.
Nick wants Access to assign an ID number to each record. What is this called?
a)
Data Type
b)
auto numbering
c)
Properties
53.
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
54.
4. Which database view can be used to enter data? 
a)
Table Design View
b)
Datasheet View 
55.
19. The image to the left represents a database. What does Item A indicate in the database?
a)
A database 
b)
A table 
c)
A record 
d)
A field 
56.
What TAB is used to Created a Report, a Query, a Form or another Table?
a)
Design
b)
Home
c)
Database Tools
d)
Create
57.
Database forms are computerized versions of paper forms, such as a patient record, job application or a class registration form.
a)
True
b)
False
58.

Where do you configure the field properties of a Table?

a)

Design View

b)

Datasheet View

c)

Access View

59.

A unique identifier used in creating a table that assures there will be no duplicate data.

a)

Primary Key

b)

Query

c)

Data Type

60.
When you create a new blank database, Access opens a database that contains
a)
one of each type of database object.
b)
a table.
c)
sample data.
d)
a template.
61.
7. In the image to the left, what is the highlighted area of the screen called? 
a)
Ribbon
b)
Navigation Pane 
c)
Database Table
d)
Database Form 
62.
After you have created a table or other database object, you should
a)
save it with a descriptive name.
b)
copy it to create a backup.
c)
link it to an external data source.
d)
insert a blank column at the end.
63.
When you quit the program, Access automatically
a)
creates a link between all tables.
b)
leaves the Navigation Pane open.
c)
saves the data.
d)
renames the file.
64.

If you click on the shown icon, how many options would be listed about a table?

a)

1

b)

3

c)

2

d)

4

65.

How many queries do you see in database?

a)

5

b)

3

c)

8

d)

Haven't any queries

66.

Identify the primary key from the following

a)

Name

b)

Mark

c)

Telephone

d)

Gender

67.

Alpha numeric is another word often used for a................ data type

a)

Currency

b)

Text

c)

Image

d)

Boolean

68.

Whish datatype is used for yes/no

a)

Text

b)

Memo

c)

Currency

d)

Boolean

69.

Which datatype is suitable for 5VS23G

a)

Date/Time

b)

Boolean

c)

Memo

d)

Text

70.

In database , we can

a)

Add the record

b)

Delete the record

c)

Amend the record

d)

All the above

71.

A health club wants to find all the members who use the club 3 days or more a week. What will they put in the query in the 'days' query criteria?

a)

>3

b)

<3

c)

>=3

d)

<=3

72.

Markell needs to specify two characters for the student ID field. What area of Design View would he access to specify this?

a)

Data Type

b)

Description

c)

Field Name

d)

Properties

73.

Data organized and formatted for printing.

a)

form

b)

table

c)

report

d)

query

74.

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

a)

<>

b)

<=

c)

>=

d)

><

75.

The single character wildcard is...

a)

?

b)

+

c)

*

d)

!

76.

The many character wildcard is...

a)

?

b)

+

c)

*

d)

!

77.
.accdb means
a)
Abracadabra
b)
Access
c)
Amazing
d)
Animal
78.
Which of the following is NOT  data type?
a)
Date/Time
b)
Short Text
c)
Long Text
d)
Formula
79.
The circled command_______
a)
Sorts records in descending order
b)
Sorts records in ascending order
c)
helps you select a single record or all records in a datasheet
d)
removes the current sort order
80.
Which data type will be used if I am wanting to list a start date?
a)
Long Text
b)
Short Text
c)
AutoNumber
d)
Date/Time
81.
Hospitals uses database
a)
TRUE
b)
false
82.
Data type where the field can contain any character is "_____".
a)
text
b)
autonumber
c)
currency
d)
decimal
83.
Questions the database can answer are called "_____" 
a)
queries
b)
berries
84.

Print and summarize data

a)

Tables

b)

Forms

c)

Query

d)

Reports

85.

This part of Access 2013 contains the commands and options you use to perform database tasks. Each tab contains a group of related commands.

a)

Backstage view

b)

Navigation Pane

c)

Ribbon

86.

Exporting data to alternate formats. Choose all that applies

a)

Excel

b)

Powerpoint

c)

Text

d)

PDF

e)

XML

87.
Kevin created a form to input FBLA membership data. He needs to change the background color of the form so that it displays correctly on mobile devices. Which option provides the tools Kevin will need to modify the form?
a)
Blank Form
b)
Form Design
c)
Form Wizard
d)
Form Tool

Similar Resources on Wayground

Công nghệ HK1

91 questions

Công nghệ HK1

quiz

Worksheet

•

9th - 12th Grade

Công nghệ 11

86 questions

Công nghệ 11

quiz

Worksheet

•

11th Grade

Câu hỏi về phát triển kinh tế

87 questions

Câu hỏi về phát triển kinh tế

quiz

Worksheet

•

12th Grade

PGWB cuy

88 questions

PGWB cuy

quiz

Worksheet

•

12th Grade

ÔN TẬP HỌC KÌ II - CN 11

90 questions

ÔN TẬP HỌC KÌ II - CN 11

quiz

Worksheet

•

9th - 12th Grade

Electricidad-Electrónica-Magnetismo

90 questions

Electricidad-Electrónica-Magnetismo

quiz

Worksheet

•

12th Grade