Access interface element, Which object would you use to

Access interface element

Assignment Help Other Subject

Reference no: EM13750496

Question 1. To delete the filter shown below

click Filter in the Sort & Filter group and select Clear Filter.

click Remove Filter in the Sort & Filter group.

right click on any number in the Quantity column and select Clear filter from Quantity.

right click on any record in the table and select Clear filter from Quantity.

Question 2. Which object would you use to retrieve customers who live in Germany and the United States?

Criteria

Form

Query

Table

Question 3. Which of the following is NOT an Access interface element?
Criteria

Navigation Pane

Status Bar

Title Bar

Question 4. All of the following filters work EXCEPT
filter by selection with an equal condition.

filter by selection with a comparison operator.

filter by selection with an edit operator.

filter by form with a comparison operator.

Question 5. A Detail line is used to
print more detailed information on one record only.

provide additional field information on a record.

repeat data for each record in the record source.

All of the above

Question 6. The number of records in a relationship is a(n)
cardinality.

domain.

entity.

key.

Question 7. Which of the following should be considered when designing a database?
How calculated fields are used

Store data in its smallest parts

The relationship between attribute keys

The relationships between records

Question 8. All of the following apply to the relationships image found below EXCEPT

a one-to-many relationship is found between the Suppliers table and the Products table.

a relationship exists between the two primary keys of the Suppliers table and the Products table.

one table is not joined to the two other tables.

the primary key for the Categories table is CategoryID.

Question 9. Summarized data in an easy-to-read view is known as a
design.

PivotTable.

report.

table.

Question 10. Which of the following is NOT true of a property?

A property is an object's characteristic or attribute.

Tables, forms, queries, and reports have a set of properties.

A property sheet is used to make changes.

Design properties are displayed in Datasheet View.

Question 11. In a ________ dependency, a relationship exists when one attribute uniquely identifies another attribute. For example, if we had a table consisting of the following attributes: instructor, course, time and room number. Course would uniquely identify an instructor.
Structural

Functional

Referential

Transitive

1. To edit a form, use datasheet view.

design view.

layout view.

layout view or design view.

Question 2. A bound control always contains a label.

contains text and number values entered by the user.

is unique and contains a data field from another underlying source.

must contain a formula.

Question 3. Which of the following statements is NOT correct about a query?
Changing data values in a query will not change data values in a table.

Data is not saved within a query.

Instructions on which data to display are saved within a query.

Instructions on the format to display data are saved within a query.

Question 4. The benefit of a relationship is to efficiently combine data from related tables.

facilitate how Access will manage the relationship.

determine which fields to include in each table.

minimize data redundancy.

Question 5. To display continuous data, use the following chart.
Bar

Column

Pie

Line Chart

Question 6. Which of the following statements best describes data mining?
It is the determining of future volume of sales.

It is the predicting of future customer buying behavior.

It is identifying patterns or relationships through a process of analyzing large quantities of data.

It is tracking customer purchasing behavior.

Question 7. The Switchboard Manager is an Access utility that is used
by all database users.

to create and manage the menu items for a switchboard.

to make certain objects unavailable to some users and available to others.

to manage and optimize the database.

Question 8. A good password should have
a combination of five letters.

a combination of six to eight letters in uppercase and lowercase, numbers, and symbols.

a word or name that is easy to remember by the user, such as the name of your children.

part of your account name.

Question 9. All of the following are true when a user creates their own self-signed digital signature EXCEPT
a time stamp is not required to go through a commercial service or local server for processing.

a time stamp will prove when the file was last used.

it is created through another software application.

it will prove that the creator owns the database.

Question 10. After creating an ACCDE file, you
can convert it back to its source format.

will see a "file already in use" message that continues to display to all other users.

will be able to modify forms and reports but not tables.

will need to go back to the original file if an underlying object requires a change.

Question 11. Which statement below is NOT true of the one-to-many relationships?

It is the least used type of relationship.

OrderID is a unique identification number that would be used in the Orders table and Order Details table.

Each record in the Orders table may match one, more than one, or no records in the Order Details table.

Each record in a Orders table matches only one record in the Customers table.

Reference no: EM13750496

Questions Cloud

Describe the major network security organizations : As a member of the Network Security group, you have been asked to serve on the committee and to take the initiative in the following: 1. Describe the major network security organizations. 2. Identify risks, threats, vulnerabilities and countermeasu..

Way in which the malware was utilized to steal data : From the selected e-Activity article, describe in detail the way in which the malware was utilized to steal data or gain privileged remote access to a computer or network

Describe each rule and discuss common violations : What are some of the questions that you would ask to determine what should be on the report? For one of your questions, give an example of two different answers the manager might give and tell how each answer would affect the report design.

Create a supplier database and related reports : Create a supplier database and related reports and queries to capture contact information for potential PC component suppliers that might be used to purchase the equipment your specified in your MS Word project - the PC specifications

Access interface element : Which object would you use to retrieve customers who live in Germany and the United States - Which of the following statements is NOT correct about a query?

Create a powerpoint on national youth administration : Create a powerpoints done for a group project that working on these are the topics. National youth, administration, Peurto rico reconstruction admin, Reciprocal tariff act and federal housing admin.

What is the after-tax cost of debt : The 8.5 percent annual coupon bonds of the ABC Co. are selling for $1,179. The bonds mature in 12 years. The bonds have a par value of $1,000. If the tax rate is 30%, what is the after-tax cost of debt?

Udo marian & uduak corporation case study : This assignment is based on the Udo, Marian, & Uduak Corporation (UMUC) Case Study. The focus will be on developing a C-level executive (CEO, CFO, COO, CIO) briefing on an IT best practice and a justification for implementation

What is the height and radius with the largest volume : A cylinder (circular top and bottom) with total surface area of 10pi (cm^2). What is the height and radius with the largest volume. (Optimization question)

User Account

All Pages