Desktop Database Management
Question Bank
Course Introduction
Desktop Database Management explores the principles and practices of designing, implementing, and maintaining databases on personal computers. The course covers the fundamentals of relational database concepts, data modeling, query design, and reporting using industry-standard desktop database software such as Microsoft Access. Students will learn how to create and modify database structures, manage data integrity, build user-friendly forms and reports, and automate tasks using basic scripting tools. Emphasis is placed on hands-on projects that reinforce practical skills in organizing, storing, and retrieving data for small business and personal applications.
Recommended Textbook Microsoft Office Access 2013 Complete In Practice 1st Edition by Randy Nordell
Available Study Resources on Quizplus
10 Chapters
996 Verified Questions
996 Flashcards
Source URL: https://quizplus.com/study-set/2881
Page 2
Chapter 1: Creating a Database and Tables
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57328
Sample Questions
Q1) Which of the following statements about printing an Office Web Apps file is not true?
A) You can print files from Office Web Apps similarly to how you print files in Office.
B) The difference when printing in Office Web Apps is that the program creates a PDF file when you print a document.
C) You can print from only read-only mode.
D) The PDF format retains the document's original formatting.
Answer: C
Q2) In the Access Options dialog box,which category lets you control Design view for forms and reports?
A) General
B) Datasheet
C) Proofing
D) Object Designers
Answer: D
Q3) Cloud storage means you don't have to be tied to one computer.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Using Design View, Data Validation, and Relationships
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57329
Sample Questions
Q1) Which of the following statements is true about the Database Documenter tool?
A) It lets you select the level of detail displayed about the different objects in your database.
B) You can choose to see information about the property settings of fields and relationships of tables.
C) You can choose to see the property settings for controls and macro code attached to a form or report.
D) all of the above
Answer: D
Q2) Which of the following is a common problem that you might find in a poorly designed table?
A) having redundant data
B) having more than one value stored in a field
C) not having the ability to store the required data
D) all of the above
Answer: D
Q3) The goal of normalization is for each table to reach 1NF.
A)True
B)False
Answer: False
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Creating and Using Queries
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/57330
Sample Questions
Q1) Which of the following statements is true about importing XML data?
A) You can import an XML data file to append records to an existing table.
B) You can import an XML data file to create a new table.
C) If changes are made to the XML file after the import process is completed,the changes do not automatically care forward into the Access database.
D) all of the above
Answer: D
Q2) Which of the following can you use to create text files?
A) Notepad
B) Wordpad
C) Microsoft Word
D) both A and B
Answer: D
Q3) In HTML,which of the following is always used in an end tag?
A) p tag
B) tags
C) /
D) start tag
Answer: C
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Creating and Using Forms and Reports
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/57331
Sample Questions
Q1) Which of the following does the Image button insert?
A) embedded image
B) shared image
C) conditional formatting
D) tab control
Q2) Which of the following colors implies "go" or "continue"?
A) red
B) green
C) yellow
D) black
Q3) What rules should you follow when entering an expression into a control?
Q4) Which of the following is a common modification that users need to make to forms?
A) adjust the size and spacing of the text box and label controls
B) modify the font characteristics of the text boxes
C) change the border property
D) all of the above
Q5) The Image button inserts an embedded image.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Templates, Advanced Relationships, and Macros
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57332
Sample Questions
Q1) Which of the following Access date functions adds to a date?
A) DateSerial()
B) DateAdd()
C) DateDiff()
D) DatePart()
Q2) Creating a report in Layout view provides you with the most flexibility.
A)True
B)False
Q3) The Now()function retrieves the current date,including the time,from your computer.
A)True
B)False
Q4) Which of the following report sections prints column headings,page numbers,or dates at the top of every page?
A) Report Footer
B) Page Header
C) Page Footer
D) Group Header
Q5) What is a parameter report? Why are parameter reports useful?
Q6) What is a subquery? Why are subqueries helpful?
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Creating Advanced Queries and Reports and Using SQL
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/57333
Sample Questions
Q1) Which of the following runs when a database is first opened?
A) Open macro
B) AutoOpen macro
C) Exec macro
D) AutoExec macro
Q2) Which of the following is the most common type of program flow statement?
A) program flow statement
B) Action
C) Comment
D) Macro Builder
Q3) Which of the following events executes after the object/ control is clicked?
A) On Click
B) On Dbl Click
C) On Got Focus
D) On Enter
Q4) A stand-alone macro is a separate Access object that appears in the Navigation pane.
A)True
B)False
Q5) Why are junction tables important?
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Creating Advanced Forms
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57334
Sample Questions
Q1) When working with forms,Form view allows you to make changes to the form.
A)True
B)False
Q2) The Conditional Formatting Rules Manager only displays rules for one field at a time.
A)True
B)False
Q3) What is a control and how are they used on forms? Describe what bound,unbound,and calculated controls are and provide an example of each.
Q4) Which of the following report layouts displays fields in a row and column format?
A) columnar
B) tabular
C) justified
D) stepped
Q5) In Access,fields,labels,and buttons are called objects.
A)True
B)False
Q6) What does it mean to group,sort,and add totals to a report?
Q7) What is a split form and why is it useful?
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Integrating Applications
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/57335
Sample Questions
Q1) What is meant by the words compound criteria? How are the AND and OR operators used when defining a query?
Q2) How many criteria would you need in a query in order to find all of the employees who work as insurance agents in the Cameron Park branch who were hired after January 1,2014?
A)1
B)3
C)6
D)9
Q3) Which of the following is used to locate data in a database?
A)select query
B)summary query
C)Expression Builder
D)Design grid
Q4) To see the results of a query,you must run it.
A)True
B)False
Q5) The Count function finds the total value of a field.
A)True
B)False
10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Designing and Managing Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57336
Sample Questions
Q1) Which of the following record validation rules requires the user to enter a value into Field1 that is greater than Field2,and Field2 must have a value greater than 10?
A) ([Field1] is Null)XOR ([Field2] is Null)
B) [Field1] < > [Field2]
C) (([Field1] > [Field2])AND [Field2] >10))
D) none of the above
Q2) When you insert a new row between fields,the new row is inserted below the selected field.
A)True
B)False
Q3) How many parts are there in an input mask?
A) 1
B) 3
C) 5
D) 7
Q4) The process of verifying the accuracy,or integrity,of data is known as data integrity.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
11
Chapter 10: Customizing Access and Using Skydrive and Office Web Apps
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57337
Sample Questions
Q1) To add a new field to a table,on what must you click in the first cell?
A) Record Selector
B) form
C) Append Row
D) datasheet
Q2) Which of the following allows you to build or modify the basic structure or functionality of an object?
A) Design view
B) Datasheet view
C) External data
D) Ctrl+N
Q3) Which of the following helps you easily scan the records and fields in your database?
A) field type
B) launcher
C) gridlines
D) alternate row colors
Q4) Adding a filter to a second field is an OR condition.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12