A collection of customer information

Assignment Help Basic Computer Science

Reference no: EM13775413

1. A collection of customer information and purchase transactions that might be stored in both Access and Excel would be called a_____

Field
Record
Table
Database

2. You should use Access over Excel when:

you have a large amount of data.
you need to create complex charts.
you have only one worksheet to handle all of your data.
you have extensive subtotals and totals in your worksheet.

3. Examining the image below, which statement best describes what we see?

Six records have been filtered from a query called Employees.
Six records have been filtered on the Title field containing Sales Representative from the Employees table.
A table called Employees has been created from six filtered records.
A query called Employees has been created from a filtered table.

4. Access should be used instead of Excel when

a nonrelational view of the data is needed.
you need to run various comparisons of statistical and comparative data.
you need to sort, group, and total data in various views.
you only need a smaller, manageable amount of data.

5. On which tab is the Sort & Filter group found?

File
Home
Create
External Data

6. In using a web search engine, typing the web site address in the proper place in the brower and then hitting enter is called

server setup.
presentation task.
client browsing.
systems application.

7. Types of relationships between tables do NOT include

one-to-one
many-to-many
primary-to-foreign
many-to-one

8. To display a subset of records based on certain criteria, use which of the following?

Filter
Form
Report
Table

Reference no: EM13775413

Questions Cloud

How the specific event affected the civil rights movement : Include the following in your timeline: Date of each event, Description of each event and why you included it, The vulnerable class intended for protection and How the specific event affected the civil rights movement

Write a paper on the book the alchemist : Write a paper on the book THE ALCHEMIST.

Problems based on articals : Describe and explain how the specific style of art is related to the cultural changes brought about by the wars.

Analyze and explain how you would use dns in your plan : Analyze the functional problems of throughput, delay, and packet loss as it pertains to your plan. Analyze and explain how you would use DNS in your plan.

A collection of customer information : A collection of customer information and purchase transactions that might be stored in both Access and Excel would be called

Assginment regarding the influence of peers : The influence of peers during childhood can have a long-lasting effect on a person throughout his or her life. In this assignment, keep in mind at least three different ways in which teachers and/or parents can intervene to help improve a child's ..

Achieve managements target net income : For Flynn Company, variable costs are 69% of sales, and fixed costs are $190,000. Management’s net income goal is $26,070. Compute the required sales in dollars needed to achieve management’s target net income of $26,070. (Use the contribution margin..

Briefly discuss what is meant by a reversible solution : Define and briefly explore the notion of strong reciprocity, including some consideration for the role of altruistic punishment. Briefly discuss what is meant by a "reversible solution." Briefly discuss what is implied by the notion of "moral develop..

How digital media used to influence business processes : how digital media has been used to influence or has changed core business processes within organizations or for individuals.

User Account

All Pages