ACC2002: ????? ????? ????? ?? ???????? ????? ??? ????????? ??? ????????? ????? ?? ???? ???? ?????

?????? ????????? ?????? ?????????
???? ???????: 295235 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

????? ??? ?????? ??? ????? ?????? Microsoft Access (.mdb) ????? Microsoft Access (.adp).

????? ???? | ?? ????

?? ??? ??????

???????

????? ??????? Microsoft Access ?????? ??? ????? ????? ??????? ??????? ??? ????? ???????? ?????????:
  • ????? ????????? ??????? ?????? ??????? ???? ????? ???? ORDER BY ?? ????? SQL ?????? ??.

    - ? -

  • ??????? ??????? ?????? ??????? ?? ????? ???? ?? ????.

?????

????? ????? ????? ????? ????????? ?? ??? ORDER BY ??? ?????. ????? ??? ????? ????????? ????? ???? ??? ?????. ????? ??? ????? ???? ?? ???? ?? ??? ?? ??????? ? ????? ????? ????? ?? ??? ????? ????? ?????????.

????

??????? ?????? ??? ??? ??????? ?????? ???? ????? ???????.

??????? ??????

??? ???? ????? SQL ?? ????????? ????????? ?? ????? ?????? Access Microsoft ??? ??????? ???? ?? ????? Microsoft Access ????? ???. ?????? ????? ???? ??????? ???????:
  1. ???? ????? ???????? ???? ????? ??? ????????? ?????????.
  2. ?? ???? ??????? ????????? ?? ????? ????? "?????".
  3. ?? ??????? ???? ???? ??? ??? SQL.
  4. ??? ????? SQL ?????? ???? ????? ???.
  5. ?? ??????? ????? ? ???? ??? ???.
  6. ?? ?????? ?????????. ?? ??? ???? ?????????.
  7. ??? ????? Microsoft Access ????? ???.
  8. ?? ?????? "????? ??????" ? ???? ??? ????????? ???????? ???? ?????? ?? ???? ????? ??????? ??? ????? ????? ??? ?? ??????.
  9. ?? ???? ?????? "????? ????" ? ???? ??? ?????.
  10. ??? ???? ??????? "??? ???????" ? ???? ??? SQL ??? ??? ???? "SQL" ?? ????? ?????? ?? ??????.
  11. ?? ???? "SQL" ? ??? ???? "SELECT FROM" ???? ????? ??? ??? ????.
  12. ?? ??????? ????? ? ???? ??? ???. ??? ???????? ?? ?????? ????????? ???? ?????? ?? ???? ???? SQL T ????????.
  13. ??? ????? ????? ?????? ??? ????? ??? ??? ????????? ?? ????? (. mdb) ?? ????? ?????? Access.
  14. ????? ?????????.
  15. ?????? ??? ????? ????? "?????".
  16. ?? ???? ??? ????? ??? ????? ????? ????? ???? ???? ???????? ?????? ?????.
  17. ??? ????? ?????????.
  18. ?? ?????? ????????? ????.

??????? ???????

??? ????? ??? ????? ???????? ????????? ??? ??? ??????? ?? ????? ????? "?????" ? ?? ?????? ????? ????? ?? ?? ??? ????? ????? ?? ??????? ????? ???.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????.

??????? ????

????? ????? ????? ?? ????

?????: ??? ???? ??????? ???????? ?? ??? ??????, ????? ????? ????? ????? ???????? Northwind.mdb. ?? ???? ?? ???? ???????? ?? ??? Northwind.mdb ?? ???? ??????? ??????? ??? ???? ?? ????? ????????.

  1. ???? ????? ????? ???????? Northwind.mdb.
  2. ????? ??????? ???? ?? ????? ????? "?????".
  3. ?? ???? ?????? "????? ????" ? ???? ??? ?????.
  4. ?? ??????? ???? ???? ??? ??? SQL.
  5. ???? ?? ???? ???? ?????? ?? ???? SQL:
       SELECT Employees.LastName, 
            Orders.OrderDate, 
            Orders.ShipCountry, 
            [Order Details Extended].ExtendedPrice, 
            Products.ProductName, 
            Categories.CategoryName
       FROM Employees  
         INNER JOIN (Categories 
            INNER JOIN ((Orders 
               INNER JOIN [Order Details Extended] 
         ON Orders.OrderID = [Order Details Extended].OrderID) 
            INNER JOIN Products 
              ON [Order Details Extended].ProductID = Products.ProductID) 
                ON Categories.CategoryID = Products.CategoryID) 
                  ON Employees.EmployeeID = Orders.EmployeeID;
    					
  6. ???? ????????? qryNested ?? ?? ?????? ????.
  7. ????? ??? ????? ????????.
  8. ??? ?????? ????? ????? ????? ???? ?? ????????? qryNested ?? ??? ????? ??? ?? ????? Microsoft Access ????.

???????

???? ???????: 295235 - ????? ??? ??????: 06/???? ??????/1435 - ??????: 3.0
????? ???
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbbug KB295235 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????295235

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com