BUSA Access
An illustration of a one-to-many relationship would be: A unique city name relates to a single postal code. A branch location may contain many branch identification numbers. A balance field may contain many values. A customer ID may be related to multiple account numbers.
A customer ID may be related to multiple account numbers.
Which statement is NOT true when referential integrity is enforced? A record will not be added to the table if an ID that is referenced does not exist. Access checks the accuracy of spelling in the tables. You can trust that the data is reliable. Access will reject changes that update or delete if in violation of the referential integrity.
Access checks the accuracy of spelling in the tables.
A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control. T or F
False
A query is used to enter, edit, and view records in a database. T or F
False
A question asked about the data stored in a database is called a primary key. T or F
False
A table is a predesigned database that includes professionally designed database objects. T or F
False
Access automatically assigns the Number data type to all new fields. T or F
False
Access does not allow data to be imported from sources other than another Access database. T or F
False
All fields in a database should be contained in one table. T or F
False
Each record in a table is uniquely identified by a foreign key. T or F
False
It is more efficient to use the Query Wizard for common, informational queries than to design your own query. T or F
False
It is not possible to create a query from more than one table. T or F
False
A database or a relational database is a collection of related tables. T or F
True
A form created from more than one table uses the primary table for the main form. T or F
True
A form's object name appears on the tab for the form in the Access window. T or F
True
When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data. T or F
True
In Form view, you can ____. delete a record from the underlying table edit the field values for a record add a new record to the table all of the above
all of the above
You can modify an existing table's structure in ____. the Database window Form view Design view the Properties area
Design view
Field names in a table may only be changed in Design view. T or F
False
Hiding a field in Datasheet view removes the field from the current table. T or F
False
Results of a query are narrowed by using the Or logical operator. T or F
False
The Form Wizard limits fields to be used in a form to one table or one query. T or F
False
The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field. T or F
False
The default query type for Access is the Crosstab query. T or F
False
The only option available for creating tables in Access is to use the datasheet view. T or F
False
____ levels are useful for reports with multiple levels. Grouping Control Record Form
Grouping
Which of the following is NOT an example of an Access object? report query form Report tool
Report tool
A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). T or F
True
Access does not require a field description for every field included in a table. T or F
True
Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table. T or F
True
Changes made to a field in a query datasheet updates the same field in the table on which the query is based. T or F
True
Compacting a database rearranges the data and objects in a database to decrease its file size. T or F
True
Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. T or F
True
Fields included in a query may be modified after the query is saved. T or F
True
In order to define table relationships, each table being joined must contain a common field. T or F
True
Layout view shows both the form and its data while allowing the form to be modified. T or F
True
Logical operators must be used in order to combine two or more conditions in a query. T or F
True
Report fields and field value boxes may be repositioned while viewing the report in Layout view. T or F
True
The Columnar form layout displays the fields from one record at a time. T or F
True
The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view. T or F
True
The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. T or F
True
The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a datasheet. T or F
True
To toggle between navigation mode and editing mode press the F2 keyboard shortcut. T or F
True
When a question is asked of a database using a select query, the answer is returned as a datasheet. T or F
True
When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message. T or F
True
When selecting a primary key field, which of the following would be the most undesirable option Student identification number E-mail address Zip Code Cell Phone Number
Zip Code
A field defined as a Yes/No field type will be displayed as ____. a radio button Y or N a check box a null value
a check box
Access allows you to improve the appearance or readability of the results datasheet by changing the ____. font type font size column size all of the above
all of the above
When designing a new database, it is a good idea to ____. include redundant fields to provide data security avoid data redundancy include a common field in all tables use composite keys
avoid data redundancy
Data from separate tables can be connected by specifying a ____. common field hyperlink field value primary key
common field
If you need to connect one table to another in related fields, use a _____. common data type common field composite key foreign key
common field
Maintaining data using a form is often easier than using a(n) ____ because you can focus on all the changes for a single record at one time. roster datasheet index control layout
datasheet
In order to delete a record in a table, you must first ____. make sure the table has a primary key delete any related records in a sub-datasheet click off the expand indicator all of the above
delete any related records in a sub-datasheet
A calculation can be defined in a query by typing it directly into a Field box in the ____. design grid field list Relationship window criteria box
design grid
The fields and selection criteria for a query are included in the ____. field list datasheet toolbar design grid
design grid
You can choose a single field for a query by ____ the field name to place it in the next available design grid column. clicking double-clicking right-clicking hovering over
double-clicking
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
In the accompanying figure, each column represents a ____. record field table primary key https://gordonstate.view.usg.edu/content/enforced/166717-CO.760.BUSA2101.XLS.SS.20134/questioncollections/453894/nar001-1.jpg?_&d2lSessionVal=zKDeNAsfMJI1qAKFNGOczxVoe
field
The content of any given field is the ____. database table field value entity
field value
Before applying a conditional format, you must select a ____. field label field value box title bar either a or b
field value box
The first step in organizing data into a database is to identify the individual ____. records formats fields reports
fields
When designing a database, you need to identify the ____ that will be required. records fields reports field values
fields
For a(n) ____, the data from a record in the primary table appears as a group, followed on subsequent lines of the report by the joined records from the related table. linked report ungrouped report grouped report related report
grouped report
When a pencil symbol appears in the upper-left portion of the form, it means that the form ____. is write-protected has not been saved is in editing mode is being printed
is in editing mode
The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.
maintaining
A query based on more than one table is a(n) ____query.
multitable
A(n) ____ query is a query based on more than one table. consistent multitable many-to-one nonunique
multitable
The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.
primary
A field, or a combination of fields, that has a unique value is a ____. foreign key primary key table relation
primary key
The characteristics of a field, such as name, size, and type, are called the field ____. properties traits values qualities
properties
A ____ is a question you ask about data stored in a database. report form query macro
query
In the accompanying figure, the last row of data shown (11053, Hwan, Tang, etc.) is a ____. table field record key https://gordonstate.view.usg.edu/content/enforced/166717-CO.760.BUSA2101.XLS.SS.20134/questioncollections/453894/nar001-1.jpg?_&d2lSessionVal=zKDeNAsfMJI1qAKFNGOczxVoe
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
A form that accesses data from two tables has a main form and a(n) ____. secondary form subform related form alternate form
subform
The order in which fields are displayed in a query depends on ____. the order of the fields in the design grid how they are defined in the table the selection criteria the type of datasheet selected
the order of the fields in the design grid
Case-Based Critical Thinking Questions Case 3 Rossi Recycling Group Tom Rossi wants to work with and display data about the donations made to the Rossi Recycling Group. You'll help him by creating forms and a report in the Rossi database. Tom wants to see a list of all donations from the Donations table listed with first and last name of each donor on the same line. This would be a(n) ____ report. grouped ungrouped Columnar List
ungrouped
A primary key ____. must be numeric must be defined in each table uniquely identifies each record in a table is always the first field defined in a table
uniquely identifies each record in a table
