NEW
Font size
S
M
L
XL
WorksheetsDatabase using Access
Total questions: 27
Worksheet time: 13mins
Name
Class
Date
1.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
2.
A column in a database.
a)
Field
b)
Record
c)
Entity
d)
Validation
3.
A group of related records.
a)
Entity
b)
Validation
c)
Field
d)
Filter
4.
Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
5.
A "database" is...
a)
a structured set of data held in a computer, especially one that is accessible in various ways
b)
spreadsheet program
c)
owerful presentation software
6.
A "key" in a database allows the user to...
a)
help establish relationships with other tables
b)
unlock data
7.
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
8.
In a database, a "table" is a...
a)
set of data elements using a model of vertical columns and horizontal rows
b)
spreadsheet program
c)
presentation program
9.
Keisha wants only Beyoncé songs from her database. What should she use to see and save them?
a)
Filter
b)
Form
c)
Query
10.
Michelle needs each club member to complete an information sheet. Which tool is best?
a)
Filters
b)
Form
c)
Query
11.
Nick wants Access to assign an ID number to each record. What is this called?
a)
Data Type
b)
auto numbering
c)
Properties
12.
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
13.
TRUE OR FALSE: You can create "reports" in Access Database in order to format data in user friendly way
a)
TRUE
b)
FALSE
14.
In a database, a "field" is
a)
unique identifier
b)
user friendly report
c)
a data structure for a single piece of data composed of records and fields
15.
What is a database?
a)
A piece of software to do calculations
b)
A device to load information onto the computer.
c)
A structured collection of information
d)
A calculator
16.
Which of the following describes a relational database?
a)
Access
b)
A database that has a table
c)
There are two or more tables that are linked using the primary keys
d)
There are more than one table that have duplicate data
17.
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
18.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
19.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
20.
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' SQL query criteria?
a)
>3
b)
<3
c)
<=3
d)
>=3
21.
What data type would be used to store the following item code: 0024
a)
Text
b)
Integer
c)
Real
d)
Boolean
22.
Which data type would be most suitable for Length?
a)
Integer
b)
Float/Double
c)
Boolean
d)
String
23.
The best data type to choose for a memberID would be
a)
Number
b)
Date/Time
c)
Text
d)
Currency
24.
The best data type to choose for date of birth would be
a)
Number
b)
Date/Time
c)
Text
d)
Currency
25.
What is the primary key in this database?
a)
Emp_Id
b)
Last Name
c)
Gender
d)
Title
26.
How many records are in this database?
a)
8
b)
5
c)
10
d)
12
27.
Which of the following would be used to uniquely identify a record?
a)
Validation
b)
Data type
c)
Primary key
d)
Field size
Reset
