NEW
Font size
S
M
L
XL
WorksheetsAccess Quiz
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
A store tracks suppliers and inventory in a database. Which of the following would be a field in the supplier table?
a)
Inventory Cost
b)
Phone number
c)
Amount in stock
d)
Data Integrity
2.
A database contains a Customer table. What would be stored in a record of the customer table?
a)
Information about one order
b)
Information about one customer
c)
Information about all the customers
d)
Information about every order
3.
You discover many errors in a database table. What has been lost
a)
Data Integrity
b)
Primary Key
c)
Fields and Records
d)
database Management System
4.
You have a table that holds names and phone numbers for 1000 people. How many records are there?
a)
Two
b)
1000
c)
2000
d)
None
5.
Why does data inside a database need to be organized?
a)
So data integrity can be maintained
b)
So the data is neat and tidy
c)
So the data can be searched from the internet
d)
so the data can be found when needed
6.
Which of the following is an easy way to enter and browse data in a large database?
a)
Forms
b)
Tables
c)
Spreadsheets
d)
Records
7.
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
8.
You specify data types when adding _____.
a)
Records to a table
b)
Data Integrity to a database
c)
Fields to a table
d)
Data to a database
9.
Data can be entered into the Datasheet view, but it can be easier to use a ______ instead.
a)
Primary Key
b)
Field
c)
Form
d)
Record
10.
Every record must have a different ____ value in a table.
a)
Data Integrity
b)
Foreign Key
c)
Primary Key
d)
Field
11.
What is the advantage of reports over queries?
a)
Queries can be formatted
b)
Reports can be formatted
c)
Reports can access more data
12.
A primary key field from one table appears in a second table. What can be said about these tables?
a)
The tables are in in a duplication
b)
The tables are subordinated
c)
The tables are in s relationship
d)
The tables are queried
13.
What is it called when you view some records and hide others?
a)
Sort
b)
Search
c)
Filter
d)
Report
14.
Sorting from Z-A is also called a descending sort
a)
True
b)
False
15.
Does Microsoft Access need to be told about relationship between tables?
a)
No, relationships are automatically detected
b)
No, relationship are not supported
c)
Yes, relationships need to be defined
d)
yes, only when the fields have different names
16.
Ascending means sorting form:
a)
Smallest to Largest
b)
Largest to Smallest
17.
What is it called when you "ask the database a question"?
a)
Query
b)
Data Integrity
c)
Relationship
d)
Report
18.
A primary key field from one table appears in a second table. What is the field in the second called?
a)
A relationship key
b)
A primary key
c)
A foreign key
d)
A linked key
19.
Which ribbon tab do you use to make a new table?
a)
File
b)
Home
c)
Create
d)
External Data
20.
Which field is the primary key for the database table?
a)
Product ID
b)
Reference Name
c)
Supplier
d)
Stock Number Option
Reset
