Author Question: There is no export command to move Access data to ________. Fill in the blank(s) with correct ... (Read 108 times)

kodithompson

  • Hero Member
  • *****
  • Posts: 566
There is no export command to move Access data to ________.
 
  Fill in the blank(s) with correct word

Question 2

Explain how an aggregate function differs from a calculated field.
 
  What will be an ideal response?



sokh

  • Sr. Member
  • ****
  • Posts: 357
Answer to Question 1

PowerPoint

Answer to Question 2

An aggregated function is a calculation that returns a single value, calculated from multiple values in a column. Common aggregate functions include Average, Count, Maximum, Median, Minimum, Mode, and Sum.
How an aggregated function differs from a calculated field is that when you create a calculated field, you are calculating or summarizing data across a single row at a time. However, when you create an aggregated field, you are calculating or summarizing data across entire groups of rows. The word aggregate simply means a summative calculation, such as a total or average, or summarizing data.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

For a complete list of videos, visit our video library