Database Management Systems
Midterm Exam
Course Introduction
Database Management Systems is a comprehensive course focused on the principles, design, and implementation of modern databases. Students will explore data modeling techniques, relational algebra, and the structure of relational databases, including normalization and schema design. The course covers SQL for data definition and manipulation, transaction management, indexing, query optimization, and database security. Through hands-on projects and case studies, learners will gain practical experience in developing, querying, and administering databases, while also being introduced to advanced topics such as distributed databases, NoSQL systems, and trends in big data management.
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) It is possible to view all Access objects in the Navigation Pane._________________________
A)True
B)False
Answer: True
Q2) Another term used for the column selector feature is ____.
A)row selector
B)record selector
C)name selector
D)field selector
Answer: D
Q3) Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks?
A)closes the current database
B)closes the current database and exits Access 2016
C)closes only the current database object
D)copies the current database and exits Access 2016
Answer: A
Q4) The default ____________________ provided by Access is the ID field.
Answer: primary key
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) When choosing field names,it is best to choose names that ____.
A)include both numbers and letters in the name
B)use only uppercase characters
C)describe the content or purpose of the field
D)use only lowercase letters and no spaces
Answer: C
Q2) A primary key that consists of two or more fields is called a(n)<u>redundant key</u>._________________________
A)True
B)False
Answer: False
Q3) A relationship between Access tables that is a relationship between one record in the first table and zero,one,or many records in the second table,and at least one record in the second table matches at most one record in the first table,is defined as a ____ relationship.
A)One-to-One
B)One-to-Many
C)One-to-Most
D)Many-to-One
Answer: B
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) Access may base queries on one or more <u>tables or queries</u>.____________________
A)True
B)False
Answer: True
Q2) The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.
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: E
Q3) The ___________________ command allows hidden fields to be redisplayed. Answer: Unhide Fields
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) To design a form using the Form Wizard,begin by clicking on the ____ tab on the Access Ribbon.
A)HOME
B)CREATE
C)FILE
D)EDIT
Q2) One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."
A)condition type
B)rule type
C)field format
D)field value
Q3) A placeholder used in a value search when only part of a value is known is called a ____________________ character.
Q4) The Report Wizard allows detail records to be <u>sorted</u> by up to four fields.____________________
A)True
B)False
Q5) A report layout may be changed using options on the ____________________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) Which of the following illustrates a calculated field with the name of the calculated field in the proper format?
A)[Donation]>=2500
B)DonationsGreaterThan2500: [Donation]>=2500
C)>=2500[Donation]
D)[Donation]:DonationsGreaterThan2500:>=2500
Q2) An input mask property cannot be changed after the Input Mask Wizard closes.
A)True
B)False
Q3) Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?
A)Like
B)Between
C)In
D)Or
Q4) The ____________________ aggregate function returns the average of the field values.
Page 7
Q5) ____________________ perform arithmetic operations on selected records in a crosstab query.
To view all questions and flashcards with answers, click on the resource link above.
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) The Access tool that allows the user (or designer)to create detailed documentation of all,or selected,objects in a database is the ____.
A)Documenter
B)Document Properties
C)Database Object Properties
D)Database Relationships
Q2) To avoid typing errors when creating a more advanced expression for a calculated control,it is a good idea to use this Access feature.
A)Property Sheet
B)Controls group on the ribbon
C)Form view
D)Expression Builder
Q3) To create a custom form,the user may modify an existing form in <u>Form </u>view or Design view._________________________
A)True
B)False
Q4) To improve a form's readability,group related information or underline important values using the ____________________ tool in the form's Design view.
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) Records in a report may be sorted using only one sort field.
A)True
B)False
Q2) Yes/no and true/false fields are represented with check boxes in a report.
A)True
B)False
Q3) Discuss four report design guidelines that should be followed when planning a report design.
Q4) Access allows the creation of mailing labels based on manufacturer templates or custom formatted labels.
A)True
B)False
Q5) Which report view is the best to use to see what a report will look like when it is printed?
A)Report view
B)Print Preview
C)Layout view
D)Design view
Q6) Describe five common enhancements and corrections that may be needed when modifying a report.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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) "Record" is the default for the ____________________ form property and may be changed using the form Property Sheet.
Q2) Which Excel external data option automatically updates a table in the Access database when the Excel source file is updated?
A)import the source data into a new table
B)link to the data source by creating a linked table
C)append a copy of the records to a table
D)copy the data source from Excel
Q3) A ____ may be inserted manually using the Page Break tool to make navigation of a large form easier by using the Page Up and Page Down keys on the keyboard.
A)Combo Box control
B)page break control
C)Tab control
D)Button control
Q4) Access uses the ____________________ program to edit charts created with the Chart Wizard in Access.
Q5) Developers may customize the ____________________ programming language to describe the data contained and the data structure.
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) 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
Q2) To access the Edit Relationships dialog box from a shortcut menu,____ the join line between tables.
A)click and drag
B)delete
C)left-click
D)right-click
Q3) Under what circumstances might it be advisable to delete a database object.
Q4) Is it a good idea to save action queries permanently in a database? Why or why not?
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) Macros may only be run from within a form or report.
A)True
B)False
Q2) The Access action that selects a specified object so that an action can be run that applies to the object.
A)SelectObject
B)Apply Filter
C)OpenForm
D)RunMacro
Q3) Kirk agrees to create the interface.He realizes that the greatest benefit of the interface is to minimize ____.
A)the user's ability to use the database
B)the information available from the database
C)data being corrupted inadvertently
D)the administration of the database
Q4) A comment used to describe an action included in a macro must begin with /*.
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) The Visual Basic window is accessed using the ____ group from the Create tab.
A)Forms
B)Macros & Code
C)Templates
D)VBA
Q2) When using the RGB function in VBA,the color range for each value must be between the numbers of 0 through 150.
A)True
B)False
Q3) The purpose of a VBA ____ is to respond to an event that occurs with an object or form control in an Access database.
A)statement
B)Case control
C)event
D)procedure
Q4) An input mask can accomplish the same verification procedures on data that VBA can accomplish such as verifying the @ symbol in an email address.
A)True
B)False
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) The database created when using the Database Splitter that includes the tables of the 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 contents of an encrypted database cannot be recovered if the password for the database is not available.
A)True
B)False
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) Microsoft Edge allows users to _____,_____,and _____.(select all that apply)
A)write on webpages
B)read webpages without advertisements and other distractions
C)search for information using a virtual personal assistant
D)work seamlessly in real time with colleagues worldwide
Q2) Microsoft Edge allows you to __________.
Q3) Storyline selections,called Frames,allow users to add content.__________________
A)True
B)False
Q4) Each OneNote notebook contains _____,_____,and _____.
A)sections
B)pages
C)other notebooks
D)complete apps
Q5) In a Screen Recording,Office Mix
A)often crashes any computer running it.
B)offers helpful suggestions to search queries.
C)filters out any spam that may distract a user from a presentation.
D)captures everything that happens in a selected part of the screen,to be added to a presentation.
To view all questions and flashcards with answers, click on the resource link above. Page 15