266 Final Study Guide pt1

If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View?

"Consulting"

For a one-to-many relationship in the Access Relationships window, how can you tell which table is the "many" table?

An infinity symbol identifies the "many" table.

If you use an aggregate function in a query to determine the average values in a Bonus field, what default field name does Access use for the column with the calculations?

AvgOfBonus

_________________________ describes the large volume of data produced by every digital process, system, sensor, mobile device, and even social media exchange.

Big data

In the Pitt Fitness database, which of the following attributes belongs in the Customers table?

BirthDate

In the Pitt Fitness database, which attribute uniquely identifies each class?

ClassID

In the Pitt Fitness database, which table relates classes and instructors?

ClassInstructors

In the Pitt Fitness database, you can determine which instructor is assigned a particular class by looking in the ____________________ table.

ClassInstructors

In general, what should be in place before you select fields from more than one table in Access Query Design View?

Clear the checkmark from the Rating field's Show check box.

The Access query design grid contains the ProductID, ProductName, and Rating fields. How can you omit the Rating field from the query results but use it to set a criterion for the query?

Clear the checkmark from the Rating field's Show check box.

In Access Query Design View, how do you add the Total row to the query design grid?

Click the Totals button on the Query Tools Design tab.

Which of the following will be an entity in the JC Consulting database?

Clients

Which of the following Access functions can you use to return the number of records in a group of records?

Count

What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server?

DBMSs

Which of the following is a drawback of flat files?

Data partitioned into several separate files can be difficult to summarize.

In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate?

Date() - [DueDate]

Which of the following is a technique for increasing the speed of Access queries?

Delete field lists that are not needed for the query.

Which of the following fields would be the best candidate for a primary key field in a table of employee data?

EmployeeID

An attribute is known as a row in most databases.

False

To select data from more than one table at the same time, you need to perform a make-table query.

False

Which of the following is a responsibility of a database administrator?

Improving the efficiency of a database

Which of the following statements is correct?

In a flat-file environment, data is partitioned into several disjointed systems, lists, and files.

In the Pitt Fitness database, how can you determine the number of classes offered on Tuesday?

In the Classes table, count the occurrences of Tuesday in the Day column.

In the Pitt Fitness database, which of the following is an attribute in the Instructors entity?

Instructor City

Which of the following is a popular software stack?

LAMP

Which of the following expressions in Access Query Design View creates a computed field named MonthlySalary using a value from the Salary field?

MonthlySalary: [Salary] / 12

In relational algebra, what command is used to identify certain columns?

PROJECT

Based on the following table, which relational algebra command creates a new table named CustState containing the fields CustomerNum and State?

PROJECT Customer OVER (CustomerNum, State) GIVING CustState

Based on the following notation, which relational algebra command would list all information from the table concerning the customer with numeric CustomerNum 260? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

SELECT Customer WHERE CustomerNum=260 GIVING Answer

Which of the following is a popular relational database management system?

SQL Server

In the Sports Physical Therapy database, which table stores the date of an interaction between a patient and a therapist?

Session

In the Sports Physical Therapy database, which attribute uniquely identifies each therapy session?

SessionNum

In an Access query, how can you list records in A-Z order by last name?

Set an ascending sort order on the LastName field.

In the Pitt Fitness database, what can you learn by examining the ClassInstructors data?

Some classes use more than one instructor.

Which of the following is a reason to store business data in a database rather than a spreadsheet?

Spreadsheets have limited data sharing and security features.

Microsoft Access uses Query Design View as a QBE.

True

Redundancy makes changing data more cumbersome and time-consuming.

True

Which of the following is NOT true about a relation, otherwise known as a two-dimensional table?

Two or more columns can share the same name.

In the Sports Physical Therapy database, you determine the description of the therapy a patient is receiving by finding the TherapyCode for the patient in the Session table, and then _____.

looking up the TherapyCode in the Therapies table

What type of Access query creates a new table using the query results?

make-table

In Access, if you want to be able to enter different criteria each time you run a query, create a(n) _____ query.

parameter

In Access, what uniquely identifies a row in a table?

primary key

If you are sorting records by more than one field, which field is the first field that is evaluated for sorting purposes?

primary sort key

A _____ is a question about the data structured in a way that the DBMS can recognize and process.

query

Which term can be described as the duplication of data and storing data in multiple locations?

redundancy

A(n) _____ can store information about multiple types of entities and the relationships among the entities.

relational database

The field you use to sort records is called the _____.

sort key

Which database term refers to a row in a table?

tuple

If you use ____________________ criteria, each criterion must be true for a record to be selected .

AND

What happens when you run a select query in Access?

Access selects current data from underlying tables.

How are aggregate functions different from other types of functions?

Aggregate functions make calculations on groups of records.

Which of the following tasks is a data analyst likely to perform?

apply an algorithm to find sales trends

What type of query could you run to remove records with a product ID of 702 from the Products table?

delete query

Which of the following is a visual way to represent and analyze a database?

entity-relationship (E-R) diagram

According to the Bureau of Labor Statistics, what is the job growth outlook for database administrators?

faster than average

What do you call the field used to join two tables on the "many" side of a one-to-many relationship?

foreign key field

Which of the following is a screen object used to maintain and view data from a database?

form

Which of the following are screen objects used to maintain, view, and print data from a database?

forms

In the Access QBE, where do you specify criteria for a query?

in the Criteria row of the query design grid

Which of the following is a problem that data redundancy causes?

increased data errors and inconsistencies

Which type of rule prevents the creation of orphan records?

integrity constraint

Microsoft Access is well-suited to which of the following cases?

A few trusted users work with the database at the same time.

An entity is a person, place, event, item, or other transaction for which you want to store and process data.

True

If you are creating a computed field that adds 10 percent to the UnitPrice field, how do you enter the UnitPrice field name in the expression?

[UnitPrice]

What do two tables use to link related records from each table?

a common field

What type of functions are Count, Sum, Avg, Max, and Min?

aggregate functions

A(n) _________________________ is a set of rules, calculations, and assumptions used to solve a problem.

algorithm

A ____________________ in a record is the result of a calculation using data from the rest of the record .

computed field

In an organization, who is usually responsible for improving databases to provide efficient and effective access to their information?

database administrator (DBA)

In Access a (n) _____ query permanently removes all the records from the selected table(s) that satisfy the criteria entered in the query.

delete