wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Year 9 Access Quiz

Total questions: 60

Worksheet time: 34mins

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.

Similar Resources on Wayground

Quis SMA Part II

65 questions

Quis SMA Part II

quiz

Worksheet

•

9th - 12th Grade

Basic Electric-E Learning BUMA

60 questions

Basic Electric-E Learning BUMA

quiz

Worksheet

•

10th Grade - University

Storia - Hardware 1_ Tallini

63 questions

Storia - Hardware 1_ Tallini

quiz

Worksheet

•

1st Grade - University

Tecnología e informática 10 Global P2

55 questions

Tecnología e informática 10 Global P2

quiz

Worksheet

•

10th Grade

la madera

60 questions

la madera

quiz

Worksheet

•

10th Grade

Esgrima Biblico libro de Juan

60 questions

Esgrima Biblico libro de Juan

quiz

Worksheet

•

9th Grade

Micro:bit

60 questions

Micro:bit

quiz

Worksheet

•

11th Grade

Công nghệ hk2

58 questions

Công nghệ hk2

quiz

Worksheet

•

9th Grade