BA120 Test 2 – Flashcards

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?

The value of a field containing no information is a ____ value.

The calculated expression =City & "," & State & " " & ZipCode is an example of ____.

In the accompanying figure, what is the condition for the calculated expression?

In the accompanying figure, which of the following is the truepart of the calculated expression?

In the accompanying figure, which of the following is the falsepart of the calculated expression?

Which of the following is an example of a parameter query prompt criterion?

To add more flexibility and functionality to a parameter query, comparison operators, such as ___, may be added to the original criterion.

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

The accompanying figure is an example of criteria for a ____ query using the Query Wizard.

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.

In crosstab query results, the value of a checked Yes/No data type field will display as ____.

In the accompanying figure, what is the Top Values property that has been set for the qryLargeInvoiceAmounts?

Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number?

A Social Security Number which appears in the format 123-456-7891 is an example of a(n) ____.

In the accompanying figure, object dependencies are shown for the ____ object.

In the accompanying figure, the frmPatient object is dependent on the ____ object.

Validation Rules are entered in the ____

To avoid the display of a security warning when opening a database, place the database ____.

In the accompanying figure, which field property will appear on the screen if the user enters the value 5 in the InvoiceAmt field in datasheet view?

Which Access object(s) may be used when creating a lookup field to select values?

The State field in Figure Case 5-1-1 illustrates which of the following?

To ensure that all telephone numbers are entered in a consistent manner, Janise assigned a(n) ____ to the PrimaryPhone field as illustrated in 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?

The 9999 included in the Input Mask property in Figure Case 5-1-2 indicates that data entry is ____ for that part of the field.

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

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?

A criterion may be negated by using the ____ logical operator.

What best matches with the Relational Database Terminologies A, B, and C depicted in the representation below?

Chris is trying to normalize the following table to the 3NF. Which of the following is not correct?

In this table, which is not showing a partial dependency?

In this table, which is showing a transitive dependency?

In order to normalize the employee table, Jay decomposed in into two tables as below. Which of the following is NOT a correct statement about this results?

Which of the following is not one of the three(3) data anomalies?

Which of the following represent Referential Integrity of relational database?

Which view or tool allows the form designer the most control and precision when designing a form?

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

In the accompanying figure, the control type for the selected control is a ____.

To find records in a form using a Combo box, it is necessary to change the ____ form property of the form to the table or query that is the source for all the bound controls in the Detail section.

The number of occurrences of an expression is determined using the ____ function in a form or report.

Only a field name or an expression may be used for the ____ property in a calculated control.

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

Set the ____ property to No to prevent users from using the Tab key to navigate to a control.

Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property.

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom.

Flat, Raised, Sunken, Etched, Shadowed, and Chiseled are options for the ____ control property.

Which key on the keyboard may be used to ensure that a horizontal or vertical line is straight when adding a line to a form or report?

A control that combines the features of a text box and a list box is a ____.

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?

Which form tool displays data in both Form view and Datasheet view at the same time?

The Access tool that allows the user (or designer) to create detailed documentation of all, or selected, objects in a database is the ____.

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 used the Header section in his main form design, but he does not plan to use the Footer section. To remove the footer section, which section property should be set to zero?

A chart created with the Access Chart Wizard is ____ in Access.

Which of the following is the file extension associated with an Access template?

To use an application part in an existing database, choose ____ from the CREATE tab on the ribbon to view the application parts gallery..

Which Excel external data option automatically updates a table in the Access database when the Excel source file is updated?

Data in an Access table linked to an Excel source file may be edited using which process?

Values in a CSV file are separated by which symbol?

Case Based Critical Thinking Questions Case 8-2 Brij has just been promoted to Marketing Manager of a non-profit organization responsible for soliciting over three million dollars in donations annually. His company solicits donor information from local chapters of the non-profit organization. Brij decides to create an Access database that will allow him to keep all donor information in one database and create reports as well as marketing documents using the database. Based on your knowledge of importing and sharing Access data, answer the questions below. Brij has contacted each local chapter of the non-profit organization and asked for local donor information. Some local chapters use Excel to record the information, some use Access, and some use other database or spreadsheet applications. To streamline the import process, Brij has asked each local chapter to send him the information in a(n) ____ document that is well suited for data exchange among many different programs.

Case Based Critical Thinking Questions Case 8-2 Brij has just been promoted to Marketing Manager of a non-profit organization responsible for soliciting over three million dollars in donations annually. His company solicits donor information from local chapters of the non-profit organization. Brij decides to create an Access database that will allow him to keep all donor information in one database and create reports as well as marketing documents using the database. Based on your knowledge of importing and sharing Access data, answer the questions below. Brij has already created the table structure he wants to use in his database. Therefore, when he imports the data from the local non-profit organizations, he will ____ the data to his existing table

Brij has just been promoted to Marketing Manager of a non-profit organization responsible for soliciting over three million dollars in donations annually. His company solicits donor information from local chapters of the non-profit organization. Brij decides to create an Access database that will allow him to keep all donor information in one database and create reports as well as marketing documents using the database. Based on your knowledge of importing and sharing Access data, answer the questions below. The local non-profit offices update their donor information every quarter. Brij will find it necessary to update the database by using the same import specifications four times a year. Which process would expedite this task for Brij?

Case Based Critical Thinking Questions Case 8-2 Brij has just been promoted to Marketing Manager of a non-profit organization responsible for soliciting over three million dollars in donations annually. His company solicits donor information from local chapters of the non-profit organization. Brij decides to create an Access database that will allow him to keep all donor information in one database and create reports as well as marketing documents using the database. Based on your knowledge of importing and sharing Access data, answer the questions below. Brij has been asked to share a report with the non-profit's Board of Directors which lists all donors by state. Brij created a query to appropriately sort the data and generated the report using Access. The report will be shared using e-mail. Which option is Brij most likely to choose to share this information?

In the accompanying figure, arrow number one indicates ____ for the data being imported into Access.

In the accompanying image, the selected field has been assigned which Data Type?

The process of identifying and eliminating anomalies from a collection of tables is called ____.

The default encoding method for exporting Access data to an XML file is UTF-8, which uses 8 bits to represent each character.