Cumulative Exam — Cumulative exam Answers

50 verified answers1 views
24

Dennis would like to include a video in a presentation. The source of the video is on the Internet, but he would like to ensure that the video will play even if an Internet connection is not active during the presentation. What should he do?

A
Use an embed code.
B
Use the Online Video command in the Media group.
C
Use the Video from my PC command in the Media group.
D
Use pictures instead because this cannot be done.
26

Janis needs to select all the text in a single bullet point. Which action describes the easiest method to perform this task?

A
Triple-click the text in the bulleted item.
B
Click the text and hold Tab.
C
Press Ctrl+A.
D
Double-click the text.
28

Which is an advantage of using a flat file instead of a relational database?

A
A flat file is easier to set up.
B
It is easier to assign foreign keys to a flat file.
C
A flat file reduces storage of redundant data.
D
A flat file reduces storage of irrelevant data.
29

Which describes a query?

A
A query organizes, summarizes, and presents data in an easy-to-view format.
B
A query allows for retrieval of information from multiple tables.
C
A query is a way to modify data in tables.
D
A query is a sorted report.
30

Which best describes a database?

A
a large collection of data
B
unorganized data
C
uncategorized data
D
a record of relevant data
31

Which database can be used on a desktop computer?

A
an online dictionary
B
an online shoe company that has seven hundred fifty thousand customers
C
the mailing information of the 432 voters in a city council member’s district
D
the online banking information of the customers of a national bank
33

Which is the best description of the difference between bound and unbound forms?

A
Bound forms are similar to hierarchical forms but pop up in a separate window, while unbound forms are flat forms that do not have subforms.
B
Bound forms are linked to a table or query, while unbound forms are not linked to a table or query but are used to operate and navigate a database.
C
Bound forms perform tasks based on user input, while unbound forms navigate between multiple forms.
D
Bound forms are the basic interface for inputting information into tables or queries, while unbound forms have one or more subforms within the main form.
34

A sorting tool is most likely used to

A
find missing data.
B
present ordered data.
C
generate search results.
D
find information sources.
35

A report titled “Employees in Company A” contains the names of employees in descending alphabetical order, with the number of years each employee worked at the company. Which statement is true?

A
The report is sorted only because it organizes the names of the employees in alphabetical order.
B
The report is sorted only because it gives information about employees by number of years of employment.
C
The report is grouped only because it organizes the names of the employees in alphabetical order.
D
The report is grouped only because it gives information about employees by number of years of employment.
36

What is a primary key?

A
a field that uniquely identifies a record in a table
B
a field that uniquely identifies a table
C
the first security key entered by a database user
D
the first security key entered by a database administrator
38

What is the first step in creating a database?

A
creating relationships within tables
B
creating relationships between tables
C
determining the number of tables to create
D
determining what data will be stored

Did you find these answers helpful?