Office Productivity Tools
Practice Questions
Course Introduction
Office Productivity Tools is a practical course designed to familiarize students with essential software applications widely used in modern workplaces, such as word processing, spreadsheets, presentations, and email management. Through hands-on exercises, students will learn to efficiently create, edit, and manage documents; analyze data using spreadsheets; develop compelling presentations; and utilize digital collaboration tools. The course aims to enhance students digital literacy and problem-solving abilities, equipping them with the skills necessary to improve productivity, streamline workflows, and communicate effectively in a professional environment.
Recommended Textbook
New Perspectives Microsoft Office 365 Access 2016 Introductory 1st Edition by Mark Shellman
Available Study Resources on Quizplus
4 Chapters
300 Verified Questions
300 Flashcards
Source URL: https://quizplus.com/study-set/1962 Page 2
Chapter 1: Creating a Database
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/39054
Sample Questions
Q1) Each row in an Access table datasheet displays which of the following?
A) a query
B) a record
C) a field
D) a data type
Answer: B
Q2) Which Access 2016 view contains commands used to manage Access files and options?
A) Datasheet view
B) Design view
C) Backstage view
D) Form view
Answer: C
Q3) Access report printing options may be changed using the<u>Navigation</u> dialog box._________________________
A)True
B)False
Answer: False
Q4) All of the data in a relational database are contained in ____________________.
Answer: tables
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Building a Database and Defining Table
Relationships
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/39055
Sample Questions
Q1) A database management system is a useful tool only if it meets which of the following criteria?
A) produces reports
B) contains simple records
C) meets the needs of its users
D) meets the needs of the designer
Answer: C
Q2) Field value maximum storage size is defined by the Field Size property for the data types including Short Text,Number,and ____________________ only.
Answer: AutoNumber
Q3) The data type that allows both sequential and random numbering is the ____ data type.
A) Number
B) Currency
C) AutoNumber
D) Long Date
Answer: C
Q4) In a single table,all ____________________ must be unique within that table.
Answer: field names
4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Maintaining and Querying a Database
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/39056
Sample Questions
Q1) Which comparison operator matches a pattern that includes wildcards?
A) Between...And...
B) Or
C) Not
D) Like
Answer: D
Q2) A query based on more than one table is a(n) ____query.
A) multiple
B) advanced
C) relationship
D) multitable
Answer: D
Q3) The process of rearranging records in a specified order or sequence is referred to as <u>sorting</u>.____________________
A)True
B)False
Answer: True
Q4) A ____________________ is a set of records that answers the question resulting from a query.
Answer: recordset
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Creating Forms and Reports
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/39057
Sample Questions
Q1) A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.
A) primary record
B) detail record
C) secondary table
D) record values
Q2) A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.
A) #
B) +
C) ?
D) *
Q3) A form must be displayed in ____________________ view to navigate,view,and edit data.
Q4) The default theme for a new form that is created is the ____________________ theme.
Q5) The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.
To view all questions and flashcards with answers, click on the resource link above. Page 6