Com Sci 113 Final

Ace your homework & exams now with Quizwiz!

T or F? All database objects should be tested before the database is deployed.

True

T or F? An input mask is used to consistently format data.

True

Sort

A method of listing records in a specific sequence (such as alphabetically).

In the Round function, if you leave the precision level blank, Access will default to how many decimal places?

0

In Office 2016, Access provides how many tools for creating forms?

14

What is the result of the following expression? 2*5+8-6/2

15

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?

53

How many characters can be stored in a field with a Long Text data type?

64,000

Comparison operators

<>, =, >, <

Examples of filter criterion.

<>4, >2000, ="Fred"

Which of the following comparative operators CANNOT be used in a data validation rule?

=<

Which of the following is NOT a valid comparison operator?

=>

Which of the following statements about the Round function is false?

A Round function with a precision of 1 rounds to the nearest integer.

Database

A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported.

Database

A collection of data organized as useful information.

Record

A collection of fields

Table

A collection of records

Record

A complete collection of all fields about one entity.

Object

A component which makes the database function.

Relationship

A connection between tables using a common field.

Relationship

A connection between two tables using a common filed.

An illustration of a one-to-many relationship would be:

A customer may have more than one account in an accounts table.

ACCDE

A database format that only allows data entry.

Foreign key

A field in one table that is also the primary key of another table.

Selection Filter

A filtering method that displays only records that match selected criteria.

Filter by Form

A filtering method that displays records based on multiple criteria.

Datasheet View

A grid that enables you to add, edit, and delete the records of a table.

What is SharePoint?

A host server

What is the most important thing you need if you are going to create a Web app?

A host server

Which of the following statements is true?

A last name is an example of a common field to group by.

Object

A main component that is created and used to make a database function, such as a table or form.

When creating a calculation, which of the following would be identified as an error by Access?

A missing colon in the expression (for example: TotalHours [OTHours]+[RegHours])

Oracle

A more advanced DBMS.

Which of the following statements is false?

A null value means that the value is zero for any type of a field.

AutoNumber

A number that automatically increments each time a record is added.

Field

A piece of information stored in a table, such as a company name or city.

Template

A predefined database that includes professionally designed tables, forms, reports, and other objects

Query

A question you ask about the data in your database.

Criteria Row

A row in the Query Design view that determines which records will be selected.

Application Part

A set of common Access components that can be added to an existing database.

Database Management System (DBMS)

A software system that provides the tools needed to create, maintain, and use a database.

Macro

A stored set of commands.

Which statement about a totals query is true?

A totals query may contain several grouping fields and several aggregate fields.

Compact and Repair Database

A utility that makes a database smaller and fixes errors.

Design View

A view which displays an object's structure.

Datasheet View

A way of displaying data in a row/column grid.

Report

A way of displaying data in which the data cannot be changed.

Selection Filter

A way of limiting the number of records displayed.

Boolean operators

AND, OR, NOT

DBMS (Database Management System)

Access is one example.

Which of the following cannot be extracted by the DatePart function?

All of the above (i.e., other 3 answers) can be extracted - Year - Month - Weekday

Which of the following can be added to a totals query?

All of the above can be added to a totals query: - Conditions - Grouping fields - Aggregate functions

Which of the following cannot be used in a calculated field?

All of these CAN be used in a calculated field - The number 12 - An asterisk (*) - [HoursWorked] (a field in the current database)

Navigation Pane

An Access interface element that organizes and lists database objects in a database.

Form

An Access object that simplifies entering, modifying, and deleting table data.

Module

An advanced object within VBA.

Navigation Pane

An interface that lists Access objects.

Report

An object that contains professional-looking formatted information from underlying tables or queries.

Table

An object used to store data, organizing data into columns and rows.

Report

An object which displays formatted information in a professional manner.

Cascade Update Related Fields

An option that directs Access to automatically update all foreign key values in a related table when the primary key value is modified in a primary table.

Which of the following would be matched if you use a Selection filter's exact match option for the name Ann?

Ann, ANN, and ann

To add a predefined table into an exiting database, you should use which of the following?

Application part

Query

Asks a question of your data

All of the following are suggested guidelines for table design except:

Avoid date arithmetic.

Which of the following utilities is used to recover in the event of loss or damage?

Back Up Database

To create a database from a template you would use which view?

Backstage

The query wizard is best used to create what kind of query?

Basic Queries

Which of the following is NOT a valid condition for an IIf function?

Between 10 and 22

Which of the following would NOT be done using an aggregate function?

Calculating the payment amount of a loan

Which of the following determines how the field names can be made more readable in table and query datasheets?

Caption property

Field

Category of information

Which of the following is true regarding table views?

Changes made in Datasheet view are automatically saved when you move the insertion point to a different record.

Sort

Changes the order of how records are displayed.

Field property

Characteristic of a field that determines how it looks and behaves.

Record

Complete set of all the fields about one person, place, event, or concept.

Record

Complete set of fields

Could be used in a selection filter

Contains "Bill"

Multitable query

Contains two or more tables, enabling you to take advantage of the relationships that have been set in your database.

Examples of Data Types.

Correct Answer AutoNumber, Short Text, Number

Which of the following is not one of the three methods for creating a database?

Create a blank cloud database

Which of the following features help to insure that improper information is not entered in a field?

Data validation

Which of the following is NOT a good reason for using a form for data entry?

Data you enter in a form must then be transferred to the table

Which of the following functions require no parameters?

Date Function

Which of the following views provides you with the most flexibility in modifying forms and reports?

Design View

Data Type

Determines the type of data that can be entered and the operations that can be performed on that data.

Report

Displaying data in a way that the data can't be edited.

Filter

Enables you to specify conditions to display only those records that meet certain conditions.

Which of the following conditions is available through a Selection filter?

Equal condition

Which of the following is not true of an Access database?

Every table in a database contains the same number of records as every other table.

T or F? A function is a predefined computation that is used for simple calculations.

False

T or F? A parameter query is not a type of select query.

False

T or F? All aggregate functions can be used with any field type.

False

T or F? Although you can link to external data, it is not recommended.

False

T or F? As long as your data is accurate there is no real need to print preview your reports.

False

T or F? If a field is found in a query then it must be included in any report based on that query. If you do not want the field displayed, you can set its view property to hidden.

False

T or F? If a sort has been added to a table it takes precedence over a sort applied to a form even if you are in form view.

False

T or F? If you used a lookup field for a field named State, the book recommends that you have fifty menu options available to anyone doing data entry.

False

T or F? It is best when designing a query to add all the fields from a table in case you need them later.

False

T or F? It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

False

T or F? Just as with forms, you can add, edit, or delete data in a report.

False

T or F? Logical operators only work with text and numbers, not dates.

False

T or F? Multitable queries inherit their relationships and you cannot change those in the query. You need to open the Relationships windows to make any changes.

False

T or F? Reports cannot be based on parameter queries.

False

T or F? Text you add to the criteria row in a query is case sensitive, so be careful or you may get unexpected results.

False

T or F? The easiest way to find information is to search the table directly.

False

T or F? The first step in creating a query is selecting the fields you need.

False

T or F? The only people who really need to test new forms are the end users.

False

T or F? The rate argument in the PMT function always uses the annual rate.

False

T or F? The sort order in a report's source overrides any sort order applied to the report.

False

T or F? There is no way to make sure that a record cannot be deleted.

False

T or F? To create a parameter query, you would put the desired text in parenthesis in the criterion row of the desired field.

False

T or F? To help limit the file size, the textbook recommends that all symbols in an input mask not be stored with the data.

False

T or F? Using a template to create a database is not an effective use of time because of all the modifications you need to make so the database will fit your needs.

False

T or F? Using the Back Up Database utility only saves the structure of the database, not the content.

False

T or F? You can edit data in form layout view.

False

T or F? You can enter an expression in the Expression Builder by either typing the expression manually or by right-clicking the expression.

False

T or F? You can only sort records by one field.

False

T or F? Your birthday would be a good candidate for a primary key.

False

How many reporting tools does Access 2016 provide?

Five

When creating a calculated field in a query, what common error will NOT give you a direct indication that there is a problem?

Forgetting the order of operations

Which of the following objects is an example of an Access object?

Form

Which of the following is true for the Query Wizard?

No criteria can be added as you step through the Wizard.

The string of characters !\(999")"000\-0000;0;_ represents which of the following?

Input mask

What is not true about the hyperlink data type?

It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work

Where does the Total row of an aggregate function display its results?

Last row in Datasheet view

Examples of field names.

LastName, FirstName, CellPhone.

The simplest view you can use to modify control widths in a form is:

Layout view

Which of the following statements is false?

Layouts for forms and reports are the predefined sets of colors, fonts, and graphics

The main reason to set a field size in Access is to:

Limit the length of values in a table.

Filter

Limits the amount of data displayed.

Sort

Listing records in a specific sequence.

A field with a limited number of values is well suited for what type of field?

Lookup field

Which of the following enables users to choose from a list of options while entering data?

Lookup field

Which of the following provides uniformity and consistency of data?

Lookup field

What objects will NOT use the caption instead of the field names?

Macros

Which of the following CANNOT be adjusted in the Property Sheet?

Mathematical expression

If you need to send a report to a user who does not have Microsoft Office available, which of the following file formats would be the best choice to ensure it can be opened?

Portable Document Format (PDF)

When adding date criteria to the Query Design view, the dates you entered must be delimited by:

Pound signs (#).

Use the ............................ to see exactly what the printed report will look like before printing.

Print Preview

Simple Query Wizard

Provides a step-by-step guide to help you through the query design process.

A report can be made from one or more tables or a query. The object(s) that a report is based on is known as the:

Record source

You edit several records in an Access table. When should you execute the save command?

Records are saved automatically; the save command is not required

What is a primary reason for setting up a default value?

Reduce data entry time

Which of the following statements about reports is false?

Reports are primarily used to modify data.

AND Condition

Return only records that meet all criteria.

OR Condition

Returns records meeting any specific criteria.

Referential Integrity

Rules in a database that are used to preserve relationships between tables when records are changed.

Query

Selecting, organizing, sorting and filtering fields from one or more tables.

If you want to calculate aggregate statistics about graduation rates for students in a collage database, which of the following would provide the LEAST useful information if you were to group by it?

Social Security Number

Examples of Primary keys.

Social Security Number, Student ID, AutoNumber.

How would you sort or filter records in a field that begins with both numbers and letters so that the records which begin with numbers appear before the records that begin with letters?

Sort ascending

Wild Card

Special character that can represent one or more characters in the criterion of a query.

A parameter query enables you to:

Specify criteria for a field when you run the query.

Which of the following statements is false?

Stacked layouts are more common for reports because they use less paper when printed.

Table

Stores all your data

Objects open in their own area under the Ribbon.

Tabbed Documents interface

Where is data in a database stored?

Table

A query's specifications as to which tables to include must be entered on the:

Table row of the query design grid.

Primary key

That which uniquely identifies records in a table.

T or F? Access provides a wizard for easily importing Excel data into Access.

True

In order to summarize data in a report and override the sort order of the record source you would use:

The Group, Sort, and Total Pane

Which of the following is NOT a data validation technique?

The Round function

Which of the following about the Total row in Query design is false?

The Total row applies only to non-numeric fields

It is more efficient to make a copy of an existing query rather than to create a new query when which of the following is true?

The existing query and the new query use the same tables and fields.

Primary Key

The field (or combination of fields) that uniquely identifies each record in a table.

Which of the following fields is least likely to be set to required?

The name of an emergency contact for a patient in a doctor's database

Table

The object which actually stores the data.

All of the following statements are true about creating a database except:

The objects provided in a template cannot be modified.

When entering, deleting, or editing input masks:

The table must be in Design view

Null

The term Access uses to describe a blank field.

Data Redundancy

The unnecessary storing of duplicate data in two or more tables.

When would you use the Date function?

To display the current date.

When using the Lookup Field Wizard, how wide should the columns be?

To display the longest value

T of F? A good practice is to make backups of your databases on different storage devices.

True

T or F? <<Rate>> is an example of an argument.

True

T or F? A multiple items form shows more than one record at one time instead of the one record which is normally display in a form.

True

T or F? A primary key can be a combination of several fields.

True

T or F? A totals query allows you to see only the results of aggregate functions, not the detail.

True

T or F? Access allows for the creation of custom input masks.

True

T or F? Between [Enter Start Date] AND [Enter End Date] is a valid statement to use in a parameter query.

True

T or F? Creating a database from a template can help you get started more quickly.

True

T or F? Data cannot be changed in Report view.

True

T or F? Data entered in a query is actually stored in the underlying table(s).

True

T or F? Database designers can disable all but the form view to protect the form's design and layout.

True

T or F? Filters do not delete data or records.

True

T or F? If you are not using a totals query, then you must display the Totals row in a query if you want to use aggregate functions.

True

T or F? If you see plus signs (+) next to records in Datasheet view then you know that two or more tables are related.

True

T or F? If you want to resize just a few controls on a form they must be removed from the Layout control.

True

T or F? If you want to see the results of several aggregate functions for one field, you would add the field in the Totals query several times.

True

T or F? In a parameter query, if you do not specify a comparison operator, Access will assume equal to.

True

T or F? In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

True

T or F? In the Round function, the precision cannot be a negative number.

True

T or F? It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

True

T or F? It is permissible to use the percent (%) sign when entering the interest rate in the PMT function

True

T or F? It is useful, at times, to add the same field to a query several times.

True

T or F? Mailing labels are considered reports in Access 2016.

True

T or F? One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

True

T or F? Reports can draw data from tables or queries.

True

T or F? Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

True

T or F? Some functions have optional arguments.

True

T or F? Storing the options used in a lookup filed in a separate table makes adding options easier.

True

T or F? Tables are a good source for data in a lookup field.

True

T or F? The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

True

T or F? The Date function calculates the current date.

True

T or F? The DatePart function always returns a number.

True

T or F? The Enforce Referential Integrity box should normally be checked.

True

T or F? The Expression Creator tool helps you create complex expressions.

True

T or F? The Total row, when using aggregate functions, displays both the total and the individual records.

True

T or F? The default sort order for a table is by its primary keys.

True

T or F? There might be times when you want to add the same field to a query several times.

True

T or F? Using Filter by Form enables you to filter on multiple criteria.

True

T or F? Using the Compact and Repair Database utility on a regular basis is good practice.

True

T or F? When creating a multitable query from scratch only include related tables in your query.

True

T or F? When you change the lookup field's source table, the options will be updated when the user tries to change data in the future.

True

T or F? You can add aggregate functions to calculated fields.

True

T or F? You can add conditions to a Totals query.

True

T or F? You can add multiple levels of grouping to a Totals query.

True

Primary Key

Uniquely identifies a record

Which of the following is not recommended as a professional way of styling a form?

Use several fonts to indicate different types of data

SQL

Used in several database programs.

VBA

Used to create modules.

Caption Property

Used to create more understandable label than a field name that displays in the top row in Datasheet view and in forms and reports.

Form

Used to enter data

Template

Used to jumpstart your database.

Which method of creating a database demands the least amount of expertise in Access?

Using a template

Comparison Operator

Using the greater than (>), less than (<), greater than or equal to (>=), and less than or equal to (<=), etc. to limit query results that meet these criteria.

Which of the following is not a common mistake when creating calculated fields?

Using the wrong fields

Form

Using this is the normal way of entering data.

Examples of field properties.

Validation Rule, Field Size, Caption

Which feature limits the data that is allowed to be entered into a field?

Validation rule

Design View

View that enables you to create and modify a table design.

What is NOT critical when you are first designing a database?

What the field names will be

One-to-many relationship

When the primary key value in the primary table can match many of the foreign key values in the related table.

Cascade Delete Related Records

When the primary key value is deleted in a primary key table, Access will automatically delete all foreign key values in a related table.

When is the criterion entered in a parameter query?

When the query is run

RAM

Where most Office programs store their files while the user is working.

With respect to importing data into Access, which of the following statements is true?

You can assign a primary key while you are importing Excel data.

Checking the Cascade Delete Related Records checkbox assures that ...................

all records will be deleted in related tables if you delete the primary key in the primary table

One reason to begin with a template is that you do not have to .................

create as many objects

To move a field you ................

left-click the column heading, then drag the field to where you want it

The first step to resizing a column in datasheet view is to move the pointer until it looks like a ..................

two-headed arrow and then click

When you are prompted to enter a value when you run a query which includes a calculated field, you probably ........................

typed a field name incorrectly

Which of the following statements is true?

you can group records to show a list of properties by state


Related study sets

SSAT Upper Level Vocabulary Words, SSAT

View Set

unit 2 Cut, Copy, Paste, Find, and Replace

View Set

The Masters III: Michelangelo Quiz 100%

View Set

Contracts (Chapter 9) Quiz Question

View Set

Chapter 16 Human Growth and Development

View Set

Manuel Transmission Final Exam Review

View Set