Introduction to Database Management Pre-Test
Questions
Course Introduction
Introduction to Database Management provides students with a foundational understanding of database concepts, design, and implementation. The course covers essential topics such as data models, relational databases, SQL queries, normalization, and database system architecture. Students will learn how to efficiently organize, store, retrieve, and manipulate data in a structured manner, exploring the practical applications of database management in real-world scenarios. Through hands-on projects and lab exercises, students will gain practical experience in designing and managing databases, ensuring data integrity, and understanding the role of database management systems in modern information technology environments.
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) When working with Access in ____ Mode,the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.
A)Write
B)Touch
C)Tap
D)Tablet
Answer: B
Q2) Records in separate tables may be connected through a(n)____________________ that appears in both tables.
Answer: common field
Q3) 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
Q4) A table's contents are shown in rows and columns when using the ____________________ view.
Answer: Datasheet
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) All fields in a database should be contained in one table.
A)True
B)False
Answer: False
Q2) The term used when the same data is stored in more than one place which can cause inconsistencies in the database.
A)Cascade Update Related Fields Option
B)Cascade Delete Related Records Option
C)Composite key
D)data redundancy
E)Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity
Answer: D
Q3) The "one" table in a one-to-many relationship is the ____________________ table.
Answer: primary
To view all questions and flashcards with answers, click on the resource link above. Page 4
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) The first field specified in the sorting process is called the ____________________ field.
Answer: primary sort
Q2) The ascending sort order for the Date/Time data type sorts dates from ____________________.
Answer: oldest to most recent date
Q3) A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.
Answer: filter
Q4) A calculated field is formatted using the ____ for the field.
A)Property Sheet
B)Criteria
C)Expression Builder
D)Operator
Answer: A
Q5) The ___________________ command allows hidden fields to be redisplayed.
Answer: Unhide Fields
Q6) The default name for a new Access query is ____________________.
Answer: Query1
Page 5
To view all questions and flashcards with answers, click on the resource link above.
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) The easiest way to move a picture on a form is to first remove the picture from the
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!
Q2) Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.
Q3) A placeholder used in a value search when only part of a value is known is called a ____________________ character.
Q4) The default theme for a new form that is created is the ____________________ theme.
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) When creating a find unmatched query using the query wizard,Matching fields will be joined automatically if a ____________________ is already defined between the two selected objects.
Q2) Marie creates the following expression as a new field in the query that she will use to create the report requested by the doctor PatientName: [LastName] &"," [FirstName]. This expression is an example of ____.
A)IsNull
B)concatenation
C)nonnull
D)an expression using a logical operator
Q3) When using the IIf function,a condition is tested,and if the condition is<u> false</u>,the first value of the condition is returned by the function.____________________
Q4) The Top Values query property allows the user to limit the number of records in the query results by using a preset value,by entering an integer,or by selecting a(n)____________________.
Q5) ____________________ perform arithmetic operations on selected records in a crosstab query.
Q6) Table Validation Rules are entered using the ____________________ for a table. Page 7
To view all questions and flashcards with answers, click on the resource link above.
Page 8
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 new custom form meets Carlos' requirements;however,some of the labels do not clearly describe the data that needs to be entered in the form.Which label property should Carlos change to make the label more descriptive and clear to the user?
A)Content property
B)Visible property
C)Special Effect property
D)Caption property
Q2) Akash has included a calculated field in the subform which was created using a query for unpaid invoices.The calculated field should show the total amount of unpaid invoices from the InvoiceAmt field;however,the form does not show the calculation in Form view.Which expression will solve this problem?
A)Sum([InvoiceAmt])
B)=Sum([InvoiceAmt])
C)Count([InvoiceAmt])
D)=Count([InvoiceAmt])
Q3) A form may only be created from scratch in Form view.
A)True
B)False
Q4) A(n)____________________ is an unbound control that displays text.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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) The Currency control format adds comma separators and a maximum of two decimal places.
A)True
B)False
Q2) The expression =Date(),inserted in a text box in a report design,will return the ____________________ value.
Q3) Properties of a multiple-column report may be changed using the ____________________ section of the Page Setup dialog box.
Q4) Access allows the creation of mailing labels based on manufacturer templates or custom formatted labels.
A)True
B)False
Q5) Describe five common enhancements and corrections that may be needed when modifying a report.
Q6) What is the maximum number of sort fields that can be included in a report?
A)5
B)10
C)12
D)unlimited
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) The Chart Type window in Microsoft Graph offers the option to create custom chart types.
A)True
B)False
Q2) A file type that defines the structure of an XML file and embeds the information in the XML file.
A)XSD file
B)HTML document
C)x-axis
D)CSV file
E)XSL
F)destination file
G)mySQL
H)XML (Extensible Markup Language)
I)source file
J)y-axis
Q3) Using the minimum size option when saving a ____________________ file does not include functionality for screen readers.
Q4) The data value of each data item in a chart is represented by
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) 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
Q2) A join that relates records from the Bus Number table with the Bus Routes table based on the same Bus ID is an example of a(n)____ join.
A)inner
B)outer
C)self
D)common
Q3) Under what circumstances might it be advisable to delete a database object.
Q4) Records deleted using a Delete query may not be restored by using the ____ command.
A)Redo
B)Undo
C)Unhide
D)Select
Page 12
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) After searching for a specific action in the Action Catalog pane,all actions may be displayed again by clicking on the ____ button.
A)Expand All
B)search
C)clear filter
D)Undo
Q2) A macro attached to the OnOpen property in a form will execute its actions each time the form is opened.
A)True
B)False
Q3) A database developer may use either a macro or VBA code to display a user interface for the database.
A)True
B)False
Q4) What are some advantages of including submacros in a single macro instead of creating them all as separate macros?
Q5) What are some of the problems in restricting access to Database Objects and prohibiting design changes?
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) A control is displayed when the <u>IsNull</u> property is True in a procedure statement.____________________
Q2) A ____ module is automatically created when the first event procedure for a form or report is created and it is associated with that specific form or report.
A)class
B)local
C)standard
D)public
Q3) A control is not displayed when the Visible property is to ____.
A)Yes
B)No
C)True
D)False
Q4) A control is hidden in Access when the Visible property is False in a Case statement. A)True
B)False
Q5) Why is it recommended that procedures be compiled after they are first created or when changes are made to the procedure code?
Page 14
To view all questions and flashcards with answers, click on the resource link above.
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) It is recommended that the user interface of a database be displayed using the ____ when a database opens with the Display Navigation Pane property disabled.
A)Layout View
B)navigation form
C)Datasheet view
D)edit form
Q2) The first set of data Sheng needs to provide is the names of all floor mat manufacturers who provide floor mats that fit a specific car model.Which type of filter should Sheng apply to the FloorMatCapatibility field that will allow the display of context-sensitive values for this single field?
A)Advanced Filter/Sort
B)Filter by Form
C)Filter by Selection
D)AutoFilter
Q3) When deciding whether or not to use a multivalued filed in an Access database,what limitations of using multivalued fields should be given careful thought?
Q4) Why is it a good idea to set the Allow Zero Length property to No for fields with the Text or Memo data types?
To view all questions and flashcards with answers, click on the resource link above. Page 15
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) Links to companion Sways that teach you how to use OneNote can be found at
Q2) Office Mix is an add-in for Microsoft PowerPoint,which allows users to enhance PowerPoint presentations.
A)True
B)False
Q3) To enhance and assess audience understanding,make your slides interactive by using Office Mix to __________.
Q4) Microsoft Edge allows you to __________.
Q5) To share a presentation through Office Mix,
A)users hold up their devices so that others can look at it.
B)Presentations cannot be shared through Office Mix.
C)a data projector is required.
D)a link is shared with friends and colleagues.
Q6) Each OneNote notebook contains _____,_____,and _____.
A)sections
B)pages
C)other notebooks
D)complete apps
Q7) Office Mix is a __________
To view all questions and flashcards with answers, click on the resource link above. Page 16