, Access , , ,
. , , Access . :
1. ( , , Access ).
2. .
3. .
4. .
5. .
, QuantityInStock ( ) QuantityOnOrder ( ) , . , :
TotalValue: [UnitsInStock] + [UnitsOnOrder] * [Price]
, Access QuantityOnOrder Price QuantityInStock. :
TotalValue: ([UnitsInStock] + [UnitsOnOrder]) * [Price]
QuantitylnStock QuantityOnOrde , Price .
? , . <Shift>+<F2>. (Zoom), , , . , , , .
, , , .
, , . . , (, , ).
(&). , FullName (), FirstName LastName:
FullName: [FirstName] & [LastName]
, . ,
, , : BenJenks. : , . : FullName: [FirstName] & " " & [LastName]
|
|
: Ben Jenks. , (, Jenks, Ben) : FullName: [LastName] & ", " & [FirstName]
Access : , , , ( ). , , , Access , .
. , "The price is" , :
Price: "The price is: " & [Price]
, , , , , . . Access , .
, , . , , , . Access , , .
Access. :
■ ;
■ , ;
■ Visual Basic, Access, V.
, , , . , .
SQL (. . " SQL" 6), Access .
, . . , ( ).
Round (), . . Round (), , , 5%:
|
|
SalePrice: [Price] * 0.95
$43.97 41.7715, . Round (). , :
SalePrice: Round([Price] * 0.95, 2)
Round () . , ( Price * 0. 95), , (2). , , 41.77.
, Round (), . , ,
, Access . ?
, Access 21.985 21.98. , 5, , 21.99. . Access , .
5. 21.985 , 21.98 21.99, , . 5 . , , , , , .
5 , , .
21.985 21.98, 21.995 , 22. ( , , ), .
. : , . , Access Abs (), ( ). :
Speed: Abs ([DistanceTravelled] / [TimeTaken])
, Round ():
Speed: Round (Abs([DistanceTravelled] / [TimeTaken]), 2)
, Access . , , , . :
Speed: Abs(Round([DistanceTravelled] / [TimeTaken], 2))
, .
. . . , .
|
|
, Access . , , .
{ , , , ). , . (Expression Builder) , Web-pecypc www.techonthenet.com/access/functions.
Access , . :
1. .
2. , , (Build).
, , , .
, (. 7.3).
. 7.3. , , ( +, -, / *, - ), ,
3. .
, , , . (. 7.4) (. 7.5).
. . , (=), And, Or, Not Like, (. . " " 6), .
. 7.4. . , . , , . ,
. 7.5. . . ( , VBA.) . .
|
|
, . [Products]! [Price] [Price]. He Access .
4. .
Access .
, (, <number> <precision>), . .
. 7.6. Round () . , . , Access . , Access
Access , . , , , . , , , (Help). , , , . 7.6.
Format () , . , , , , .
, , :
SalePrice: [Price] * 0.95
Price , SalePrice ( ) ( , . .). 43.2 $43.20.
, Format () :
SalePrice: Format([Price] / 0.95, "Currency")
. , , Round ().
Format () , . . 7.2. .
7.2.
, | $1 433.20 | |
1433.20 | ||
1 433.20 | ||
(, 100, ). | 143320.00% | |
1.43+03 |
7.2 ()
/ | , 0, , 0. / / |