We Helped With This ACCESS Database Homework: Have A Similar One?

Question 1

*

5 points  

Question 2

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

True

False

1 points  

Question 3

In the accompanying figure, the red brackets designate which element of the Access 2013 window?

1 points  

Question 4

A combination of database fields, constants, and operators that are used to perform a calculation is called a(n) ____.

1 points  

Question 5

The label attached to a bound control displays which of the following?

1 points  

Question 6

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

1 points  

Question 7

Which button is used to open and close the Navigation Pane?

1 points  

Question 8

Number signs indicate that a text box has been resized too small to display the contents properly.

True

False

1 points  

Question 9

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane.

True

False

1 points  

Question 10

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.

True

False

1 points  

Question 11

Results of a query are narrowed by using the Or logical operator.

True

False

1 points  

Question 12

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

1 points  

Question 13

The Columnar form layout displays the fields from one record at a time.

True

False

1 points  

Question 14

A form created from more than one table uses the primary table for the main form.

True

False

1 points  

Question 15

Yes/No field values are stored in an Access database as a -1 for a checked value and a 0 for an unchecked value.

True

False

1 points  

Question 16

Which Access 2013 view contains commands used to manage Access files and options?

1 points  

Question 17

A form’s object name appears on the tab for the form in the Access window.

True

False

1 points  

Question 18

When there is a finite number of choices for a form entry, a combo box control should be used.

True

False

1 points  

Question 19

A query is used to enter, edit, and view records in a database.

True

False

1 points  

Question 20

This icon represents which Access 2013 object?

1 points  

Question 21

It is not possible to create a query from more than one table.

True

False

1 points  

Question 22

The record source for a subform must be a table.

True

False

1 points  

Question 23

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

1 points  

Question 24

The expression =Sum([InvoiceAmt]) might be found in which type of control added to a form?

1 points  

Question 25

Access designates all queries in the Navigation Pane with the same icon regardless of the query type.

True

False

1 points  

Question 26

Hiding a field in Datasheet view removes the field from the current table.

True

False

1 points  

Question 27

The specific content of a field is referred to as the ____.

1 points  

Question 28

In the accompany figure, editing mode is indicated by which numbered arrow?

1 points  

Question 29

Which type of report does the accompanying figure illustrate?

1 points  

Question 30

In the accompanying figure, the ____ field has been selected to be moved in the Design view.

1 points  

Question 31

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

1 points  

Question 32

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

1 points  

Question 33

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.

True

False

1 points  

Question 34

Case Based Critical Thinking Questions
Case 5-2
Carlos has developed a database for his organic farm.  The farm sells organic produce and meat.  In addition to the retail sales of his products, he offers cooking demonstrations five times each month for a small fee.  The demonstrations are limited to 10 people.  The database contains the following tables: Products, ProductPrices, ProductCosts, Suppliers, Customers, and CookingDemos. The Products, Product Prices, Product Costs and Suppliers tables are related using the ProductID field. The Customers and CookingDemos tables are related on the CustomerID field. Carlos needs to make some decisions using his database. Determine the best method for Carlos to use to achieve the results he wants.

Carlos would like to create a query based on the Customer table that allows him to type in the name of the cooking demonstration for which the query will run.  Which type of query should Carlos create so that he can type in the name of the cooking demonstration before the query runs?

1 points  

Question 35

The Access database object named tblProductCatalog is mostly likely an Access form object.

True

False

1 points  

Question 36

Each record in a table is uniquely identified by a foreign key.

True

False

1 points  

Question 37

A pattern match selects records whose values for the designated field matches one of two or more simple condition values.

True

False

1 points  

Question 38

Layout view shows both the form and its data while allowing the form to be modified.

True

False

1 points  

Question 39

The + symbol is an example of a(n) ____ operator.

1 points  

Question 40

Compacting a database rearranges the data and objects in a database to decrease its file size.

True

False

1 points  

Question 41

Text box controls arranged vertically in Form Design view with a label control to the left of each text box control is the tabular layout.

True

False

1 points  

Question 42

When a question is asked of a database using a select query, the answer is returned as a datasheet.

True

False

1 points  

Question 43

The aggregate function which returns the number of nonnull field values is the ____ function.

1 points  

Question 44

A calculated query uses aggregate functions to perform arithmetic operations on selected records.

True

False

1 points  

Question 45

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

1 points  

Question 46

Tab order may only be changed in form Design view.

True

False

1 points  

Question 47

A value of true will be returned if a field is empty when the IsNull function is used.

True

False

1 points  

Question 48

In the accompanying figure, the plus sign beside the record indicated by arrow number 2 indicates that this record ____.

1 points  

Question 49

A nonnull field is a field that contains any data at all, including a single space.

True

False

1 points  

Question 50

The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.

True

False

1 points  

Question 51

Case Based Critical Thinking Questions
Case 6-3
Akash created a custom form for his supervisor that includes a subform based on a query for unpaid invoices.  After creating the form and viewing it in Form view, Akash needs to make some changes.  Decide which options are best for Akash to use to make the necessary changes to the custom form design.

Akash has included a calculated field in the subform which was created using a query for unpaid invoices.  The calculated field should show the total amount of unpaid invoices from the InvoiceAmt field; however, the form does not show the calculation in Form view. Which expression will solve this problem?

1 points  

Question 52

The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

1 points  

Question 53

In the accompanying figure, which button on the ribbon should be used to add a table to the Relationship window?

1 points  

Question 54

Case-Based Critical Thinking Questions
Case 4-1
Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling.  The tables in the database and the fields for each table are illustrated in the figure below.


After reviewing the form Sergio decides he wants to create a form that will allow Carmen to enter both the participant information and the amount due by the participant.  Sergio will need to use two tables to accomplish this.  The second table will be the ___ in the form.

1 points  

Question 55

A form may only be created from scratch in Form view.

True

False

1 points  

Question 56

A table is a predesigned database that includes professionally designed database objects.

True

False

1 points  

Question 57

Data in Date/Time fields are automatically ____-aligned.

1 points  

Question 58

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.

True

False

1 points  

Question 59

A question asked about the data stored in a database is called a primary key.

True

False

1 points  

Question 60

A form created from two tables that have a ____ relationship creates a main form and a subform.

1 points  

Question 61

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.

True

False

1 points  

Question 62

A customizable form that displays multiple records from a source table or query in a datasheet format may be created using the ____ form tool.

1 points  

Question 63

A selected column of controls may be aligned to the left or right edges of the controls using the ARRANGE tab on the ribbon.

True

False

1 points  

Question 64

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.

True

False

1 points  

Question 65

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a(n) ____ relationship.

1 points  

Question 66

In the accompanying figure, the Table Tools tab is an example of this type of tab that appears and provides options for working with a specific object when the object is selected.

1 points  

Question 67

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.

True

False

1 points  

Question 68

Crosstab queries may use which of the following aggregate functions?

1 points  

Question 69

The default query type for Access is the Crosstab query.

True

False

1 points  

Question 70

It is more efficient to use the Query Wizard for common, informational queries than to design your own query.

True

False

1 points  

Question 71

The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.

1 points  

Question 72

A value that is the result of an expression is displayed in which type of control in a form?

1 points  

Question 73

Case Based Critical Thinking Questions
Case 5-1
Janise is creating a database to keep track of her customers for her pet sitting business. She is in the process of creating the Customer table.  She would like to design the table so that data entry is as consistent and accurate as possible. Using the figures below, determine which Access features Janise used to ensure consistent and accurate data entry.

 
   Figure Case 5-1-1

  Figure Case 5-1-2

According to the Field Properties in Figure Case 5-1-2, to which field has Janise assigned an input mask?

1 points  

Question 74

In the accompanying figure, the ____ Access database object is indicated by the icons shown in bracket number 3.

1 points  

Question 75

Access does not allow data to be imported from sources other than another Access database.

True

False

1 points  

Question 76

Which aggregate function supports the Yes/No field data type?

1 points  

Question 77

Access automatically assigns the Number data type to all new fields.

True

False

1 points  

Question 78

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

True

False

1 points  

Question 79

Which data type allows both positive and negative numbers as field values?

1 points  

Question 80

Which view is used to make design changes to a form while the form is displaying data?

1 points  

Question 81

Case Based Critical Thinking Questions
Case 6-2
Janise’s College Pet Sitting business is growing rapidly.  She has expanded to include more pet sitters and is creating forms for the sitters to enter information in the business database. She is creating only custom forms. Determine the best methods, features, and tools for Janise to use when creating her custom forms.

Before typing the title, which tool should Janise choose from the DESIGN tab on the Ribbon?

1 points  

Question 82

A query that selects records in fields that satisfy the criteria is a Select query.

True

False

1 points  

Question 83

Logical operators must be used in order to combine two or more conditions in a query.

True

False

1 points  

Question 84

The Record Source property specifies the table or query on which a form is based.

True

False

1 points  

Question 85

Fields included in a query may be modified after the query is saved.

True

False

1 points  

Question 86

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.

1 points  

Question 87

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

True

False

1 points  

Question 88

A database or a relational database is a collection of related tables.

True

False

1 points  

Question 89

In order to define table relationships, each table being joined must contain a common field.

True

False

1 points  

Question 90

In the accompanying figure, once the selected field is moved it will appear above which field in Design view?

1 points  

Question 91

An input mask property cannot be changed after the Input Mask Wizard closes.

True

False

1 points  

Question 92

In the accompanying figure, the ____ for the current field is/are indicated in the box designated by the arrow.

1 points  

Question 93

The Form Wizard limits fields to be used in a form to one table or one query.

True

False

1 points  

Question 94

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.

1 points  

Question 95

Case-Based Critical Thinking Questions
Case 4-2
Carmen and Sergio have created a database for the Spring Fling event at their college.  Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event.  The tables and fields for the database along with established relationships are illustrated in the figure below.


The faculty sponsor has asked Carmen to create a report that includes the participant email address and the location site assigned to the participant. He would also like to know how many tables and chairs each participant needs. Which tables and fields does Carmen need to use to create the report?

1 points  

Question 96

When choosing field names, it is best to choose names that ____.

1 points  

 Save and Submit

Click Save and Submit to save and submit. Click Save All Answers to save all answers.