Common Controls in Access: Calculated Control

# Common Controls in Access: Calculated Control Video Lecture | SSC CGL Tier 2 - Study Material, Online Tests, Previous Year

## SSC CGL Tier 2 - Study Material, Online Tests, Previous Year

1375 videos|1309 docs|994 tests

## FAQs on Common Controls in Access: Calculated Control Video Lecture - SSC CGL Tier 2 - Study Material, Online Tests, Previous Year

 1. What is a calculated control in Access?
A calculated control in Access is a control on a form or report that displays the result of a calculation based on the values of other controls or fields. It allows you to perform calculations and display the results dynamically, without storing the calculated values in a table.
 2. How do I create a calculated control in Access?
To create a calculated control in Access, you need to open the form or report in design view, select the control where you want the calculated result to be displayed, and then set its Control Source property to an expression that performs the calculation. This expression can include references to other controls or fields, as well as mathematical operators and functions.
 3. Can I use conditional statements in a calculated control?
Yes, you can use conditional statements in a calculated control in Access. By using the IIf function, you can specify a condition and provide different calculations or values based on whether the condition is true or false. This allows you to create dynamic calculations that adapt to different scenarios.
 4. Can I use aggregate functions in a calculated control?
Yes, you can use aggregate functions in a calculated control in Access. Aggregate functions like SUM, AVG, COUNT, MIN, and MAX can be used to calculate values based on a set of records. By referencing the appropriate fields or controls in your expression, you can perform calculations such as summing the values of a specific field or counting the number of records that meet certain criteria.
 5. Are calculated controls only for forms and reports?
No, calculated controls are not limited to forms and reports in Access. You can also use calculated controls in queries to perform calculations on data retrieved from tables or other queries. This allows you to create calculated fields in queries that display the results of calculations alongside other fields from the underlying data sources.

## SSC CGL Tier 2 - Study Material, Online Tests, Previous Year

1375 videos|1309 docs|994 tests

### Up next

 Explore Courses for SSC CGL exam
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev
Related Searches

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

;