ISMG Access Ch 1-4
A relationship between tables in which a record in one table has only one matching record in the second table is a ________. 1:N M:N 1:1 There would not be a relationship between the two tables
1:1
A relationship between tables in which a record in one table has many matching records in the second table is a ________. 1:N M:N 1:1 There would not be a relationship between the two tables.
1:N
To search for a four-digit number that starts with "75" you would enter ________. 75? 75# 75## 75!
75##
When you want to specify multiple criteria, and all criteria must be true for a record to be included in the results, then the ________ logical operator is used. AND OR BETWEEN NOT
AND
A(n) ________ file is usually smaller than the original document, and is easy to send through e-mail. Word DOCX Adobe PDF PowerPoint PPTX Excel XLSX
Adobe PDF
________ perform arithmetic operations, such as calculating averages and totals, on records displayed in a table or query. Comparison operators Is Null criteria Special operators Aggregate functions
Aggregate functions
Which of the following is NOT true about referential integrity? All foreign key fields and primary key fields must have values entered and cannot remain null. The primary key field values on the one side of the relationship must be unique. The matching fields on both sides of the relationship have the same data types. You cannot enter a value in the foreign key field on the many side table that is not a primary key on the one side table.
All foreign key fields and primary key fields must have values entered and cannot remain null.
________ is a feature that can change the column width of the data to match the widest data entered in that field. AutoFit Fit by selection Field size Form fit
AutoFit
The ________ data type generates the value by automatically incrementing the value for each new record to produce unique keys. Number Short Text AutoNumber Calculated
AutoNumber
Which of the following is NOT true regarding compound fields? Break dates into Month, Day, and Year fields. Break product information into StyleNumber, Color, and Size fields. Break addresses into fields such as StreetAddress, City, State, and ZipCode. Break names into FirstName and LastName fields.
Break dates into Month, Day, and Year fields.
Which of the following is NOT true regarding compound fields? Break product information into StyleNumber, Color, and Size fields. Break addresses into fields such as StreetAddress, City, State, and ZipCode. Break dates into Month, Day, and Year fields. Break names into FirstName and LastName fields.
Break dates into Month, Day, and Year fields.
________ an Access database rearranges objects so disk space is used more efficiently. Recovering Compacting Backing up Saving
Compacting
________ equate the values in a table or another query to the criteria value you set up in a query. Is Null criteria Comparison operators Search criteria Query operators
Comparison operators
A ________ query is used when you want to describe one field in terms of two or more fields in the table. Find Duplicates Find Unmatched Crosstab Simple
Crosstab
Which of the following is NOT true about a table's Design view? Unless a caption is defined, the field name is the column label in Datasheet view. The field Properties pane gives more information on how the data is stored, entered, and processed. The upper pane contains three columns. Data types include items such as Default Value, Caption, and Format
Data types include items such as Default Value, Caption, and Format
The ________ view of a table displays the data stored in the table. Datasheet Report Design Layout
Datasheet
When a relationship is defined to enforce referential integrity and Cascade ________ Related Fields, Access will automatically change the data through all related tables when data is removed from the table that contains the primary key. Change Delete Remove Update
Delete
If you can see the blinking insertion point in a field, you are in ________. Design view Navigation mode Edit mode Layout view
Edit mode
Which of the following is NOT a design objective when creating tables? Minimize any errors Minimize the file size Encourage data consistency Ensure that there is a way to import data
Ensure that there is a way to import data
A person's phone number would serve as a good primary key. True False
False
A placeholder character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value. True False
False
An entity is a characteristic of an attribute. True False
False
AutoSize is a feature that can change the column width of the data to match the widest data entered in that field. True False
False
If you want to insert data from another file into an Access database, you must use copy and paste. True False
False
In Excel, a defined group is a group of cells that have been renamed. True False
False
In a query, if you use multiple criteria, then you may also use logical operators to combine these criteria. You Answered True False
False
Keystroke mode allows you to move from record to record and field to field using keystrokes. True False
False
Relationship lines are the lines connecting the tables that represent relationships. True False
False
The Description property in a table's Design view is required. True False
False
The Simple Query Wizard provides the opportunity to select data criteria. True False
False
To search for a three-digit number that starts with "67" you would enter 67*. True False
False
To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between, you would enter b[a-e]t. True False
False
When a database is normalized, cardinality is minimized. True False
False
A ________ query is used when you want to find records with the same specific value. Simple Crosstab Find Unmatched Find Duplicates
Find Duplicates
A ________ query is used when you want to find the rows in one table that do not have a match in the other table. Find Unmatched Crosstab Find Duplicates Simple
Find Unmatched
In Datasheet view, you can use the ________ to quickly locate specific records using all or part of a field value. wildcard character Find command Find & Replace command Replace command
Find command
The ________ property in the Design view of a table defines how Access should display the data. Format Data Type Input Mask Default Value
Format
Which of the following is NOT true about creating groups in a report? Groups can only be created with data from individual tables. A group is a collection of records along with introductory and summary information about the records. Grouping allows you to separate related records for the purpose of creating a visual summary of the data. In the Report Wizard, you will have the option to group the data in your report.
Groups can only be created with data from individual tables.
When navigating a main form, pressing ________ will move the cursor to the first field of the current record. Ctrl + Home End Home Tab
Home
Which of the following is NOT true about editing, adding, and deleting records? When you add a record to a form, you are actually adding the record to the table it will be stored in. Changes to data are saved automatically. If the table is part of a relationship, referential integrity has not been enforced, and the cascade delete option has been chosen, a record cannot be deleted if there are related records in another table until those records have also been deleted. Records can be deleted from a single table without additional steps if the table is not part of a relationship.
If the table is part of a relationship, referential integrity has not been enforced, and the cascade delete option has been chosen, a record cannot be deleted if there are related records in another table until those records have also been deleted.
Which of the following is NOT true about undoing in Access? Until the design of an object is saved, you can click Undo to undo design changes. Pressing Esc gets you out of an error. Just like in other Office applications, there is a great deal of undo/redo functionality in Access. If you have made changes to several fields in a single record, you can click Undo to undo each of them.
Just like in other Office applications, there is a great deal of undo/redo functionality in Access.
To view a form and the data, click ________ view. Design Print Layout Form
Layout
When resizing and managing controls, the ________ allows you to move the whole table at one time. control selector Form Wizard subform control Layout Selector
Layout Selector
________ allows you to modify the report while seeing the data. Report view Print Preview Design view Layout view
Layout view
Unless a common field is being joined, such as a foreign key to the same foreign key in a different table, Access cannot form a ________ relationship with a single relationship. 1:N M:N 1:1 M:1
M:N
In a query, if you wanted to display the largest value from the selected records, you would use the ________ aggregate function. Count Maximum Minimum Sum
Maximum
The ________ Date Format field property formats the date as 9-Nov-15. Medium Long General Short
Medium
In a query, if you wanted to display the smallest value from the selected records, you would use the ________ aggregate function. Count Maximum Sum Minimum
Minimum
The ________ allows you to move to the top and bottom of a table or scroll to a specific record. Arrows bar Navigation Pane Forward and Backward arrows Navigation bar
Navigation bar
The ________ operator in a query selects the records in which the field value is not equal to the value provided. Between > = OR No answer text provided.
No answer text provided.
Which of the following is NOT true about creating a report using the Report Wizard? In the Report Wizard, you have the option to group the data in your report. Once a report is created using the wizard, it will open in Design view. In the Report Wizard, you can choose the table or query to base the report on, and choose the fields to include in the report. The Report Wizard will walk you step by step through the process of building your report.
Once a report is created using the wizard, it will open in Design view.
The Navigation ________ on the left side of the application allows you to view all the objects in a database. window Pane bar filter
Pane
Calculated query fields must be formatted in the query design grid using the ________. Property Sheet Expression Builder Navigation bar Navigation Pane
Property Sheet
Calculated query fields must be formatted in the query design grid using the ________. Navigation bar Navigation Pane Property Sheet Expression Builder
Property Sheet
To see how a report would look in a continuous page layout, open the report in ________. Design view Layout view Report view Print Preview
Report view
The ________ data type stores a maximum of 255 characters in the field. Lookup Wizard Long Text OLE Object Short Text
Short Text
Which of the following is NOT a method used to add fields to a query design grid? Click, Shift, click Drag Double-click title bar Single-click field name
Single-click field name
Which of the following is NOT true about sorting query results on a single field? To sort records, you have to select a sort field, or a field used to determine the order of the records. Sorting is the process of rearranging records within a table in a specific order. A field may be sorted either in ascending order or descending order. By default, records in a table or query are sorted by the primary key field.
Sorting is the process of rearranging records within a table in a specific order.
Which of the following is NOT true about using special operators? Special operators are used to compare text values using Find & Replace along with the AND operator. Special operators are used in a set of values using the IN operator. Special operators are used to determine whether values are between a range of values using the BETWEEN operator. Special operators are used to compare text values using wildcards using the LIKE operator.
Special operators are used to compare text values using Find & Replace along with the AND operator.
When navigating a main form, pressing ________ will move the cursor from field to field within a record. Tab Ctrl + Enter Home You Answered End
Tab
Which of the following is NOT true about the Find Unmatched query wizard? The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query. If a one-to-many relationship exists between the two tables, then the wizard will join the two correct fields automatically. The wizard will try to match the primary key field and the foreign key field if there is a one-to-many relationship between the two tables. The wizard uses the primary key from the first table and matches it with the foreign key in the second table in order to determine if there are unmatched records.
The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query.
Which of the following is NOT true about changing field names in a query? The field names assigned in an aggregate query can easily be changed either before or after the query is run. The default name that Access uses for a field that includes an aggregate function is descriptive and does not need to be changed. Field names in aggregate queries are a composite of the selected aggregate function and the table field name. You must keep the original field name in the query design grid so Access knows what field to perform the calculation on.
The default name that Access uses for a field that includes an aggregate function is descriptive and does not need to be changed.
Which of the following is NOT true about creating queries in Design view? When you open Design view, by default, the Show Table dialog box opens with a list of available tables and queries to add. When you use the query window, you have more control and more options available to manage the details of the query design than with the Simple Query Wizard. The query window in Design view allows you to specify the data you want to see by building a query by wizard. In the query window, you can include specific fields, define criteria, sort records, and perform calculations.
The query window in Design view allows you to specify the data you want to see by building a query by wizard.
Which of the following is NOT true about compacting and repairing a database? If you do not compact your database, it can become very large quickly. There are four options for compacting a database. The compact option also looks for damaged data and tries to repair it. Compacting releases unused space to be used again.
There are four options for compacting a database.
Which of the following is NOT true about compacting and repairing a database? The compact option also looks for damaged data and tries to repair it. Compacting releases unused space to be used again. There are four options for compacting a database. If you do not compact your database, it can become very large quickly.
There are four options for compacting a database.
Which of the following is NOT a method used to open or switch views? To open an object in default view, right-click it and select Edit. To open an object in design view, right-click it in the Navigation Pane, and select Design View. To switch views for an already open object, on the Home tab, in the Views group, click the View arrow, and then select your preferred view. To switch views for an already open object, right-click the object tab, and then select the preferred view.
To open an object in default view, right-click it and select Edit.
A split form is a form created from one table, but it has a Form view and a Datasheet view in the same window. True False
True
A split form is helpful when you want to work with one record at a time and still see the big picture in the main table. True False
True
A wildcard character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value. True False
True
An entity stores data about people, places, or things. True False
True
Comparison operators compare the values in a table or another query to the criteria value you set up in a query. True False
True
Datasheets are used to view all records in a table at one time. True False
True
Null is the absence of any value and is different from blank or zero. True False
True
The power of Access can be seen when relationships are created between tables. True False
True
The size of a field can be changed in a table's Design view. True False
True
To ensure that information is entered, sorted, and displayed consistently, an input mask can be defined in a field. True False
True
When a relationship is defined to enforce referential integrity and Cascade ________ Related Fields, Access will automatically change the data through all related tables when a revision is made to the data in the table that contains the primary key. Remove Change Delete Update
Update
Which of the following is NOT true about sorting query results on multiple fields? You can have one field sorted in ascending order and another in descending order. The second and subsequent fields are called secondary sort fields. The first field you choose to sort by is called the primary sort field. In datasheet view, you can sort multiple fields by selecting all the fields at one time and using the Sort & Filter group sorts.
You can have one field sorted in ascending order and another in descending order.
Which of the following is NOT true regarding split forms? This kind of form is helpful when you want to work with one record at a time and still see the big picture in the main table. You can view one record at a time at the top of the window, and see the whole table in Datasheet view at the bottom of the window. You can highlight a different record in the form part and the datasheet part at the same time. In a split form, there are buttons on the Navigation bar to move only from record to record, and each record shown at the top is the record highlighted in the datasheet at the same time.
You can highlight a different record in the form part and the datasheet part at the same time.
Which of the following is NOT true about navigating forms? A form is an object in Access that you can use to enter, edit, or view records in a table. A simple form allows you to see records one at a time rather than as a group in Datasheet view. Often seeing one record at a time in a form can eliminate data entry errors and allow the user to focus on the information for that particular record. You navigate records in a form the same way you navigate a table, using buttons on the Arrow bar to move from record to record.
You navigate records in a form the same way you navigate a table, using buttons on the Arrow bar to move from record to record.
Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________. a form the relationship window a query a report
a form
Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________. a query the relationship window a form a report
a form
A phone number is an example of a(n) ________. property attribute entity relationship
attribute
A(n) ________ database is an extra copy of a database that you keep just in case something happens to the original one. compacted backup advance repaired
backup
The Navigation ________ makes it easy for you to move through records in a table. window file bar Pane
bar
The ________ operator in a query selects the records in which the field values listed are within the two values. OR Between No answer text provided. > =
between
If one customer can purchase many items, one-to-many is called the ________ of the relationship. redundancy cardinality joining integrity
cardinality
In a query, if you wanted to display the number of records retrieved, you would use the ________ aggregate function. Count Minimum Maximum Sum
count
Print Preview adds the ________ to the page footer at the bottom of every page. creator's name current date and page numbers file name file path
current date and page numbers
In a customer table, a(n) ________ field would serve as a good primary key. date of birth customer ID phone number address
customer ID
Facts about people, events, ideas, or things are ________. knowledge objects data information
data
________ are raw facts. Data Objects Queries Information
data
The ________ in a table dictates what data can be stored in a field. data type field name description field properties
data type
A character, such as a colon or comma, that separates fields is a ________. named range definition slicer delimiter
delimiter
The ________ view shows the query's structure. Query Results Design Datasheet SQL
design
All of the following fields would have a Short Text data type EXCEPT: student ID number. phone number. email address. zip code.
email address.
An appropriate example of the type of data that could be stored in an Attachment data type field is ________. employee photo gross pay company website start time
employee photo
A DBMS and database are synonymous. True False
false
A column in an Access table is called a characteristic. True False
false
A form pulls records from a table in an easy-to-read format suitable for printing. True False
false
A person's phone number would serve as a good primary key. True False
false
Access 2016 uses a different file extension than previous versions of Access. True False
false
Access has six main objects. True False
false
An entity is a characteristic of an attribute. True False
false
By default, records in a table or query are sorted by the foreign key field. true false
false
Data is always stored in a form. True False
false
If you want to delete a customer from tblCustomer when referential integrity is turned on, and that customer has appointments in tblSchedule, then the appointments for the customer have to be deleted from the tblCustomer first. True False
false
In Datasheet view, you can use the Replace command to quickly locate specific records using all or part of a field value. True False
false
In Excel, a defined group is a group of cells that have been renamed. True False
false
Keystroke mode allows you to move from record to record and field to field using keystrokes. True False
false
Operational databases are used for extracting data for decision making. You Answered True False
false
Text filters allow you to create a custom filter to match all of the text in a field that you specify. True False
false
The Navigation bar allows you to move to the top and bottom of a table or scroll to a specific record and can be an efficient tool regardless of the size of the table. True False
false
The Undo button will permit a user to undo up to 100 changes. True False
false
The data contents within a table can be seen in Design view. True False
false
The terms null and zero are synonymous. True False
false
The upper part of a table's Design view has four columns. True False
false
There are three major kinds of controls: inbound, unbound, and calculated. True False
false
To find all states that are not PA, you could enter "PA" for the state criteria. The is an example of a logical operator. True False
false
To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between, you would enter b[a-e]t. True False
false
When the Report Wizard is done creating the report, it shows you the report in Layout view. True False
false
Query results can be printed from the ________ tab. File View Home Create
file
Query results can be printed from the ________ tab. File View Home create
file
When you ________, you select a value in a record and Access filters the records that contain only the values that match what you have selected. filter by selection use the Navigation bar use the Find command use the Replace command
filter by selection
The ________ key in one table acts as a primary key of another table. composite natural numeric foreign
foreign
Reports have ________ views. five three two four
four
The process of copying data from another file into a database is known as ________. reconciling inserting filing importing
importing
All information about a database's table joins are stored ________. in the Relationships window on the Create tab in the Navigation pane in Backstage view
in the Relationships window
Facts that have been manipulated and have meaning become ________. knowledge information objects data
information
Being able to format a phone number in a field as (412) 555-8676 without manually entering the symbols occurs when a(n) ________ has been applied to the field. link input mask wizard relationship
input mask
By establishing a relationship between two tables that is based on a common field in the two tables, a ________ is being created. location join link path
join
The file extension for a 2002-2003 Access database file that is in "execute only" mode is ________. mdb accdt accde mde
mde
If two tables do not have a common field, Access will join the two tables by combining the records, regardless of whether they have a matching field. This is called the ________ effect. query multiplier relationship join
multiplier
An appropriate example of the type of data that could be stored in a Short Text data type field is ________. salary quantity customer ID name and addresses
name and addresses
Access can import smaller sections of a worksheet known as a ________. named range definition slicer delimiter
named range
Access can import smaller sections of a worksheet known as a ________. definition named range delimiter slicer
named range
When a database is ________, redundancy is minimized. normalized delimited joined shared
normalized
In a database, a table or entity represents ________. adverbs verbs nouns adjectives
nouns
If one student in tblStudents can register for many classes in tblClasses, the relationship would be noted as a ________ relationship. one-to-many many-to-many one-to-one There would not be a relationship between the two tables.
one-to-many
A(n) ________ is a foreign key in one table that does not have a matching value in the primary key field of a related table. wildcard composite key orphan duplicate key
orphan
In Datasheet view, the ________ icon that appears in the record selector indicates that the record is being modified. pointer arrow pencil eraser
pencil
In a database, a(n) ________ is a field that uniquely identifies a record. input mask named range Yes/No field primary key
primary key
You can use a database ________ to ask a question of the data. form table query report
query
The ________ Time Format field property formats the time as 22:10. Military Medium Long Short
short
The field ________ defines the maximum length of data within a field. row height piece size section
size
A structure of a database that is already populated with tables, fields, forms, queries, and reports is a(n) ________. template DBMS starting file relationshi
template
A structure of a database that is already populated with tables, fields, forms, queries, and reports is a(n) ________. template relationship DBMS starting file
template
An input mask sets a specific ________ and provides the punctuation, so it does not have to be typed manually. template starting file field name relationship
template
A ________ is a built-in combination of colors and fonts. template Form Wizard theme control
theme
Database design can be looked at as a ________ process. two-step four-step five-step three-step
three-step
Database design can be looked at as a ________ process. two-step three-step four-step five-step
three-step
If you need to see a quick snapshot of statistics for a table or query, you can use the ________. Function pane total row aggregate row statistics button
total row
If you need to see a quick snapshot of statistics for a table or query, you can use the ________. aggregate row statistics button Function pane total row
total row
A control is a part of a form or report that you use to enter, edit, or display data. True False
true
A database is a collection of the data that companies spend a lot of time and money on gathering. True False
true
A delimiter is a character that separates fields within a text or Word file. True False
true
A disadvantage to editing data in a form is that some fields may be missing. True False
true
A query is another word for a question. True False
true
A table organizes data in columns and rows. True False
true
A template can be used as a starting point when creating a new database. True False
true
A wildcard character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value. True False
true
An advantage to editing data in a query is that there may be fewer records and/or fields in the datasheet making the data more manageable. True False
true
An aggregate function can be used in Datasheet view by adding a total row to a table. True False
true
An orphan is a foreign key in one table that does not have a matching value in the primary key field of a related table. True False
true
Because there are many Access functions that use a table and will not work if the table is open, it is best practice to close a table when you are finished working with it. True False
true
Changing the theme will not only change the colors of the form, but also the font type and size and any border colors or object colors added to the form. True False
true
Comparison operators compare the values in a table or another query to the criteria value you set up in a query. True False
true
Database design is considered to be a three-step process. True False
true
Databases are used for operational processing and for analytical purposes. True False
true
Deleting records in a table is permanent. True False
true
If two tables do not have a common field, Access will join the two tables by combining the records, regardless of whether they have a matching field. This is known as the multiplier effect. True False
true
If you cause an error in Access, you can press Esc to get out of it. True False
true
If you have redundant data in your database, then you have duplicate data that should be corrected or deleted. True False
true
In addition to the Simple Query Wizard, there are three additional query wizards available to make quick, step-by-step queries. True False
true
Report view provides an interactive view of your report without page breaks. True False
true
Tables have two views: Datasheet view and Design view. True False
true
The AutoNumber data type is best used for the primary key. True False
true
The process of normalization causes multiple smaller tables to be created. True False
true
The process of normalization causes multiple smaller tables to be created. True False
true
The query window in Design view allows you to specify the data you want to see by building a query by example. True False
true
To copy and paste from Excel into Access, ensure that the columns are exactly the same in the two applications. True False
true
To ensure that information is entered, sorted, and displayed consistently, an input mask can be defined in a field. True False
true
To update data in a table, you must be in Edit mode. True False
true
What you learn about one relational database can be transferred to other relational databases. True False
true
When manually entering data into an Access database, there is one method which is to enter it directly into the table. True False
true
When navigating forms with a subform, the Navigation bar buttons at the bottom of the main window are used to navigate the records in the main form, and a second Navigation bar at the bottom of the subform datasheet is used to navigate the records in the subform. True False
true
When using the Find Duplicates Query Wizard, you select the fields that you think may include duplicate information, and the wizard creates the query to find records matching your criteria. True False
true
When you create relationships in a relational database, you give it power. True False
true
When you filter by selection, you select a value in a record and Access filters the records that contain only the values that match what you have selected. True False
true
When you have a one-to-one relationship, you could combine the two tables into a single table. True False
true
With multiple criteria, it is good practice to add one criteria, run the query to make sure you are getting the correct results, and then continue adding criteria one at a time. True False
true
Tables have ________ view(s). one four three two
two
A(n) ________ control is a control that does not have a source of data such as the title of the form. bound unbound calculated text box
unbound
A ________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value. Find command Replace command Find & Replace command wildcard character
wildcard character
A ________ helps create objects using a step-by-step process. wizard file extension template shortcut
wizard
