NEW
Font size
S
M
L
XL
WorksheetsDatabase Essentials
Total questions: 75
Worksheet time: 38mins
Name
Class
Date
1.
When is a database used?
a)
To perform searches for information on the Internet
b)
To create and format text documents for sharing information
c)
To display information in a picture form instead of using words
d)
To store and organize large amounts of information for quick searching
2.
Databases store information in ___________________, which are made up of columns and rows.
a)
tabs
b)
tables
c)
ribbons
d)
image files
3.
Relational databases consist of multiple tables of information that are related through:
a)
big data.
b)
ID columns
c)
header rows
d)
common fields
4.
Which type of application should you use if you need to "crunch" relatively small volumes of numbers to analyze numeric data?
a)
Database
b)
Presentation
c)
Spreadsheet
d)
Word processor
5.
Which type of application should you use if you need to store a large quantity of data in an organized format that you can easily query?
a)
Database
b)
Presentation
c)
Spreadsheet
d)
Word processor
6.
Which statement about spreadsheets is true?
a)
Spreadsheet files can contain an infinite number of records.
b)
Spreadsheet files can contain only a limited number of records.
c)
Spreadsheet applications are generally complex, difficult and time-consuming to design.
d)
Spreadsheet tables can be related through common fields, thereby eliminating redundant data.
7.
Which statement about databases is true?
a)
Database files are prone to inadvertent data corruption
b)
Database files can contain only a limited number of records.
c)
Multiple people can use the same database data simultaneously.
d)
Database applications are used to "crunch" numbers for numeric analysis.
8.
What is the term for a collection of data so large and complex that it is difficult to store and process using traditional database software?
a)
Big data
b)
Relational data
c)
Unrelated data
d)
Spreadsheet data
9.
Which Microsoft Office application should you use for database creation and manipulation?
a)
Bing
b)
Excel
c)
Access
d)
Google
10.
Search engines consist of ___________________ that contain information about webpages.
a)
databases
b)
spreadsheets
c)
pre-defined queries
d)
big-data documents
11.
Advertisers use Big Data to:
a)
gather information on everyone.
b)
sell information to others.
c)
focus target markets.
d)
spy on consumer shopping habits
12.
The following is true about Search engines, except:
a)
they make is easy to find information on the Internet.
b)
they are large databases that contain information about webpages
c)
they are powerful software programs.
d)
they are suitable for crunching numbers
13.
The Title Bar in Access usually consists of___________________?
a)
the names of the application and the Database
b)
the names of the application and the file
c)
the names of the application and the user
d)
the names of the file and the user
14.
The options on the Ribbon will _______________.
a)
change depending on the tab
b)
change depending on the view
c)
stay the same depending on the tab
d)
stay the same depending on the view
15.
You will find these options on the backstage view of Access except __________________.
a)
print
b)
save
c)
open
d)
create
16.
Retailers use big-data to
a)
offer special promotions
b)
sell information to others.
c)
create databases.
d)
create spreadsheets.
17.
What options are available by default on the Quick Access Toolbar?
a)
Save, Redo and Undo
b)
Print, Save and Redo
c)
Redo, Undo and Help
d)
Print, Save, and Delete
18.
Which of the following is an advantage of using a database?
a)
More than one person can use it at a time
b)
Easy to learn
c)
Useful for storing and crunching small amounts of data
d)
Can easily present information in a graphical form
19.
Which of the following is an advantage of using a spreadsheet?
a)
Data is protected from corruption
b)
May contain redundant data
c)
The ability to sort and query easily
d)
Software and hardware costs are higher
20.
_____________________is a search engine.
a)
Bing
b)
Excel
c)
Access
d)
. One Note
21.
In a database, Yes/No, Text and Date/Time are all examples of:
a)
data types
b)
data queries.
c)
tabs you can select.
d)
records in the data table.
22.
Which database component is used to organize information by data type?
a)
Row
b)
Title
c)
Field
d)
Record
23.
What is another name for a table row in a database?
a)
Field
b)
Record
c)
Column
d)
Heading
24.
What can you use to retrieve specific data from a table within a database?
a)
Field
b)
Query
c)
Record
d)
Column
25.
What can you use to summarize and print data for presentation or sharing?
a)
Query
b)
Report
c)
Column
d)
Heading
26.
Which language is used to develop and manage databases?
a)
SQL
b)
Java
c)
HTML
d)
DBMS
27.
What does a database use to provide a simplified interface for the user to enter, modify and view database records?
a)
Form
b)
Table
c)
Query
d)
Report
28.
In which of the following must the data be unique?
a)
The foreign key
b)
The primary key
c)
The junction table
d)
The common field
29.
In which table relationship does a record in Table A have multiple matching records in Table B, but a record in Table B has only one matching record in Table A?
a)
One-to-one
b)
One-to-many
c)
Many-to-many
d)
Primary-to-foreign
30.
Which database application would most likely be used in large organizations?
a)
Excel
b)
HTML
c)
Oracle
d)
Access
31.
Which data types is best for calculations?
a)
AutoNumber
b)
Text
c)
Number
d)
Currency
32.
How many characters are allowed in the Text field?
a)
More than 255
b)
1-255
c)
1-9
d)
Unlimited
33.
What type of relationship is created only if both of the related fields are primary keys in Table A that matches a record in Table B, and vice versa
a)
One-to-one
b)
One-to-many
c)
Many-to-many
d)
Primary to-foreign
34.
What is a field in a related database table that refers to the primary key in the primary table?
a)
Secondary key
b)
Table key
c)
Foreign key
d)
Common key
35.
What data type is used for monetary values?
a)
Autonumber
b)
General
c)
Currency
d)
Accounting
36.
What data type is used to provide links to other resources?
a)
Attachment
b)
Hyperlink
c)
OLE Object
d)
Text
37.
What data type allows object linking and embedding?
a)
Attachment
b)
Hyperlink
c)
OLE Object
d)
Text
38.
There are ______________ data types in Access
a)
8
b)
10
c)
7
d)
12
39.
What does SQL stand for?
a)
Structured Query Language
b)
Simple Query Language
c)
Standard Query Language
d)
Single Query Language
40.
The tables of information in a relational database are joined or linked to one another by a ______________ field
a)
common
b)
key
c)
primary
d)
foreign
41.
How is each record in a database identified?
a)
By the record's foreign key
b)
By the record's primary key
c)
By the number in the ID column
d)
By the value contained in the first data column for the record.
42.
Which operation would you perform to change your age from 11 to 12 in a database field?
a)
Add a record
b)
Sorta record.
c)
Delete a record
d)
Update a record.
43.
Which operation would you perform to insert information into a database table for a new student in your class?
a)
Add a record
b)
Sort a record
c)
Delete a record.
d)
Update a record.
44.
Which operation would you perform to remove information from a database table for a student who leaves your class?
a)
Add a record.
b)
Sort a record.
c)
Delete a record.
d)
Update a record.
45.
What should you do if you want to view database records in alphabetical order by last name?
a)
Sort the records in the database by the Last Name field.
b)
Create another table and add records in the desired order.
c)
Sort the records in the database by the First Name field
d)
Update the Last Name field for each record in the database to reflect the desired order
46.
What happens to the unique ID field when a record is deleted?
a)
The ID is deleted.
b)
The ID remains.
c)
You cannot delete a record once is has an ID.
d)
The ID is reassigned to a new record.
47.
What View allows you to make changes to the database?
a)
Table View
b)
Form View
c)
Layout View
d)
Design View
48.
What information is considered when naming a database table?
a)
The information the table will contain.
b)
The purpose of the table.
c)
The order of the table.
d)
The name of the database
49.
After starting Access, what operations would you perform to create a new Blank Database?
a)
Click New, Blank Desktop Database
b)
Click Create
c)
Click New Template
d)
Click Start Blank Database
50.
What operations would you perform name a database?
a)
Click save.
b)
Click File, name, type the name and save
c)
Click File, close and save.
d)
Type the name in the File Name Box.
51.
Why is the text data type for the appropriate for the StudentName field?
a)
It has numeric data.
b)
The field is alphanumeric with less than 255 characters
c)
The field is alphanumeric with more than 255 characters.
d)
It has large text.
52.
Why is the number data type appropriate for the Siblings field?
a)
It has numbers with decimal places.
b)
It has unique sequential numbers
c)
. It has numbers and characters.
d)
It has numeric data.
53.
How are the record relationships preserved once a record is deleted?
a)
The unique ID values of the other records remain the same.
b)
The unique ID values of the other records change.
c)
You cannot delete the record.
d)
The records change
54.
What operations would you perform to delete a record?
a)
Select the entire record, right click the record, and select Delete Record.
b)
Delete the record name.
c)
Select the name, right click and select delete
d)
You cannot delete a record once it has an unique ID.
55.
What operations would you perform to add a record?
a)
From File, click Create, Record, enter the appropriate information and save.
b)
From File, click new record type in the information and save
c)
. In the Datasheet View, enter the appropriate information for each field in the row of the table.
d)
From the Design View, click add, new record, enter the appropriate information and save.
56.
Which of the following is a common error when creating database tables?
a)
Failing to add a foreign key
b)
Failing to add a common field
c)
Entering the wrong data type in a field
d)
Failing to uniquely identify each record
57.
Which of the following should you use to display specific information from a database table?
a)
A select query
b)
An action query
c)
An update query
d)
A table query
58.
Which of the following should you use to perform an action on specified records in a database table?
a)
A select query
b)
An action query
c)
An update query
d)
An append query
59.
The word "query" means:
a)
populate.
b)
question.
c)
answer.
d)
locate.
60.
How can you add two unrelated tables to a query?
a)
Add a foreign key.
b)
Add a primary key.
c)
Create a table join.
d)
Combine the tables.
61.
Which operation would allow you to convert a spreadsheet into a database?
a)
Query
b)
Export
c)
Import
d)
Translate
62.
Which operation would allow you to convert a database into a spreadsheet?
a)
Query
b)
Export
c)
Import
d)
Translate
63.
What should you create if you need to see a printout of the current data in a database?
a)
A form
b)
A query
c)
A report
d)
A spreadsheet
64.
What should you do if you want to alter the "look and feel" of a report?
a)
Create a form.
b)
Create a query.
c)
Add a report theme.
d)
Import the report into a presentation application.
65.
Why would you create a database report?
a)
To relate database tables through common fields
b)
To share and present database information in print form
c)
To select database information from multiple tables
d)
To create an object in which to view, enter and edit database information
66.
What operation would you perform to rename a field?
a)
Open the table in Design View, click into the field name column, type the new name, click the save button.
b)
Open the table in Design View, right click on the row the field name, click cut, and click the save button.
c)
Open the table in Datasheet View, click the drop down arrow, enter the new name, and click the save button.
d)
Open the table in the Layout View, click the drop down arrow, enter the new name, and click the save button.
67.
What operation combines two records and displays them as one record in the query’s result set?
a)
Join
b)
Link
c)
Copy
d)
Import
68.
Why would you export data?
a)
To create forms.
b)
To create queries.
c)
To create reports
d)
To use it in other applications.
69.
What are your options when importing data from Excel?
a)
Create, append or link to a database.
b)
Copy, cut or paste to a database
c)
Join, import or link to a database.
d)
Export, translate or query a database.
70.
What is a common error when creating and query?
a)
Mistyping the name of a table or field.
b)
Entering the wrong type in the data field.
c)
Selecting the wrong table
d)
Selecting the wrong type of query
71.
Which of the following is not a type of query?
a)
Action
b)
Update
c)
List
d)
Append
72.
What is not a type of error that prevents a join from working correctly?
a)
Different data types
b)
Uncommon fields.
c)
Unmatching values
d)
Primary Key
73.
When you select the link option while importing data, _______________.
a)
You can modify the data in Access
b)
The Access data updates when the source file updates.
c)
Creates a new table in Access.
d)
Append to a table in Access.
74.
You can use the following options to modify the look of a report except _______________.
a)
using themes
b)
font sizes
c)
color
d)
export.
75.
Why would you create an append query?
a)
To view information in a table.
b)
To add records to a table.
c)
To export information from a table
d)
To import information to a table.
Reset
