Computer Concepts II Access
In Access, field names cannot contain digits.
false
In Access, the columns in a table are called records.
false
The contents of the Report Footer section print once at the bottom of each page and often contain a date and a page number.
false
The data in a report can come from one or more tables but the data in a form only can come from one table.
false
To calculate the total of amount paid values, click the Totals button on the Format tab and then click Totals on the list of available calculations.
false
To create a top-values query, use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.
false
To open a form in Form view from the Navigation Pane, right-click the form and click Form View on the shortcut menu.
false
Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.
false
When you enter text data in a criterion, you must enclose the text in quotation marks.
false
When you sort data in a query, the records in the underlying table are actually rearranged.
false
When you sort data, duplicates are not included.
false
When you use a split form, you only can add records using the simple form.
false
When you view a report in Print Preview, you can make changes to the report.
false
You cannot create a report for a query.
false
You cannot use the Report Wizard to create a report on multiple tables.
false
A(n) ____________________ contains a specific piece of information within a record
field
To find duplicate records in a table, use the _____ Query Wizard.
find duplicates
This is the field in one table whose values are required to match the field in another table (main table).
foreign key
The ____ section appears at the bottom of the form and often is empty.
form footer
The ____ section appears at the top of the form and usually contains the form title.
form header
____ shows the form on the screen and allows you to use the form to update data.
form view
To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.
format
In Access, table and field names can be up to ____ characters in length.
64
If the Account Number field in a record always should display the three characters in the account number in uppercase, then the correct format for this field is ____.
>
To specify that entries in the current due field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box.
>=0 and <=30000
What is the purpose of a control layout? Explain the two types of control layouts that Access offers.
A control layout is a guide that aligns the controls to give the form or report a uniform appearance.1. Stacked layout arranges the controls vertically with labels to the left of the control.2. Tabular layout arranges the controls horizontally with the labels across the top.
What is the difference between AND and OR criterion? Explain in detail.
An AND criterion is when you have 2 or more characters in the criteria row that both need to be true. The characters need to be in the same row. The OR criterion is when you have 2 or more characters in the criteria or OR row that only one of those characters need to be true. These characters need to be in different rows.
To specify grouping and sorting for a report, click the ____ button on the DESIGN tab in Layout view.
group and sort
To import data to a table, tap or click the ____ tab on the ribbon
EXTERNAL DATA
When entering invalid data into a field with a validation rule, it is possible that you could not enter the data correctly? What would cause this? If it happens, what should you do?
It is not possible to enter the information incorrectly. This is because when you do enter it wrong there will be an error message that will pop up. The information in that validation rule is incorrect so you cant move on until it is fixed. To fix this problem you could reread the validation rule and find out what you need to fix.
Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. What data type should Joe use for the Completion Date field? What data type should Joe use for the Social Security Number field? Why?
Joe should use the Date & Time data type because dates will be stored in the field. Joe should use the Short Text data type. Even though the field contains numbers, the field will not be used for arithmetic operations.
To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.
MAX
The ____ aggregate function finds the smallest value.
Min
To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.
group by
Explain in detail the two types of wild card querries.
One type of Wildcard is the asterisk. This involves a whole collection of characters. The other type is the question mark. The question mark is an individual character that is needed to be found.
Joe has been asked to create a Special Projects database for his company. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal Code, Hourly Pay Rate, Project Code) and Project (Project Code, Project Name, Total Hours, Completion Date) Which field in the Employee table should be the primary key and why? Which field in the Project table should be the primary key and why?
Social Security Number should be the primary key because the values in the field will be unique for each record.Project Code should be the primary key because you can assign unique values to the field.
What are some issues that occurs with redundant information. How do you eliminate redundancy within the database?
Some issues with redundancy is that it take up space on the database and drive. It is also very difficult to make changes without making errors. The solution to redundant information is to place that data in a separate table.
To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.
T?
Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.
true
To use a field list to add a field to a report in Layout view, click the ____ button on the DESIGN tab to display a field list.
add to existing fields
To clear a filter, click the ____ button on the HOME tab and then click Clear All Filters.
advanced
A(n) ____ query adds a group of records from one table to the end of another table.
append
To order the records in the Account table by city in alphabetical order, use the ____ button.
ascending
A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
autonumber
The ____ operator allows you to search for a range of values in one field.
between
To create a report in Layout view, click the ____ button.
blank report
To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.
build
A(n) ____ field is a field that can be computed from other fields.
calculated
____ are used to display data that is calculated from other data, such as a total.
calculated controls
When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.
captain
To clear a current filter, click ____ on the Advanced menu.
clear all filters
To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row
colon (:)
Less than (<), greater than (>), and NOT (not equal to) are examples of ____.
comparison operators
To display the Conditional Formatting Rules Manager dialog box, click the ____ button on the FORMAT tab.
conditional formatting
The ____________________ data type in Access is referred to as Money in SQL Server.
currency
Access is a ____.
database management system
To add a date to a form, click the ____ button on the DESIGN tab.
date and time
A(n) ____ query deletes all the records satisfying the criteria entered into the query.
delete
To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu
delete field
To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted, and then press the DELETE key.
design
____________________ view has more functionality for creating a table than Datasheet view.
design
To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
design view
____ allows you to make changes, but it does not show you the actual form.
design view
The body of the form is in the ____ section.
detail
To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.
external data
A query that prompts for input whenever it is run is a dialog query
false
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.
false
Filter By Query allows you to filter based on multiple criteria, for example, to find only those accounts whose returns are $0.00 and whose account manager is 38
false
A field whose data type is ____ can store text that can be used as a hyperlink address.
hyperlink
To create labels using the Label Wizard, click the ____ button on the CREATE tab.
labels
____ shows the report on the screen but also allows you to make changes to the report.
layout view
A ___ field allows the user to select from a list of values
lookup
To change the list of choices in a single or multivalued lookup field, open the table in Design view, select the field to be modified, and click the ____ tab in the Field Properties pane.
lookup
To add a record to a table, tap or click the ____ record button.
new (blank)
To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.
open
You can include ____ in calculations to indicate which calculation should be done first.
parentheses ( )
____ shows the report as it will appear when printed.
print preview
To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.
property sheet
The asterisk (*) wildcard represents any collection of characters.
true
The contents of the Detail section print once for each record in the table.
true
To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.
query design
To create a crosstab, click the ____ button on the CREATE tab.
query wizard
To save the changes to the layout of a table, tap or click the Save button on the ____.
quick access toolbar
A(n) ____ contains information about a given person, product, or event.
record
Designing to omit ____________________ will help to produce good and valid database designs.
redundancy
To update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then click the ____ button to update the records.
run
To use Filter By Selection to find all customers located in Granger, click the City field for any record where the city is Granger and then click the ____ button on the HOME tab.
selection
A field whose data type is ____ can contain any characters.
short text
If you open a field list and the tables do not appear in the field list, click ____.
show all tables
To show the Navigation Pane if it is hidden, click the ____ Button.
shutter bar open/close
To order the records in the answer to a query in a particular way, you ____ the records.
sort
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.
square brackets [ ]
A(n) ____ layout arranges controls vertically with the labels to the left of the control
stacked
A report that includes the group calculations such as subtotals, but does not include the individual detail lines, is called a(n) ____ report.
summary
You use the ____ button if you want to specify subtotals or other calculations within the wizard.
summary options
A(n) ____ layout arranges controls horizontally with the labels across the top, typically used in reports.
tabular
To use a common filter to find only those customers whose city begins with G, click the arrow to the right of the field name and point to the ____ command to display the custom text filters.
text filters
A ____ consists of a selection of colors and fonts for the various sections in a report or form.
theme
When a filter is in effect, you can redisplay all records by clicking the ____ button on the HOME tab.
toggle filter
To add totals or other statistics to a report, use the ____ button on the DESIGN tab.
totals
To include the Total row in the design grid, click the ____ button on the DESIGN tab.
totals
To include totals and other statistics at the bottom of a datasheet, click the ____ button on the HOME tab to include the Total row in the datasheet.
totals
A unique identifier is also called a primary key
true
Crosstab queries are useful for summarizing data by category or group.
true
Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.
true
Form view displays a single record at a time.
true
Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced Filter/Sort
true
If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.
true
If you want to specify subtotals or other calculations within the Report Wizard, you use the Summary Options button.
true
In the PrattLast Associates database, a one-to-many relationship exists between the Account Manager table and the Account table.
true
Landscape orientation means the printout is across the length (height) of the page
true
Looking for the account whose number is LI268 is an example of searching.
true
Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.
true
Redundancy means storing the same fact in more than one place
true
The contents of the Report Header section print once at the beginning of the report.
true
The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.
true
To add more space between groups, enlarge the group header or group footer.
true
To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.
true
To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.
true
To enter a number in a criterion, type the number without any dollar signs or commas
true
To find all accounts whose current due amounts are greater than $2,500.00 and whose account manager is manager 31, enter each criterion on the same row.
true
Validation rules are rules that a user must follow when entering the data.
true
When Access first creates a database, it automatically creates a table.
true
When you assign a theme to any object in the database, the theme immediately applies to all reports and forms in the same database, unless you specifically indicate otherwise.
true
You can use forms to add records, delete records, or change records
true
____ are not associated with data from the database and are used to display such things as the report's title.
unbound controls
To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
yes
To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.
zoom
