Lesson 1 Exam

________a source file in Access means that any changes made to one file are automatically updated in the other file.

Question 1 options:

a) Appending
b) Linking
c) Merging
d) Replicating

Question 2 (5 points)

In PowerPoint, _______________ is a type of slide layout that changes the look and flow of a presentation by providing text placeholders that do not contain bullet points.

Question 2 options:

a) outline view
b) section header
c) list level
d) placeholder

Question 3 (5 points)

In addition to typing data directly into a table, data can be imported into Access from another application such as a Word table, an Excel worksheet, or a different Access database. It then can do all the following EXCEPT:

Question 3 options:

a) be appended to an existing table.
b) used to create a new table.
c) be copied to an existing table.
d) link the data to a linked table.

Question 4 (5 points)

In addition to typing data directly into a table in Access, data can be __________from another application such as a Word table, an Excel worksheet, or a different Access database.

Question 4 options:

a) transferred
b) imported
c) copied
d) moved

Question 5 (5 points)

A _____________ is a feature in Microsoft Office that walks you step by step through a process.

Question 5 options:

a) Wizard
b) Guide
c) Tutorial
d) Tutor

Question 6 (5 points)

The _________ principle of good database design is a principle stating that appropriate database techniques are used to ensure the accuracy and consistency of data as it is entered into the table.

Question 6 options:

a) first
b) second
c) third
d) fourth

Question 7 (5 points)

Fields in Access make up:

Question 7 options:

a) rows.
b) records.
c) tables.
d) databases

Question 8 (5 points)

All the following are Access objects that make a database useful for locating and analyzing information EXCEPT a/an:

Question 8 options:

a) report.
b) query.
c) form.
d) applet.

Question 9 (5 points)

A presentation in PowerPoint can contain all the following EXCEPT:

Question 9 options:

a) charts.
b) multimedia objects.
c) graphic objects.
d) another application.

Question 10 (5 points)

You can create an Access database from scratch by using the blank desktop database template or a(n):

Question 10 options:

a) Word table.
b) Excel worksheet.
c) data file.
d) custom web app.

Question 11 (5 points)

In PowerPoint, ______________ is a view that shows the full-screen slide show on one monitor or projection screen while enabling the presenter to view a preview of the next slide, notes, and a timer on another monitor.

Question 11 options:

a) outline
b) presenter
c) normal
d) reading

Question 12 (5 points)

A__________ is the foundation of an Access database.

Question 12 options:

a) query
b) column
c) row
d) table

Question 13 (5 points)

Each row in Access is a(n) __________ (all items of data pertaining to one person, place, or thing).

Question 13 options:

a) entry
b) record
c) field
d) data string

Question 14 (5 points)

The basic components of an Access database are referred to as:

Question 14 options:

a) tables.
b) queries.
c) reports.
d) objects.

Question 15 (5 points)

Which of the following is NOT one of the three methods of creating a database in Access 2016?

Question 15 options:

a) Use a database template (a preformatted database)
b) Create a new database from a blank desktop database
c) Create a new online database in the cloud
d) Create a custom web app database that can be published and shared over the Internet.

Question 16 (5 points)

With PowerPoint, as in other Microsoft Office applications, on the Design tab, in the Themes group, clicking ___________displays the Themes gallery.

Question 16 options:

a) More
b) Effects
c) Modify
d) Gallery

Question 17 (5 points)

Database management software controls all of the following EXCEPT how data is:

Question 17 options:

a) saved.
b) organized.
c) retrieved.
d) secured.

Question 18 (5 points)

___________make up tables in Access.

Question 18 options:

a) Rows
b) Records
c) Columns
d) Data fields

Question 19 (5 points)

The primary editing view in PowerPoint where you write and design your presentations is___________ view.

Question 19 options:

a) outline
b) presenter
c) normal
d) design

Question 20 (5 points)

Principles of good Access database design, also known as normalization, help ensure that the data in your database is accurate and organized in a way that you can retrieve ____________ that is useful.

Question 20 options:

a) data
b) information
c) reports
d) queries


Last Updated on February 11, 2019 by Essay Pro