In what situation would excel be better choice than access

Assignment Help Operation Management
Reference no: EM13901901

1. All of the following are Access objects EXCEPT

       criteria.

       form.

       query.

       table.

2. In what situation would Excel be a better choice than Access?

       You have a limited amount of data.

       You have an extensive amount of data.

       You need to maintain constant connectivity to an external database.

       You require a relational view of your data.

3. The Navigation Pane allows you to:

       Open Tables

       Open Views

       Filter By Datatype

       Filter By Group and Navigate to Category

4. Filters are used to do all of the following EXCEPT

       a filter can be removed by selecting Remove Filter from the Sort & Filter group.

       all records in a table will be displayed if all of the filters are removed.

       filter effects are cumulative.

       it does not matter whether you apply a filter or a sort first.

5.. A report creation tool that will automatically pull in the fields from a table or query is the

       report tool.

       report design.

       report wizard.

       blank report.

6. A field that uniquely identifies each record in a table is a

       link.

       relationship.

       primary key.

       foreign key.

7 Which of the following is supported by a primary key? (Points : 5)

       Changeable over time

       May be null

       Unique

       Updateable

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.

9. All of the following summarize characteristics of a PivotChart EXCEPT

       a PivotChart is created automatically each time a PivotTable is created.

       changes made to a PivotTable will be made automatically to the PivotChart.

       some chart types are bar, line, column, pie, scatter, doughnut, and radar.

       PivotChart elements are modified in the Design View.

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.

11. When building a calculated field, formulas can be created using the

       form wizard.

       expression builder.

       report builder.

       table wizard.

Reference no: EM13901901

Questions Cloud

What is rationale for offering stock options as compensation : What is the rationale for offering stock options as compensation? Why has this form of compensation been particularly popular with technology firms in the past?
Operations can include all except : Operations can include all except; A company has been working a six-sigma program for several years, with a focus on improving yield on a key process. Prior to the program, the typical yields were averaging 70%. Presently, yields are consistently abo..
What is typically common about financial statement accounts : Provide several examples of financial statement accounts that are often loosely referred to as reserves. What is typically common about all financial statement accounts that are informally referred to as reserves?
Test hypothesis that median salary of financial accountants : Use these data to test the hypothesis that the median salary of financial accountants in 2007 was not greater than in 2004. What is the p-value?
In what situation would excel be better choice than access : All of the following are Access objects EXCEPT.  In what situation would Excel be a better choice than Access? Filters are used to do all of the following EXCEPT. A field that uniquely identifies each record in a table is a. All of the following summ..
Compute the times interest earned for park company : Interpret its times interest earned (assume that its competitors average a times interest earned of 4.0).
Prepare chart that lists line items reporte on balance sheet : From the perspective of the lessee, prepare a chart that lists the line items reported on the (a) income statement, (b) balance sheet, and (c) statement of cash flows under each reporting technique.
What is the p-value : To test the hypothesis that the median weight of 16-year-old females from Los Angeles is at least 110 pounds, a random sample of 200 such females was chosen. If 120 females weighed less than 110 pounds, does this discredit the hypothesis? U..
Text offers evidence of evolution : Your text offers evidence of evolution including: the fossil record, biogeography, comparative anatomy, comparative embryology, and molecular biology.

Reviews

Write a Review

 

Operation Management Questions & Answers

  How many orders will be placed each year

Pioneer Electronics buys video cards at $71 each. The annual demand is 11,475, the annual holding cost is 16% of the purchase price, and the set up cost is $1,085/order. If the order size is 926, how many orders will be placed each year?

  Which type of power has tom used over celia

The group laughs at Tom's joke, and Celia doesn't add any more input into the logo discussion. Which type of power has Tom used over Celia?

  Employment retirement income security act

Effective managers can successfully locate and apply relevant human resources laws and regulations. The United States Department of Labor website is an excellent source of reliable information. Consolidated Omnibus Reconciliation Act. Employment Reti..

  What has been the impact of the law

One of the consequences of the terrorist attack of 9/11 was the passage by Congress of the Patriot Act. From an HR perspective, what has been the impact of the law? Should Americans be asked to give up privacy for national security?

  Discuss how you determine others capabilities

Discuss how you determine others capabilities. If someone felt unprepared for a task you have assigned, what would you do?

  Identify key concepts theories and leadership models

Identify key concepts, theories and leadership models how can you apply this information to your organization-give examples. Summarize the results of your self-assessments

  Key elements of a total quality management

The vice president of manufacturing of your company, June Seymour, has asked you to send her an email that lists the key elements of a total quality management approach and outlines the benefits and risks of adopting a TQM approach for the company. C..

  The company''s main competitors for comparison purposes

Identify one of the company's main competitors for comparison purposes. You can find this information using company analysis tools such as Datamonitor.

  Customer service is the new marketing

Customer Service is the New Marketing, why is customer service even MORE critical as you move to a global business model

  Which of sectors of the economy would be most impacted

Which of the following sectors of the economy would be most impacted by technological developments?

  How can supervisors avoid receiving canned

How can supervisors avoid receiving "canned" or rote answers to interview questions? This question is about the Supervisor.

  Define social responsibility

Define social responsibility. How does this view of the role of business differ from your previous perceptions? How is it consistent with your attitudes and beliefs about business?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd