• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/150

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

150 Cards in this Set

  • Front
  • Back
The ____ is the main control center for opening and working with database objects.

Navigation Pane
Wizard window
Control window
Database window
Navigation Pane
The ____Toolbar provides one-click access to commonly used commands, such as Save.

Access
Navigation
Quick Access
Database
Quick Access
The ____ tab provides options for adding, removing, and formatting the fields in a table.

Layout
Fields
Tabular
Datasheet
Fields
The ____ window is the program window that appears when you create a new database or open an existing database.

Database
Tabular
Access
Datasheet
Access
The ____ provides the main Access commands organized by task into tabs and groups.

Microsoft Access Help
datasheet
Ribbon
Add & Delete group
Ribbon
In the accompanying figure, the last row of data shown (11053, Hwan, Tang, etc.) is a ____.

table
field
record
key
record
In the accompanying figure, there are ____ fields shown.

3
4
5
6
4
The content of any given field is the ____.

database
table
field value
entity
field value
Which of the following could be defined as a field in a database?

customer name
order number
phone number
all of the above
all of the above
A relational database is a collection of ____.

field values
records
related tables
common fields
related tables
Every foreign key must ____.

be unique
be numeric
match the field value of a primary key in a related table
be defined in all tables within the database
match the field value of a primary key in a related table
Which extension identifies a file as a Microsoft Access 2010 database?

.acc
.mdb
.adb
.accdb
.accdb
Use the ____ key(s) to move to the next column in a table.

Enter
Tab
Shift
both a and b
both a and b
You can use the ____ column in the table datasheet to add new fields.

Additional Fields
Table Structure
Database Options
Click to Add
Click to Add
In Datasheet view, clicking a row selector selects an entire ____.

field
record
array
attribute
record
In Datasheet view, the pencil symbol indicates the ____.

next available row for a new record
record is being edited
first record
current field
record is being edited
To correct a value by replacing it entirely, press the ____ key, and then type the correct value.

Ctrl
Esc
F1
Alt
Esc
The Save button on the Quick Access Toolbar is used to ____.

save the database file to your disk
save the database file with a new name
save the design of an Access object
none of the above; this is a setting determined by the user
save the design of an Access object
Access can guide you through the steps to create a query by using the Query ____.

Generator
Wizard
Creator
Manager
Wizard
A form is used to ____.

select records that meet specific criteria
enter, edit, and view records in a database
automate the retrieval and update process
none of the above
enter, edit, and view records in a database
The ____ places all the fields from a selected table (or query) on a report.

AutoReport Wizard
Report Template
Report tool
New Report button
Report tool
The Create tab has options to create all of the following EXCEPT ____.

reports
forms
tables
other databases
other databases
You can move to each subsequent step in any wizard dialog box by clicking the ____ button.

Advance
Next
Finish
New
Next
In the accompanying figure, the arrow labeled 1 is pointing to a symbol used to ____.

move a field to the Selected Fields box
move all fields to the Available Fields box
remove a field from the query
remove all fields from the query
move a field to the Selected Fields box
In the accompanying figure, the arrow labeled 2 is pointing to a symbol used to ____.

move a field to the Selected Fields box
move all available fields to the Selected Fields box
remove a field from the query
remove all fields from the query
move all available fields to the Selected Fields box
You can ____ a field in the first Simple Query Wizard dialog box to move the field from the Available Fields box to the Selected Fields box.

click
double-click
right-click
hover over
double-click
When you create a query, the records are listed ____.

in ascending order
in whatever order they are in the table
in order by the primary key field
in the order you selected them
in order by the primary key field
It is best to ____ a database object—query, form, or report—only if you anticipate using the object frequently or if it is time-consuming to create because all objects use storage space on your disk.

file
save
archive
zoom
save
____ a database rearranges data and objects in a database to make its size smaller.

Compressing
Compacting
Realigning
Customizing
Compacting
The default category in the Navigation Pane is ____.

Reports
Queries
All Access Objects
Tables
All Access Objects
Access searches for objects only in the categories and groups currently displayed in the ____.

a.Access window
b.Database window
c.current table
d.Navigation Pane
d.Navigation Pane
If Yuka sees information in rows and columns in a query that looks similar to a table, what view is she in?

a.Datasheet view
b.Design view
c.PivotChart view
d.PivotTable view
a.Datasheet view
As Yuka plans her database, she will use the Text data type for fields that will contain all but ____.

a.identifying numbers
b.letters, digits, and other characters
c.numbers that are used in calculations
d.dates
c.numbers that are used in calculations
Martha’s database had been working well but it has begun to behave in unexpected ways. What should she do?

a.Delete selected records from the database.
b.Use one of the options on the All Access Objects bar.
c.Use the Compact & Repair Database option.
d.Restore the backup from the Navigation Pane.
c.Use the Compact & Repair Database option.
To make sure that Martha’s database is protected against loss, damage, or file corruption, what should she do?

a.Compact and repair the database on the hard drive.
b.Convert the database to Access 2007.
c.Make a backup copy on the hard drive.
d.Set a database password.
c.Make a backup copy on the hard drive.
Why would Tom change the data type for an ID field added automatically by Access?

a.because he wants a different sort order for the table
b.because the data won’t fit otherwise
c.to use a specific format that may already exist, such as a Social Security number
d.there is no ID field added automatically by Access
c.to use a specific format that may already exist, such as a Social Security number
What field type(s) should Tom use to automatically fill the field with a unique number for every record in his table?

a.Text
b.AutoNumber
c.Currency
d.Primary Key
b.AutoNumber
Tom wants to know at a glance how many records are contained in the current table. Where should he look?

a.Total Records box
b.All Records box
c.Current Record box
d.Office Button
c.Current Record box
The default table name assigned to a new table is ____.

a.TableNew
b.1Table
c.NewTable
d.Table1
d.Table1
The characteristics of a field, such as name, size, and type, are called the field ____.

a.properties
b.traits
c.values
d.qualities
a.properties
The ____ determines what type of values can be entered for a field.

a.data element
b.data type
c.data integrity
d.primary key
b.data type
The ____ determines what field values are allowed and what other properties the field will have.

a.record type
b.attribute
c.identity
d.data type
d.data type
Which view would you select if you wanted to define a table yourself from start to finish?

a.Design view
b.Database view
c.Layout view
d.Datasheet view
a.Design view
Values for field properties other than Field Name, Data Type, and Description are entered in the ____ portion of the Table window in Design view.

a.Field Properties pane
b.Design
c.Table Design grid
d.Status bar
a.Field Properties pane
While defining your fields, you need more information about the current property you are working with. You want to show Help information like the kind marked 2 in the accompanying figure. What should you do?

a.Press the F1 key.
b.Double-click the Microsoft Access icon.
c.Press the F2 key.
d.none of the above
a.Press the F1 key.
A primary key ____.

a.must be numeric
b.must be defined in each table
c.uniquely identifies each record in a table
d.is always the first field defined in a table
c.uniquely identifies each record in a table
If you need to connect one table to another in related fields, use a _____.

a.common data type
b.common field
c.composite key
d.foreign key
b.common field
A primary key that consists of more than one field is called a ____ key.

a.foreign
b.composite
c.group
d.none of the above
b.composite
Given a relationship between the two tables in the accompanying figure, the field values labeled 2 show ____ data.

a.redundant
b.inconsistent
c.variation
d.irrelevant
b.inconsistent
Storing the same data field in multiple tables is called data ____.

a.reliance
b.interdependence
c.networking
d.redundancy
d.redundancy
When designing a new database, it is a good idea to ____.

a.include redundant fields to provide data security
b.avoid data redundancy
c.include a common field in all tables
d.use composite keys
b.avoid data redundancy
A field name ____.

a.must be unique within a table
b.can be up to 128 characters long
c.must start with a space
d.all of the above
a.must be unique within a table
When defining a database, the name given to a table or other object should reflect its ____.

a.contents
b.key sequence
c.common fields
d.characteristics
a.contents
Certain Access data types have a predefined field ____ that cannot be changed.

a.size
b.identity
c.currency
d.lookup
a.size
Calculations performed using the ____ data type are not subject to round-off error.

a.Memo
b.Number
c.Currency
d.Decimal
c.Currency
The ____ data type allows field values containing letters, digits, spaces, and special characters; it is used for long comments and explanations.

a.Memo
b.OLE Object
c.AutoNumber
d.Text
a.Memo
What data type has a field size of 1 to 65,535 characters (although the exact size is determined by the entry), and allows field values containing letters, digits, spaces, and special characters? It is also used for long comments and explanations.

a.Memo
b.Number
c.OLE Object
d.Hyperlink
a.Memo
Which of the following fields does not have a Field Size property?

a.AutoNumber
b.Number
c.Text
d.none of the above
d.none of the above
When defining a field, the field ____ defines a field value’s maximum storage size.

a.density
b.size
c.placement
d.wizard
b.size
A field that consists of integer values that are controlled by Access is a(n) ____ type field.

a.AutoNumber
b.Memo
c.Date/Time
d.Yes/No
a.AutoNumber
The ____ property setting for number fields stores whole numbers from -32,768 to 32,767 in two bytes.

a.Decimal
b.Byte
c.Long Integer
d.Integer
d.Integer
The ____ property setting for number fields establishes a unique identifier for the replication of tables, records, and other objects; it uses 16 bytes.

a.Replication ID
b.Byte
c.Double
d.Decimal
a.Replication ID
It would be wasteful to use the Long Integer setting when defining a field that will only store whole numbers ranging from 0 to 255 because the Long Integer setting will use ____ bytes of storage space.

a.four
b.six
c.eight
d.10
a.four
To create a new table, you should ____.

a.name the fields and define their properties
b.define the primary key
c.save the table structure
d.all of the above
d.all of the above
To begin creating a new table, click the ____ tab on the Ribbon.

a.Home
b.Create
c.Database Tools
d.External Data
b.Create
You move from text box to text box when designing a table in Design view by pressing the ____ key.

a.F1
b.Esc
c.Tab
d.Alt
c.Tab
To change the way your data is displayed in a field, you can change the field’s ____.

a.description
b.Format property
c.current record indicator
d.Edit value
b.Format property
If you do not enter any value for a field, you have given the field a(n) ____ value.

a.blank
b.redundant
c.null
d.illegal
c.null
If a table is defined with a primary key, Access will require you to enter a value for the key when adding a record in a process known as ____.

a.redundancy elimination
b.entity integrity
c.data integrity
d.key verification
b.entity integrity
If no entry is the same as another, you are in a _____.

a.common field
b.data type
c.number field
d.primary key field
d.primary key field
After all primary key fields have been selected, you must click the ____ to complete the key definition.

a.Create tab on the Ribbon
b.Save button on the Quick Access toolbar
c.row selector for the first key field
d.Primary Key button in the Tools group on the Design tab
d.Primary Key button in the Tools group on the Design tab
The last step in creating a table is to ____.

a.click the Finish button
b.name the table and save its structure
c.click the Close button in the Design window
d.compact the table
b.name the table and save its structure
You can specify a name for a table after you click the ____ button on the Quick Access Toolbar.

a.Print
b.Save
c.Format
d.Structure
b.Save
You can modify an existing table’s structure in ____.

a.the Database window
b.Form view
c.Design view
d.the Properties area
c.Design view
When you change a field’s property in Design view in Yuka’s database, you can use this button to update the corresponding property on forms and reports that include the field you’ve modified.

a.Update
b.Replicate
c.Propagate
d.both a and c
d.both a and c
If you choose the ____, Access permits the change in value to the primary key and changes the appropriate foreign key values in the related table, thereby eliminating the possibility of inconsistent data in Yuka’s database.

a.Cascade Delete Related Fields option
b.Cascade Update Related Fields option
c.Propagate option
d.Referential integrity option
b.Cascade Update Related Fields option
In the accompanying figure, the arrow labeled 3 is pointing to the ____.

a.Design view button
b.Datasheet view button
c.Layout view button
d.Print Preview button
b.Datasheet view button
In the accompanying figure, the arrow labeled 4 is pointing to the button used to ____.

a.remove a field as primary key
b.specify the primary key
c.specify the composite key
d.all of the above
d.all of the above
The Relationships window in the accompanying figure can be used to do which of the following?

a.rearrange the layout of tables
b.define relationships between tables
c.change existing relationships
d.all of the above
d.all of the above
The primary key in the Invoice table in the accompanying figure is ____.

a.Email
b.Company
c.CustomerID
d.InvoiceNum
d.InvoiceNum
For a special report, Tom wants his donation fields to display in a Currency format that does not display dollar signs, so he will use the ____ format.

a.Money
b.Currency
c.Dollar
d.Standard
d.Standard
Emma is setting up referential integrity in the database. Why would she not include the Cascade Delete Related Records option?

a.She can delete related records in Datasheet view.
b.She will not need it to maintain the database.
c.She might inadvertently delete records she did not intend to delete.
d.all of the above
d.all of the above
Each ____ in the design grid contains specifications about a field you use in a query.

a.sector
b.range
c.row
d.column
d.column
If there are related records in a related table, you can’t delete a record in the primary table until you delete the ____.

a.related records first
b.related table
c.common fields
d.join
a.related records first
You can’t delete a record in a table if the table ____.

a.is in Datasheet view
b.has a plus sign at the beginning of the record
c.has a minus sign at the beginning of a record
d.both b and c
d.both b and c
A query defined in Access can ____.

a.display selected fields and records from one or more tables
b.sort records and perform calculations
c.generate data for forms and reports
d.all of the above
d.all of the above
Queries can be created by using the Query ____, which prompts you for the information required to build the query.

a.Master
b.Generator
c.Wizard
d.Definer
c.Wizard
To choose fields for a select query in Design view, _____.

a.double-click the fields in the field list
b.drag the field from the field list
c.use the field arrow
d.both a and b
d.both a and b
A(n) ____ query is a query based on more than one table.

a.consistent
b.multitable
c.many-to-one
d.nonunique
b.multitable
When viewing a two-table query in Design view, which is not an indicator of whether the tables have a one-to-many relationship?

a.the thickness of the join line
b.whether you see a 1 and an infinity sign at the ends of the join line
c.whether you see the same field in both field lists
d.the fact that you have not enforced referential integrity
d.the fact that you have not enforced referential integrity
A ____ datasheet is temporary, and its contents are based on the criteria you establish in the design grid.

a.report
b.table
c.query
d.both b and c
c.query
Which of the following field types may be specified as a sort field?

a.Memo
b.OLE Object
c.Hyperlink
d.AutoNumber
d.AutoNumber
To use the sort buttons on the Ribbon to sort a query with multiple sort keys, the sort keys must be ____.

a.unique
b.consistent
c.adjacent
d.primary keys
c.adjacent
As shown in the accompanying figure, _____ selects all or part of a field value in a datasheet and then when the filter is applied, displays only those records with the selected value.

a.Filter By Form
b.Filter By Selection
c.Sort Ascending
d.Sort Descending
b.Filter By Selection
A selection condition that dictates that the value in the specified field must precisely match the condition is known as a(n) ____ match.

a.specific
b.exact
c.selection
d.value
b.exact
Operators used in selection criteria in a query, such as equal to, not equal to, or greater than, are known as ____ operators.

a.comparison
b.selection
c.indexed
d.optional
a.comparison
Access allows you to improve the appearance or readability of the results datasheet by changing the ____.

a.font type
b.font size
c.column size
d.all of the above
d.all of the above
Multiple conditions can be defined to control which records are selected through the use of ____.

a.logical operators
b.syntax
c.comparison operators
d.complete expressions
a.logical operators
The ____ operator will cause a record to be selected only if two or more conditions are satisfied.

a.Or
b.If...Or
c.range
d.And
d.And
Selection criteria that are placed in different rows in the query design grid indicate an ____ operator.

a.Or
b.Exclusion
c.And
d.Alternate
a.Or
The ____ is a dialog box used to enter text, expressions, and other values.

a.Expression Builder
b.Text Holder
c.Calculation window
d.Zoom box
d.Zoom box
A lengthy or complicated expression will normally be too large to be shown in its entirety in the ____ box.

a.Show
b.Criteria
c.Field
d.Expression
c.Field
A calculation can be defined in a query by typing it directly into a Field box in the ____.

a.design grid
b.field list
c.Relationship window
d.criteria box
a.design grid
Statistical information, such as totals and averages, can be calculated in a query by using a(n) ____.

a.expression
b.condition
c.aggregate function
d.comparison operator
c.aggregate function
The ____ operator is a comparison operator that allows you to check whether or not a particular field value is part of a list of values.

a.Like
b.Between
c.In ()
d.List
c.In ()
To indicate a pattern that includes wildcards, use _____.

a.In (“617”)
b.Like “617”
c.Like “617*”
d.all of the above
c.Like “617*”
The symbols for the Access comparison operator for not equal to are _____.

a.!=
b.>=
c.<=
d.<>
d.<>
When you run a query that contains a ____ field, Access evaluates the expression defined by the field and displays the resulting value in the query datasheet, form, or report.

a.calculated
b.relative
c.dynamic
d.static
a.calculated
What aggregate function supports both the Currency data type and the Yes/No data type?

a.Avg
b.Count
c.Max
d.Sum
b.Count
The item featured in the accompanying figure is the ____ Pane menu.

a.Query
b.Navigation
c.Design
d.Tabular
b.Navigation
If Yuka wants to quickly perform a calculation on the OLE Object field in her database using an aggregate function in a query datasheet, she can use the ____ function.

a.Average
b.Count
c.Maximum
d.Sum
b.Count
Yuka wants to change to an alternating background color for the rows in the Current Guitar Lesson datasheet. To do this she would use the ____ button.

a.Access Themes
b.Font Color
c.Alternate Row Color
d.Row color
c.Alternate Row Color
Martha would like to create a list of all the aerobics classes being held in the Red room and in the Blue room. Which of the following comparison operators would work?

a.Like (“Red”, “Blue”)
b.In (“Red”, “Blue”)
c.= “Red” and “Blue”
d.>= “Red” || “Blue”
b.In (“Red”, “Blue”)
Tom wants to create a single query to display the sum, average, and count of the Donation Value field for all donations. To do this, he must double-click the Donation Value field ____.

a.once
b.twice
c.three times
d.none of the above
c.three times
To move from record to record in a form, you can use the ____.

a.Form Wizard
b.Record Finder
c.Record Navigator
d.navigation buttons
d.navigation buttons
You use ____ view to view, enter, and maintain data in the table on which a form is based.

a.Form
b.Columnar
c.Tabular
d.Maintenance
a.Form
A form using all fields in a selected table can be created automatically using the ____.

a.Form Wizard
b.Form tool
c.Select All button
d.Database Wizard
b.Form tool
When using the Form Wizard, you can advance to a new dialog box by clicking the ____ button.

a.Forward
b.Advance
c.Ahead
d.Next
d.Next
The second Form Wizard dialog box asks you to select a ____ for the form.

a.layout
b.name
c.sort sequence
d.font type
a.layout
The Columnar and ____ layouts display the fields from one record at a time.

a.PivotTable
b.Tabular
c.Justified
d.Datasheet
c.Justified
Columnar, Tabular, Datasheet, and Justified are ____ choices.

a.PivotChart
b.PivotTable
c.layout
d.grouping
c.layout
The Form Wizard allows you to select one of ____ layout types.

a.three
b.four
c.six
d.eight
b.four
A picture is one of many ____ you can add to and modify on a form.

a.entities
b.labels
c.controls
d.units
c.controls
Bob needs to locate a particular customer record and view it in a form. What command would he use to locate the record?

a.Search
b.Find
c.Locate
d.Query
b.Find
Before you begin a Find operation on a form, you must first ____.

a.click the toolbar Find button
b.create a query
c.select a field
d.activate the Find command from the Edit menu
c.select a field
You specify the value you want to find in the ____ text box in the Find and Replace dialog box.

a.Find This
b.Find First
c.Find In
d.Find What
d.Find What
A search value can be an exact value or it can contain a ____.

a.logical operator
b.relational operator
c.wildcard character
d.comparison operator
c.wildcard character
The wildcard character ? in the search value a?t finds ____.

a.aft and ant and act and art
b.aft and ant but not act and art
c.art and act but not aft and ant
d.art and ant but not act and aft
a.aft and ant and act and art
In Form view, you can ____.

a.delete a record from the underlying table
b.edit the field values for a record
c.add a new record to the table
d.all of the above
d.all of the above
When a pencil symbol appears in the upper-left portion of the form, it means that the form ____.

a.is write-protected
b.has not been saved
c.is in editing mode
d.is being printed
c.is in editing mode
Access will only print ____.

a.one form record per page
b.two form records per page
c.three form records per page
d.as many form records as can fit on a printed page
d.as many form records as can
When printing a form, you can choose to print ____.

a.the currently selected form record
b.all pages
c.a range of pages
d.all of the above
d.all of the above
In ____ orientation, a page is wider than it is tall.

a.vertical
b.portrait
c.landscape
d.both a and b
c.landscape
Which of the following is NOT included by default at the bottom of the page in the Report Wizard?

a.author’s name
b.total number of pages
c.page number
d.current date
a.author’s name
A form that accesses data from two tables has a main form and a(n) ____.

a.secondary form
b.subform
c.related form
d.alternate form
b.subform
When you create a form containing data from two tables that have a one-to-many relationship, you create a(n) ____ for data from the primary table.

a.related form
b.main form
c.subform
d.object form
b.main form
In the accompanying figure, the arrow labeled 2 is pointing to the ____.

a.group by box
b.related table
c.primary table
d.none of the above
b.related table
In the accompanying figure, the arrow labeled 3 is pointing to the fields that will be on the ____.

a.main form
b.subform
c.bottom of the form
d.none of the above
a.main form
In the accompanying figure, what is the next step in the wizard?

a.Select the style for the form.
b.Select the name for the form.
c.Select the layout for the main form.
d.Select the layout for the subform.
d.Select the layout for the subform.
Access can assist you in creating a report by using the ____.

a.AutoReport Wizard
b.Report Generator
c.Report Wizard
d.Custom Formatter
c.Report Wizard
____ levels are useful for reports with multiple levels.

a.Grouping
b.Control
c.Record
d.Form
a.Grouping
You can toggle between a close-up view or a full-page view of your report in ____ by using the pointer.

a.Print Preview
b.Close Up
c.Page View
d.Magnify
a.Print Preview
Before applying a conditional format, you must select a ____.

a.field label
b.field value box
c.title bar
d.either a or b
b.field value box
Martha is concerned that her form data may be longer in length than the size of the field control. To check this, she should use ____.

a.Print Preview
b.Report Preview
c.Print Manager
d.either a or c
a.Print Preview
Griffin wants to create a form in which only the main form fields are displayed and not the fields from the subform. What option should he select in the Form Wizard?

a.Form with subform(s)
b.Form without subform(s)
c.Linked forms
d.Main form only
c.Linked forms
Emma is wondering about creating a report for the GEM database that is based on a query. Which of the following is NOT true?

a.She can create a report based on one or more tables or queries from her database.
b.She should consider creating the report first and then basing the query on that report, to produce the exact results she wants to see in the report.
c.When she uses a query as the basis for the report, she can use criteria and other query features to retrieve only the information she wants to display in the report.
d.She can create a query just so that she can create a report based on that query
b.She should consider creating the report first and then basing the query on that report, to produce the exact results she wants to see in the report.
In the accompanying figure, the options marked 1 are the _____ options.

a. group
b. category
c. tabular
d. object
b. category
Item 1 in the accompanying figure identifies the _____.
a. fields from the primary table
b. fields from the related table
c. report style
d. detail records
a. fields from the primary table
The fields from the ______ table are identified by item 2 in the accompanying figure.
a. primary
b. major
c. related
d. key
c. related
The query shown in the accompanying figure will select a record if _____.

a. Phone is blank
b. SigningDate is blank
c. City is Lansing and ContractAmt is greater than 25000
d. any of the above
c. City is Lansing and ContractAmt is greater than 25000