.


:




:

































 

 

 

 





, 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. / /




:


: 2016-03-28; !; : 561 |


:

:

.
==> ...

981 - | 845 -


© 2015-2024 lektsii.org - -

: 0.06 .