Answers VA-Information Technology Fundamentals BQuery Data

Unit Test Answers

2 verified answers

Free Preview

The process of bringing data or a file from one program to another is called

exporting.

importing.

querying.

reporting.

Free Preview

Which is the best description of the difference between bound and unbound forms?

Bound forms are similar to hierarchical forms but pop up in a separate window, while unbound forms are flat forms that do not have subforms.

Bound forms are linked to a table or query, while unbound forms are not linked to a table or query but are used to operate and navigate a database.

Bound forms perform tasks based on user input, while unbound forms navigate between multiple forms.

Bound forms are the basic interface for inputting information into tables or queries, while unbound forms have one or more subforms within the main form.

Which field would best function as a primary key for a table that tracks orders?

OrderDate

CustomerType

OrderID

CustomerID

What is a dynamic tool for storing, retrieving, managing, and analyzing related data?

a spreadsheet

a database

a network

a table

Serena, an analyst at an environmental agency, wants to prepare a report using data from the Car Emissions database. In her report she plans to include written analysis as well as circle graphs. To best complete this task, she can

export the query results from the database to a spreadsheet, then export the graph to a document.

export the query results into a word processing document, then import the graph into the same document.

export the graph into a spreadsheet.

export the query into a word processing document.

Which is a preformatted file that can be used to standardize the appearance of exported data?

a database

a spreadsheet

a report

a template

What is the difference between a sort tool and a filter tool?

A sort tool is used by end users, and a filter tool is used by database administrators.

A sort tool is used by database administrators, and a filter tool is used by end users.

A sort tool arranges records by field but hides them from view, and a filter tool hides records that a user does not want to view when focusing on specific records.

A sort tool hides records from view but does not remove them from a database, and a filter tool removes unwanted records from a database.

Which is an unbound form with menu options for navigating a database?

a hierarchical form

a switchboard

a flat form

a custom dialogue box

What are two ways to create forms in Base to search data?

Use a wizard, or use Design View.

Use a wizard, or use a report.

Use a report, or use Design View.

Use a report, or use a table.

When query data is exported to a document it is most effectively displayed in a

file.

paragraph.

text field.

table.

A Products table and an Orders table have several linked records that are joined by a cross-referencing table named ProductsOrders. What kind of table relationship do these tables demonstrate?

one-to-one

one-to-many

many-to-many

many-to-none

What does a sort tool enable you to do in a database?

remove irrelevant data from a form

hide irrelevant data in a form

arrange records by number of typos entered in a field

arrange records by field in a form

Which database can be used on a desktop computer?

an online dictionary

an online shoe company that has seven hundred fifty thousand customers

the mailing information of the 432 voters in a city council member’s district

the online banking information of the customers of a national bank

Which is an example of a bound form?

custom dialogue form

navigation form

switchboard form

data entry form

Which function can be used to find the date of the last payment made on a customer account?

average

count

order

maximum

Which query performs calculations such as sum, average, and count, and rearranges the data so it is easier to view and analyze?

duplicate query

action query

select query

crosstab query

Why is it uncommon for users to perform searches directly in database tables?

Users are discouraged from interacting directly with tables because they might confuse tables with spreadsheets.

Users are discouraged from interacting directly with tables because this may result in unintended changes to source data.

Users do not have the technical skills required to perform searches directly in database tables.

Users do not have the permissions required to perform searches directly in database tables.

Mr. Stevens is the principal of a high school. Why might he want to export data from a database of students’ exam scores?

to create a presentation using other software on how students’ scores have changed throughout a semester

to view the student data in a new database

to query the database and sort students into groups according to their scores

to append additional student records to the database

A report titled “Employees in Company A” contains the names of employees in descending alphabetical order, with the number of years each employee worked at the company. Which statement is true?

The report is sorted only because it organizes the names of the employees in alphabetical order.

The report is sorted only because it gives information about employees by number of years of employment.

The report is grouped only because it organizes the names of the employees in alphabetical order.

The report is grouped only because it gives information about employees by number of years of employment.

A Student table and an Address table contain one linked record. What kind of table relationship do these tables demonstrate?

one-to-one

one-to-many

many-to-many

many-to-none

Which is an advantage of using a flat file instead of a relational database?

A flat file is easier to set up.

It is easier to assign foreign keys to a flat file.

A flat file reduces storage of redundant data.

A flat file reduces storage of irrelevant data.

Which describes a query?

A query organizes, summarizes, and presents data in an easy-to-view format.

A query allows for retrieval of information from multiple tables.

A query is a way to modify data in tables.

A query is a sorted report.

What is a primary key?

a field that uniquely identifies a record in a table

a field that uniquely identifies a table

the first security key entered by a database user

the first security key entered by a database administrator

Which statement is correct?

Flat files use foreign keys to uniquely identify tables.

Flat files use foreign keys to secure data.

A foreign key is a primary key in another table.

A foreign key uniquely identifies a record in a table.

Jorge is creating a directory of student phone numbers and addresses. He performed a query to obtain the data he will include. He now needs to arrange the data alphabetically by last name, from A to Z. Which sort function should he use?

Sort Ascending

Sort Descending

Filter

Reapply Sort

Did you find these answers helpful?

Unit Test Answers

More from this Course

TRY EDGENUITY HACKS