NEW
Font size
WorksheetsBusiness Apps FInal Exam Review
Total questions: 30
Worksheet time: 15mins
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
database
spreadsheet
word processor
query
report
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
records
rows
fields
columns
In a database table, rows are called __________
fields
records
rows
columns
Forms, queries, and reports are created based on the information in the _________
tables
reports
spreadsheets
presentation
Queries are also known as questions
true
false
The _______ feature is responsible for controlling the sequence, or order, of the records.
criteria
parameter
alphabetical
sort
A database and a table are the same thing
true
false
The _________ _______ is used to identify each record in the table with a number.
alphabetize sort
primary key
criteria parameter
dialog box
Database forms are computerized versions of paper forms, such as a patient record, job application or a class registration form.
true
false
Which object is used to create a form?
Tables and queries
tables only
tables and reports
queries and reports
The intersection of a column and row is a/n:
cell
cursor
record
column
Which criteria return only those addresses beginning with the letter "K"?
Address="K"
Address="K*"
Address="K?"
Address="K#"
Which leads you through the process of creating a table?
wizard
assistant
relation
coach
Which data type is better is better to use for storing the price of an item
text
autonumber
number
currency
After right clicking the field selector button, which do you choose to delete a field.
delete field
delete row
remove field
remove row
In a database, each ______________________ contains a collection of related data.
table
record
field
none of the above
If you sort data in order of decreasing value such as Z-A, or 10-1, what type of sort are you using?
Ascending
descending
incremental
exponential
Databases typically store their data in one big table.
true
false
A field's data type determines what kind of information can be stored there.
true
false
A query lets you speed up the browsing process by finding information that matches specifically to your criteria.
true
false
Nick wants Access to assign an ID number to each record. What is this called?
data type
autonumbering
properties
none of the above
how many messages are there in the deleted items folder?
It is impossible to give any information about this without opening the folder
at least 3800
at most 3800
3800
In the diagram, the outbox is selected and contains 1 message. What does this mean?
That you have successfully sent a message
That you have created a message, but have not yet tried to send it
That you have tried to send a message, but that it has not yet been sent
Imagine that someone composes and sends an email as shown in the image. If you open this email and click reply all- how many people will receive your email?
0
2
5
3
The emails each have a red exclamation mark next to them. What does this mean?
Each email has been flagged as being sensitive
Each email has been marked as private
Each email includes another email item as an attachment
Each email has been designated as being of high priority by the sender
It will sort the emails alphabetically by subject
It will still sort the emails by date/time received, but if two emails were received at the same time these will be subsorted by subject
Nothing
It will reverse the sort order, so that the emails received earliest appear at the top of the list
You are planning to attend the 3-day Conference in a month and would like to reserve the block time on a calendar to let others see this time reserved on your calendar. This time should be scheduled in Outlook as _____?
Event
meeting
any of these
none of the above
A file sent with an email
folder
attachment
draft
flag
Used to keep track of appointments
notes
calendar
tasks
If you do not want the recipients of your message to see the others you also sent the message to, you should use the _________________ feature.
hide
cc
bcc
flag
