Com Sci 113 Final
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
