, . . │ → → (, ). .
, . , .
(Subdatasheet Name). , . , , . (Auto), Access , , . 5.9.
(Subdatasheet Height). , . , . 0, , .
(Subdatasheet Expanded). , ( ), ( ).
, , . ? . , , , , Bobelle House O'Dolls 3408. Access , -, .
, Access , . (. . " , " 4), , . . ManufacturerlD Dolls, ID, Manufacturers. , . , , , . - .
|
|
, , . , . ( ), . , ( ).
Access . , , . ( , , , Access .) ,
, , Dolls Manufacturers ( . " " ), .
, , Dolls Manufacturers.
1. - .
Dolls.
2. , -, .
, , ManufacturerID.
3. " " ("I want the lookup column to look up the values in a table or query") .
.
4. - .
Manufacturers. , .
5. , , , (Selected Fields) (. 5.11). .
ID Manufacturer.
. 5.11. , ( ID) ( -). ID , Manufacturer , -
. , FirstName LastName FamilyRelatives ( ). , - . .
6. , (. 5.12), .
Manufacturer.
. 5.12. ,
7. (. 5.13). , (Hide key column (recommended)), . , , , , , . , .
|
|
8. .
, ( ManufacturerID).
, (Allow Multiple Values). , , . ( .) . " " .
. 5.13. , ( Manufacturer) ( ID)
9. (Finish).
Access . Access , . "" Manufacturers Dolls, (. . " " ).
Access , , . , . , ( . " " ). Dolls Manufacturers. . .
, Dolls , (.5.14).
.
, . ?
Access , . , Dolls, Access . , , , .
, , , , .
, Dolls Manufacturers. ( .) Manufacturers -. Dolls ManufacturerID. , .
, . Access , → → (m → Records → Refresh All). Dolls .
. 5.14. , Dolls ID ManufacturerlD, . ( , ). , ,
|
|
. " " " , "--" ( ), , . , .
"--" : "--" "--". .
"--"
"--" . .
Products () , , . - , (, , ProductsEngineering ( ). , . , . ( Access 255 .)
. 5.15. , ( ), Access , "--". 1 , . ID Products ID ProductsEngineering , ProductsEngineering Products
"--" , "--" (. 5.15).
, . ( ) .
, (. . " " 2) , (. . " " 4).
, .
"--"
"--" Access. (. . " " 3) (. 6), .
, . ,
|
|
(. . " " 18) , .
. , , , .
, (. . "" 2) . , . , (, . " " 18).
. , . , .
, .
"--"
"--" . , . ( ). ( ). , , .
-, -.
"--" , Access .
"--", ( , Microsoft SQL Server). , , .
, . . , . , .
, Authors , . 5.6.
5.6. Authors
ID | FirstName | LastName |
Alf | Abet | |
Cody | Pendant | |
DeLawn |
Books , . 5.7.
5.7. Books
ID | Title | Published |
Fun with Letters | January 1, 2007 | |
How to Save Money by Living with Your Parents | February 24, 2008 | |
Unleash Your Guilt | May 5, 2007 |
. 5.8 Authors_Books, .
5.8. Authors_Books
ID | AuthorlD | BookID |
AuthorsBooks , . , 10 (Alf Abet) 402 (Fun with Letters). , , Cody Pendant , (How to Save Money by Living with Your Parents).
, , Authors Books.
, "--", Access. , -, . Authors "--" Authors_Books, Authors . Books "--" Authors_Books, Books . , , (. 5.16).
|
|
. 5.16. "--" Authors Books "--", Authors_Books. , , , Authors_Books
, . "--", , (. . " " ) AuthorID BookID Authors_Books. Authors_Books , .
Access 2007 "--". (. 21) SharePoint Access 2007 .
, . "--". - . . AuthorID , (. 5.9).
5.9. Books, AuthorID,
ID | Title | Published | AuthorID |
Fun with Letters | January 1, 2006 | ||
How to Save Money by Living with Your Parents | February 24, 2005 | ||
Unleash Your Guilt | May 5, 2006 |
. , 403.
AuthorID, , . 5.10.
5.10. Books, AuthorlD,
ID | Title | Published | AuthorID |
How toSave Money by Living with Your Parents | February 24, 2005 | 11, 12 |
. Access , .
. (. . 5.14), . ,
, . , (, ManufacturerID) (Lookup). (Allow Multiple Values) .
, .
. 5.17 .
. 5.17. , . , . , -
, accdb (. " , . Access , " . " " 1). mdb (, Access 2003 ) .
SQL Server ( 20), SQL Server . , (, ) - SQL Server, .
Share-Point Server ( 21).
.
"--"
: ?
. , . , . , Students_Classes , . Students_Classes , EnrollmentDate ( ), n-firmationLetterSentDate ( ) Prerequi-sitesChecked ( ).
, . Authors_Books, , , . Books. Authors_Books , . ( Authors_Books, .) Books Authors , , .
, Access . , . , , , Books, Authors_Books. , . , IV.