For Access 2019, I need a question answered. I am not sure if you know how to answer this or not. I will provide an attachment of the Expression Builder and the table so you can see what I need done. Here is the question: "Modify the expression in the calculated MonthlyFee field to return to 12 instead of 10 for the false part of the condition." I do not know how to approach this area. If someone can explain this to me, I would appreciate it. After I click on Modify Expression the Expression Builder pops up, and after that, I do not understand. Thanks. I am attaching the imaging.
For Access 2019, I need a question answered. I am not sure if you know how to answer this or not. I will provide an attachment of the Expression Builder and the table so you can see what I need done. Here is the question: "Modify the expression in the calculated MonthlyFee field to return to 12 instead of 10 for the false part of the condition." I do not know how to approach this area. If someone can explain this to me, I would appreciate it. After I click on Modify Expression the Expression Builder pops up, and after that, I do not understand. Thanks. I am attaching the imaging.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
100%
For Access 2019, I need a question answered. I am not sure if you know how to answer this or not. I will provide an attachment of the Expression Builder and the table so you can see what I need done. Here is the question: "Modify the expression in the calculated MonthlyFee field to return to 12 instead of 10 for the false part of the condition." I do not know how to approach this area. If someone can explain this to me, I would appreciate it. After I click on Modify Expression the Expression Builder pops up, and after that, I do not understand. Thanks. I am attaching the imaging.
![GradinglnfoTable X
E Clients X
ClientID
FirstName
LastName i DateOfBirth - Gender
StartDate
- StrengthScore - FlexibilityScore -
Veteran
- MonthlyFee - InsuranceCo - Click to Add -
4.
8/16/2018
8/25/2018
8/17/2018
+ 00076
Abbott
5/16/1930 F
Mary
Sarah
1.0
9.4
10 AET
+ 16488
Aber
7/28/1923 F
8 AET
10.0
9.0
+ 81501
Carter
Adams
4/26/1927 M
3.0
9.4
10 WEL
8 MET
8/14/2018
8/19/2018
8/1/2018
+ 87981
Carol
Adams
12/19/1936 F
6.0
1.6
+ 96487
Robert
Adcox
10/30/1947 M
Expression Builder
+ 00078
Doris
Adelman
6/6/1913 F
Enter an Expression to calculate the value of the calculated column:
+ 12722
Nancy
Adler
10/4/1928 F
8/8/2018
(Examples of expressions include [field 1] + [field2] and [field 1] < 5)
+ 88880
Robert
Ahring
3/23/1949 M
8/21/2018
IIF([StrengthScore]>5,8, 10)|
OK
6/20/1950 M
3/25/1936 M
+ 69282
Bara
Aikey
8/19/2018
+ 67787
Pedro
Albin
8/15/2018
Cancel
+ 51318
Jerold
Alderman
3/22/1972 M
8/4/2018
Help
8/11/1962 F
10/17/1965 M
3/25/1935 F
+ 86654
Taylor
Alewel
8/22/2018
<< Less
+ 31948
Ellis
Alexander
8/25/2018
Expression Elements
Expression Values
Expression Categories
ClientID
FirstName
LastName
DateOfBirth
Gender
+ 57800
Carolin
Allen
8/6/2018
Clients
<Value>
+ 13755
Garnett
Allen
3/25/1937 M
8/9/2018
+O Functions
Constants
+ 48057
Larry
Allen
12/26/1952 M
8/4/2018
+ 41774
Vivien
Allen
7/10/1918
8/28/2018
a Operators
4/26/2004 F
3/5/1970 F
+ 00033
Tedene
Allen
8/21/2018
StartDate
StrengthScore
FlexibilityScore
Veteran
CognitiveScore
MonthlyFee
8/6/2018
8/6/2018
+ 98237
Katherine
Alumbaugh
+ 53090
Nancy
Amick
1/22/1955 F
+ 51159
Kai
Anderson
2/6/1934 M
8/1/2018
+ 00046
Eleanor
Anderson
10/24/1918 F
8/24/2018
+ 97977
Angela
Anderson
10/6/1981 F
8/23/2018
+ 12532
Wally
Anderson
2/9/1915 M
8/17/2018
+ 86290
John
Andrews
4/17/1920 M
8/24/2018
8 CIG
10.0
b.1
+ 36930
Angel
5/11/1933 F
8/8/2018
8 MET
Rosetta
6.0
3.4
+ 77340
Carla
Antal
3/8/1948 F
8/7/2018
3.0
3.0
10 KAI
+ 65578
Roxanne
Antrim
1/21/1927
8/11/2018
9.0
7.5
8 UHO
+ 65579
Robert
Antrim
11/7/1926 M
8/12/2018
9.0
9.7
8 MET
+ 86116
Kathy
Apley
8/24/1952 F
8/15/2018
6.0
4.4
8 AET
+ 96312
Richard
Arbuckle
12/3/2007 M
8/26/2018
6.0
9.7
8 UHO
+ 81447
Stephanie
Arbuckle
9/8/1941 F
8/2/2018
3.0
5.7
10 KAI
+ 91379
Jorge
Archibald
7/23/1979 M
8/25/2018
5.0
4.0
10 CIG
+ 54523
Maureen
Arcibald
4/11/1964 F
8/26/2018
8.0
8.6
8 CIG
+ 87592
John
Armstrong
8/27/1950 M
8/14/2018
3.0
4.4
10 CIG
8/23/2018
8/1/2018
8/2/2018
+ 38605
Eugene
Arney
11/22/1922 M
2.0
3.4
10 AET
+ 75355
Janice
Arth-Brown
10/25/1948 F
8.0
4.9
8 KAI
+ 13799
Manuel
Ashe
4/19/1959 M
9.0
7.5
8 ВСВ
+ 58731
Walter
Atkins
11/25/1935 M
8/15/2018
9.0
9.4
8 BCB
+ 54264
12/23/1953 F
8/11/2018
Atkins
RUnfiltered Search
Sue
4.0
4.0
10 CAR
Record: 14
41 of 1672
I *
JODDOO0000000000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb58de12c-8bc1-4640-b28d-50b0e6dcfd1e%2F05c53cac-1ffa-40dd-b257-78031946925c%2F1nhad4l_processed.png&w=3840&q=75)
Transcribed Image Text:GradinglnfoTable X
E Clients X
ClientID
FirstName
LastName i DateOfBirth - Gender
StartDate
- StrengthScore - FlexibilityScore -
Veteran
- MonthlyFee - InsuranceCo - Click to Add -
4.
8/16/2018
8/25/2018
8/17/2018
+ 00076
Abbott
5/16/1930 F
Mary
Sarah
1.0
9.4
10 AET
+ 16488
Aber
7/28/1923 F
8 AET
10.0
9.0
+ 81501
Carter
Adams
4/26/1927 M
3.0
9.4
10 WEL
8 MET
8/14/2018
8/19/2018
8/1/2018
+ 87981
Carol
Adams
12/19/1936 F
6.0
1.6
+ 96487
Robert
Adcox
10/30/1947 M
Expression Builder
+ 00078
Doris
Adelman
6/6/1913 F
Enter an Expression to calculate the value of the calculated column:
+ 12722
Nancy
Adler
10/4/1928 F
8/8/2018
(Examples of expressions include [field 1] + [field2] and [field 1] < 5)
+ 88880
Robert
Ahring
3/23/1949 M
8/21/2018
IIF([StrengthScore]>5,8, 10)|
OK
6/20/1950 M
3/25/1936 M
+ 69282
Bara
Aikey
8/19/2018
+ 67787
Pedro
Albin
8/15/2018
Cancel
+ 51318
Jerold
Alderman
3/22/1972 M
8/4/2018
Help
8/11/1962 F
10/17/1965 M
3/25/1935 F
+ 86654
Taylor
Alewel
8/22/2018
<< Less
+ 31948
Ellis
Alexander
8/25/2018
Expression Elements
Expression Values
Expression Categories
ClientID
FirstName
LastName
DateOfBirth
Gender
+ 57800
Carolin
Allen
8/6/2018
Clients
<Value>
+ 13755
Garnett
Allen
3/25/1937 M
8/9/2018
+O Functions
Constants
+ 48057
Larry
Allen
12/26/1952 M
8/4/2018
+ 41774
Vivien
Allen
7/10/1918
8/28/2018
a Operators
4/26/2004 F
3/5/1970 F
+ 00033
Tedene
Allen
8/21/2018
StartDate
StrengthScore
FlexibilityScore
Veteran
CognitiveScore
MonthlyFee
8/6/2018
8/6/2018
+ 98237
Katherine
Alumbaugh
+ 53090
Nancy
Amick
1/22/1955 F
+ 51159
Kai
Anderson
2/6/1934 M
8/1/2018
+ 00046
Eleanor
Anderson
10/24/1918 F
8/24/2018
+ 97977
Angela
Anderson
10/6/1981 F
8/23/2018
+ 12532
Wally
Anderson
2/9/1915 M
8/17/2018
+ 86290
John
Andrews
4/17/1920 M
8/24/2018
8 CIG
10.0
b.1
+ 36930
Angel
5/11/1933 F
8/8/2018
8 MET
Rosetta
6.0
3.4
+ 77340
Carla
Antal
3/8/1948 F
8/7/2018
3.0
3.0
10 KAI
+ 65578
Roxanne
Antrim
1/21/1927
8/11/2018
9.0
7.5
8 UHO
+ 65579
Robert
Antrim
11/7/1926 M
8/12/2018
9.0
9.7
8 MET
+ 86116
Kathy
Apley
8/24/1952 F
8/15/2018
6.0
4.4
8 AET
+ 96312
Richard
Arbuckle
12/3/2007 M
8/26/2018
6.0
9.7
8 UHO
+ 81447
Stephanie
Arbuckle
9/8/1941 F
8/2/2018
3.0
5.7
10 KAI
+ 91379
Jorge
Archibald
7/23/1979 M
8/25/2018
5.0
4.0
10 CIG
+ 54523
Maureen
Arcibald
4/11/1964 F
8/26/2018
8.0
8.6
8 CIG
+ 87592
John
Armstrong
8/27/1950 M
8/14/2018
3.0
4.4
10 CIG
8/23/2018
8/1/2018
8/2/2018
+ 38605
Eugene
Arney
11/22/1922 M
2.0
3.4
10 AET
+ 75355
Janice
Arth-Brown
10/25/1948 F
8.0
4.9
8 KAI
+ 13799
Manuel
Ashe
4/19/1959 M
9.0
7.5
8 ВСВ
+ 58731
Walter
Atkins
11/25/1935 M
8/15/2018
9.0
9.4
8 BCB
+ 54264
12/23/1953 F
8/11/2018
Atkins
RUnfiltered Search
Sue
4.0
4.0
10 CAR
Record: 14
41 of 1672
I *
JODDOO0000000000
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY