Microsoft Access Database Management System! Trivia Quiz
14 Questions
| Total Attempts: 46
.
Questions and Answers
- 1.Which of the following is a complete list of the Access objects?
- A.
Queries, reports, forms
- B.
Tables, forms, queries, reports
- C.
Records, queries, reports, forms
- D.
Tables, forms, queries
- 2.When you sort records in A-Z order, you are applying a(n) __________ sort
- A.
Filtered
- B.
Descending
- C.
Ascending
- D.
Non-existent
- 3.When you build a query, you must write __________ to tell the query which records to retrieve.
- A.
Tables
- B.
Functions
- C.
Criteria
- 4.It's possible to build reports with information from?
- A.
Both tables and queries
- B.
Tables
- C.
Queries
- D.
Reports
- 5.A __________ query allows you to perform calculations with your data.
- A.
Calculator
- B.
Sum
- C.
Totals
- D.
Mathematical
- 6.Which of the following data-types can you use for characters and numbers?
- A.
Date
- B.
VarChar2
- C.
Char
- D.
Number
- 7.A __________ is a drop-down list you can add to your form.
- A.
Drop-down-box
- B.
Text-box
- C.
Combo-box
- D.
List-box
- 8.__________ let your users perform common form actions with just one click.
- A.
Command Buttons
- B.
Action Buttons
- C.
Footers
- D.
Drop-down menus
- 9.A database that understands how information is connected is called __________.
- A.
A relational database
- B.
An Access database
- C.
A linked database
- D.
A connected database
- 10.In Access, rows are referred to as __________, and columns are referred to as __________.
- A.
Objects, types
- B.
Lines, columns
- C.
Fields, records
- D.
Records, fields
- 11.__________ allow you to enter data without typing records directly into tables.
- A.
Queries
- B.
Forms
- C.
Reports
- D.
Menus
- 12.Open objects are listed in the __________.
- A.
Navigation Bar
- B.
Document Tabs Bar
- C.
Fields Pane
- D.
Column Pane
- 13.Microsoft Access is accessible to the following systems: Microsoft Excel, SQL, Visual Basic.
- A.
False
- B.
True
- C.
None of the Above
- D.
Maybe
- 14.Setting the __________ for a field sets a rule about how many letters, numbers, punctuation marks, or spaces can be entered in a field.
- A.
Validation rule
- B.
Row height
- C.
Character limit
- D.
Data rule
Microsoft Access is a tool that helps one store and analyzes large amounts of information. This tool forms interface that allows users to enter information in a graphical form and have that information transparently passed to the...
Questions: 10 | Attempts: 18441 | Last updated: Nov 16, 2020
-
Sample QuestionA _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
.
Questions: 10 | Attempts: 16799 | Last updated: Dec 4, 2020
-
Sample QuestionAn organized collection of logically related data is known as?
Getting some basic computer knowledge is something that most people are required to have in any business field. There are different computer applications used daily. How good are you when it comes to MS Access? Take up the quiz...
Questions: 50 | Attempts: 14540 | Last updated: Dec 22, 2020
-
Sample QuestionWhich object is used to create a form?
Back to top