Answers Introduction to Information Technology - EL3701Summary

Introduction Answers

25 verified answers

Free Preview

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

file.

paragraph.

text field.

table.

Free Preview

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

A simple query

retrieves data from one table in a database.

can search only a few records.

sorts records but cannot group them by category.

can be used to answer any simple question about a set of data.

When is it a good time to create a database?

when you have a long list of contacts you need to save and refer to

when you have a short list of contacts you need to save and refer to

when you have a small volume of data you need to track and calculate

when you have large volumes of data you need to track and analyze

A spreadsheet is the best choice to

keep track of employees’ work hours and salary for computing the payroll.

identify voters who will receive political literature for the party to which they belong.

keep track of the location of products in the warehouse using department and item codes.

keep track of customers and their product preferences to send the correct catalogues to them.

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

OrderDate

CustomerType

OrderID

CustomerID

Samantha’s database contains a table of student scores and another table with student schedules. How can Samantha use this information to help her decide how to group students for review class?

She can use a simple query to sort the scores in ascending order.

She can use a simple query to group student scores by name.

She can use a complex query linking student scores by name and available study period, then sort the data and group it.

She can use a complex query to retrieve all scores below 65.

When creating a database, in which step do you add foreign keys to tables?

when creating relationships within tables

when creating relationships between tables

when logically organizing data into tables and fields

when determining what data to store

What is the first step in creating a database?

creating relationships within tables

creating relationships between tables

determining the number of tables to create

determining what data will be stored

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

average

count

order

maximum

Which statement is true?

An employee list can give the departments and job titles of employees.

A product list can include names and addresses of buyers of the product.

A medical record can include consumer buying behaviors of prescriptions.

A market research report can give names of employees of a company.

The unique identifier for each record in a database table is called the

record ID.

ID number.

primary key.

row number.

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

a hierarchical form

a switchboard

a flat form

a custom dialogue box

A piece of the Student Info table in the Harris Community College database is shown below. What information could an instructor find by querying this table in the database?ID#FirstNameLastNameStudentMajorAddress1BethBorskyArt55 Winsap Ln.2HankHoffChemistry7 Gosling Rd.3StephanieSerlePolitical Science136 Finley Ave.4RafiRohrArt55 W. 79th St.

a list of students over the age of 35

a list of students grouped by major

a list of students who got over a 90% on the entrance exam

a list of all male students

Which collection of fields demonstrates a logical organization of information in a table that tracks product data?

Product ID, Product Name, Price, Customer Address

Product ID, Product Name, Product Description, Price

Customer Name, Favorite Product, Customer Address

Customer Name, Product Name, Order Total

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.

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.

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

A report has a column of totals, with each total adding to the cell above it. What kind of calculated figure is this?

a percentage

a sum

a grand total

a running sum

A store manager needs to run a report of last month’s sales. The manager would like the report to highlight products that sold over a quantity of twenty-five for the last month. Which formatting options would accomplish this?

inserting an image

choosing a plain font for the title

applying conditional formatting

using a theme

Did you find these answers helpful?

Introduction Answers

More from this Course

TRY EDGENUITY HACKS