Office Productivity Software
Solved Exam Questions
Course Introduction
This course provides a comprehensive introduction to office productivity software commonly used in academic and professional settings. Students will gain practical experience with word processing, spreadsheet, presentation, and database applications, learning to efficiently create, edit, format, and manage documents, analyze data, and deliver effective presentations. Emphasis is placed on applying these tools to solve real-world tasks, improving workflow, collaboration, and communication skills essential for success in various fields. By the end of the course, students will be equipped to leverage productivity software to enhance personal and organizational efficiency.
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) How many characters may a field name in Access contain including numbers,letters,spaces,and special characters?
A) 255
B) 36
C) 64
D) 146
Answer: C
Q2) The default ____________________ provided by Access is the ID field.
Answer: primary key
Q3) Records in separate tables may be connected through a(n) ____________________ that appears in both tables.
Answer: common field
Q4) Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?
A) primary key field
B) field value
C) foreign key field
D) common field
Answer: D
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) In the <u>Database Design</u> grid,press the Enter key to move from one property to the next property._________________________
A)True
B)False
Answer: False
Q2) Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?
Answer: A one-to-many relationship exists between two tables when one record in the first table matches zero,one,or many records in the second table,and when one record in the second table matchesat most one record in the first table.Here,the Ownerand Animal tables havea one-to-many relationship becausean Owner can own manyanimals,and eachanimal isassociated with only one owner.The two tablesare still separate tables,but because theyare joined,you can use the data in them as if they were one table.
Q3) In a single table,all ____________________ must be unique within that table.
Answer: field names
Q4) The default Field Size for the Short Text data type is ____________________ characters.
Answer: 255
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/39056
Sample Questions
Q1) A criterion,or rule,that determines which records are selected when a query is run is called a(n) ____.
A) sort order
B) condition
C) operator
D) match
Answer: B
Q2) Functions that perform arithmetic operations on selected records in a database.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query
Answer: A
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) The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field. ____________________
A)True
B)False
Q2) Data in a form may only be modified in ____ view.
A) Form
B) Layout
C) Design
D) Datasheet
Q3) Data in Date/Time fields are automatically ____-aligned.
A) left
B) right
C) center
D) top
Q4) Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.
Q5) A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n) ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 6