Office Productivity Tools
Exam Questions
Course Introduction
Office Productivity Tools provides students with essential skills in using modern software applications to efficiently manage and organize digital tasks in both academic and professional settings. The course covers fundamental and advanced features of word processors, spreadsheets, presentation software, and collaboration platforms, emphasizing practical strategies for document creation, data analysis, presentation design, and effective teamwork. Through hands-on exercises and real-world scenarios, students learn to streamline workflows, enhance productivity, and leverage the full potential of office software to meet diverse organizational needs.
Recommended Textbook
New Perspectives Microsoft Office 365 Access 2016 Comprehensive 1st Edition by Mark Shellman
Available Study Resources on Quizplus
13 Chapters
975 Verified Questions
975 Flashcards
Source URL: https://quizplus.com/study-set/1658 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/32867
Sample Questions
Q1) AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab
Answer: D
Q2) Compacting a database rearranges the data and objects in a database to decrease its file size._________________________
A)True
B)False
Answer: True
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/32868
Sample Questions
Q1) A primary key that consists of two or more fields is called a(n)<u>redundant key</u>._________________________
A)True
B)False
Answer: False
Q2) Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?
A)Yes/No
B)Memo
C)Text
D)AutoNumber
Answer: A
Q3) The ____ property specifies the number of decimal places displayed to the right of the decimal point.
A)Decimal Places
B)Input Mask
C)Default Value
D)Format
Answer: A
Page 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/32869
Sample Questions
Q1) Statistical information such as totals and averages is calculated using ____.
A)comparison operators
B)mathematical operators
C)aggregate functions
D)logical functions
Answer: C
Q2) ____ is the default entry for each field in the Total row of the query design grid.
A)Group By
B)SUM
C)Totals
D)Maximum
Answer: A
Q3) Arithmetic operations are performed on selected records in a database using <u>Statistical</u> functions.____________________
A)True
B)False
Answer: False
Q4) The default name for a new Access query is ____________________. Answer: Query1
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/32870
Sample Questions
Q1) Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?
A)table
B)form
C)query
D)subdatasheet
Q2) A report layout may be changed using options on the ____________________ tab.
Q3) The wildcard character used to match any single alphabetic character.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!
Q4) A report formatted in _____________________ is wider than it is tall.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Creating Advanced Queries and Enhancing
Table Design
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/32871
Sample Questions
Q1) The standard naming convention prefix tag for a query used to identify the object type is ____.
A)Query
B)QURY
C)qry
D)QRY#
Q2) Tables used in a find unmatched query must have a <u>common field</u>.____________________
A)True
B)False
Q3) Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number?
A)999\-000\-0000
B)999-000-9999
C)999\000\0000
D)000\-999\-9999
Q4) Fields and criteria that will be used in a query are contained in the ____________________ when creating a query.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Q5) Table Validation Rules are entered using the ____________________ for a table.
Chapter 6: Using Form Tools and Creating Custom
Formsmodule
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/32872
Sample Questions
Q1) A form may only be created from scratch in Form view.
A)True
B)False
Q2) A control that combines the features of a text box and a list box is a ____.
A)text box
B)lookup box
C)custom box
D)combo box
Q3) Spacing around the text inside a control is determined using the ____ property.
A)Control Margins
B)Control Padding
C)Anchor
D)Text Format
Q4) Akash used the Header section in his main form design,but he does not plan to use the Footer section.To remove the footer section,which section property should be set to zero?
A)Visible
B)Auto Height
C)Height
D)Display When
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Creating Custom Reports
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/32873
Sample Questions
Q1) Placing the report title,date,and page number on the same line in the ____ is a common report standard.
A)Report Header
B)Page Header
C)Report Footer
D)Page Footer
Q2) Describe five common enhancements and corrections that may be needed when modifying a report.
Q3) What is the maximum number of sort fields that can be included in a report?
A)5
B)10
C)12
D)unlimited
Q4) The format for a label is displayed in the Prototype label box when using the ____.
A)Label Wizard
B)Repot Wizard
C)Form Wizard
D)Custom Label Wizard
Q5) List 3 reasons to create a custom report.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Sharing,integrating,and Analyzing Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/32874
Sample Questions
Q1) Data in an Access table linked to an Excel source file may be edited using which process?
A)edit data in the Access table only
B)edit data in the Excel source file only
C)edit data in both Access and Excel separately
D)data may not be edited once linked
Q2) To create a reminder for an import task that is repeated on a regular basis,a(n)____ may be created.
A)Outlook Task
B)Access Wizard
C)Import Task Reminder
D)Repeat Reminder
Q3) Cayla wants to create a new table for each of the imported files.Which option should she choose from the dialog box that appears during the import process?
A)Append a copy of the records to the table
B)Link to the data source by creating a linked table
C)Import the source data to an existing table
D)Import the source data into a new table in the current database
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Using Action Queries and Advanced Table
Relationships
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/32875
Sample Questions
Q1) Text expressions included in the Update To row of an update query should always be enclosed in <u>quotation marks</u>.____________________
A)True
B)False
Q2) The abbreviation for a one-to-many relationship.
A)append query
B)delete query
C)M:N
D)primary table
E)1:M
F)update query
G)action query
H)1:1
I)expression
J)history table
Q3) The default join type for table relationships in Access is a(n)____ join.
A)inner
B)self
C)outer
D)append
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Automating Tasks With Macros
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/32876
Sample Questions
Q1) Which of these Access objects will work as a subform in a navigation form?
A)crosstab queries
B)macros
C)table datasheet
D)select queries
Q2) Which of the following is an example of an event property?
A)OnClose
B)Input Mask
C)Validation Rule
D)Border Style
Q3) In an SQL SELECT statement,tables to be used for the query are listed after the keyword ____.
A)WHERE
B)FROM
C)SELECT
D)TABLE
Q4) Macros may only be run from within a form or report.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Using and Writing Visual Basic for Applications
Code
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/32877
Sample Questions
Q1) Which of the following is a method used in a procedure to move the focus to a specific object or control.
A)Dim
B)SetFocus
C)Me.Undo
D)IsNull
Q2) VBA is considered to be a(n)____ programming language because instructions are executed on objects in the database.
A)markup
B)object-oriented
C)compiler
D)assembly
Q3) The Immediate window allows the developer to test or ____ individual lines of VBA code.
A)restore
B)compile
C)debug
D)append
Q4) List four advantages of using VBA rather than macros in Access.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Managing and Securing a Database
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/32878
Sample Questions
Q1) A table that is stored in a file outside of the open database that can be updated from the open database.
A)front-end database
B)AutoFilter
C)Performance Analyzer
D)inner query
E)linked table
F)back-end database
G)outer query
H)subquery
I)parent query
J)Filter by Selection
K)multivalued field
L)Use Access Special Keys option
M)Display Form option
Q2) The objects in a front-end database use tables in the ____.
A)modules list
B)ODBC database
C)back-end database
D)relationships window
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 13: Relational Databases and Database Design
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/32879
Sample Questions
Q1) OneNote only allows one type of project to be stored at a time.__________________
A)True
B)False
Q2) Use the ______ button to display your finished Sway presentation as a website.
Q3) You can share inked pages with others using Microsoft Edge by __________.
Q4) Users can add Facebook or OneNote pictures in Sway without leaving the app.__________________?
A)True
B)False
Q5) Office Mix is an add-in for Microsoft PowerPoint,which allows users to enhance PowerPoint presentations.
A)True
B)False
Q6) To share an Office Mix presentation,
A)let a friend or colleage take a picture of it.
B)upload it to your personal Office Mix dashboard.
C)send the device via snail mail to whomever you want to present it to.
D)sharing Office Mix presentations is currently unavailable.
Q7) OneNote saves your notes __________.
To view all questions and flashcards with answers, click on the resource link above. Page 15