Question 1

The following term applies to a collection of related records in a database
A)File
B)Layout
C)File.
D)Field

Accepted Answer

A

Question 2

This set of related data items is known as a
A)File
B)Record
C)Table
D)None of the above

Accepted Answer

A record is a collection of related data items, typically structured in fields, representing a single entity such as a person or a transaction.

Question 3

The framework for storing records in database is a
A)Form
B)Report
C)Query
D)Table

Accepted Answer

C

Question 4

The following command is used to search the record that satisfies the specified criteria
A)FOUND
B)SEARCH
C)GET
D)LOCATE

Accepted Answer

The answer of The following command is used to search...

Question 5

The data in a record is of the following types
A)four text fields and three numeric fields
B)two integer fields and five text fields
C)three text fields and four numeric fields
D)none of the above

Accepted Answer

The answer of The data in a record is of...

Question 6

A treelike structure of records in a database. Select the best fit for answer
A)Hierarchical database structure
B)Relational database structure
C)Multidimensional database structure
D)Sequential database access

Accepted Answer

A hierarchical database structure is characterized by a tree-like structure where records are linked in a parent-child relationship, making it the best fit for the description.

Question 7

The following language used by most of the DBMSs for helping their users to access data
A)High level language
B)Query language
C)SQL
D)4GL

Accepted Answer

The answer of The following language used by most of...

Question 8

What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.
A)Information Processing
B)Spreadsheet
C)Operating system
D)Database

Accepted Answer

A database is the largest collection of data stored in a computer, specifically designed to manage, store, and retrieve data efficiently. It is commonly used for keeping records, such as an address book of friends, making it the correct choice for this context.

Question 9

Which command is used to replace ?
A)REPLACE
B)REPLACE ALL
C)Add record from edit menu
D)All of above

Accepted Answer

The answer of Which command is used to replace ?
A)REPLACE
B)REPLACE...

Question 10

All of the following terms are related to computerized databases except which one?
A)Search
B)Sort
C)Field names
D)Record grab

Accepted Answer

The answer of All of the following terms are related...

Question 11

Need to see all the information from two tables on one form. Insert
A)A page break
B)A subform
C)A linked command button
D)None of the above

Accepted Answer

A subform is used to display data from a table or query that is related to data in another table or query, all within a single form. This is the correct way to see information from two tables on one form.

Question 12

What is the primary difference between a pivot table report and a cross tab query?
A)A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
B)You can't pivot a cross tab query
C)A cross tab query lets you group similar items. A pitot table report does not
D)None of above

Accepted Answer

A pivot table allows you to dynamically rearrange, sort, and filter data, which is not possible with a static cross tab query.

Question 13

The largest unit of a database is
A)A record
B)A field
C)A subfield
D)None of above

Accepted Answer

The answer of The largest unit of a database is
A)A...

Question 14

What's the best Access object for an invoice you'll mail to customers?
A)A report
B)A form
C)A table
D)All of the above

Accepted Answer

A report is the best Access object for creating an invoice to mail to customers because it allows for the formatting and printing of data in a presentable way, suitable for mailing.

Question 15

What is a Grouped Report?
A)A type of report that can be generated by the Report Wizard
B)A report that displays data that has been sorted in ascending or descending order
C)A report that displays data grouped by fields you specify
D)None

Accepted Answer

A Grouped Report is specifically designed to organize data based on certain fields specified by the user, making it easier to analyze related data.

Question 16

Which field allow to select items from drop down list?
A)An OLE field
B)A Memo Field
C)A lookup Field
D)A hyperlink field

Accepted Answer

A lookup field in databases is specifically designed to allow users to select items from a predefined list or a drop-down menu, making data entry easier and more consistent.

Question 17

What did the first Table Analyzer do?
A)Analyze the data in a set of flat files and automatically create a relational database system from that information
B)Provide a graphic way to design relational databases
C)Automate process of connecting tables to SQL Server
D)None

Accepted Answer

The first Table Analyzer analyzed the data in a set of flat files and automatically created a relational database system from that information. This tool was designed to help users transition from using simple flat file databases to more complex and efficient relational database systems by analyzing the existing data structure and relationships.

Question 18

Pivot Table reports are good for
A)Analyzing large amounts of data
B)Turning tables upside down
C)Breaking spreadsheet data into multiple worksheet
D)None of above

Accepted Answer

Pivot Tables are powerful tools in spreadsheet programs like Microsoft Excel, used for summarizing, analyzing, exploring, and presenting large amounts of data in a report format. They allow users to easily rearrange, sort, count, and group the data, making them ideal for analyzing large datasets.

Question 19

Which of the following are common ways to enforce data validation when entering data into an Access form?
A)Create an input mask to restrict the kind of value that can be entered in positions across the field.
B)Define a validation rule for that field
C)A and B
D)none of the above

Accepted Answer

Both creating an input mask and defining a validation rule are common methods to enforce data validation in Access forms. An input mask restricts the format of the data entered, while a validation rule specifies criteria that the data must meet.

Question 20

The purpose of the Add-in Manager is to
A)Create macros and automate data processing
B)Add or remove data in an existing database
C)Add or remove templates, macros, and wizards
D)All of above

Accepted Answer

The Add-in Manager is primarily used to add or remove templates, macros, and wizards, enabling users to customize their software environment according to their needs.

Quiz 1: Database Fundamentals and Management

The following term applies to a collection of related records in a database

This set of related data items is known as a

The framework for storing records in database is a

The following command is used to search the record that satisfies the specified criteria

The data in a record is of the following types

A treelike structure of records in a database. Select the best fit for answer

The following language used by most of the DBMSs for helping their users to access data

What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.

Which command is used to replace ?

All of the following terms are related to computerized databases except which one?

Need to see all the information from two tables on one form. Insert

What is the primary difference between a pivot table report and a cross tab query?

The largest unit of a database is

What's the best Access object for an invoice you'll mail to customers?

What is a Grouped Report?

Which field allow to select items from drop down list?

What did the first Table Analyzer do?

Pivot Table reports are good for

Which of the following are common ways to enforce data validation when entering data into an Access form?

The purpose of the Add-in Manager is to