Microsoft Access: ????? ????? ?????? ??????? ?? ??????? ?????

?????? ????????? ?????? ?????????
???? ???????: 209141 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ????? ???????? ????? ????????? ??????? ??????? ????????.

????? ??? ??????? ??? ??? ????? ?????? Microsoft Access (.mdb ?.accdb).

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

??????

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

??????: ????? ?????? ?????? ??????? ????????? ?? ??? ??????? ?? ????? ??? Qrysmp00.exe. ????? ?? ????????? ??? ????? ?????? ??? ??? ????? ?????? ?????? ?????? ??????? ??????? ?? ????? ??????????????????:
207626 ACC2000: Access 2000 ????? ?? ??????????? ???????? ?? ???? ???????

??????? ????

???? ?????? ?????? ????? ??????? ?????? switch () ??? ?????? ????? ??? ??????? ??? ????? ?????? ????. ???????? ?? "????" "G-????" "P-Z?" ? "????".

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

  1. ???? ????? Microsoft Access ???? ????? ????? ???????? Northwind.mdb.
  2. ?? ?????? "????? ??????"? ???? ??? ?????????? ??? ?? ???? ??? ???? ?????? ??????? ????.
  3. ?? ???? ?????? ??????? ???? ? ???? ??? ??? ??????? ? ??? ?? ???? ??? ?????.
  4. ?? ???? ?????? " ????? ???? "? ??? ???? "???????" ????? "???????" ??? ???? ????????? ?????? ??????? ??? ????????????? ??????? ??? ??????? ????? ??? ?????.
  5. ?? ??????? ??? ? ???? ??? ?????????? ???? ?? ???????? ?? ??????.
  6. ?? ????? ????????? ? ???? ??? ??????? ????? ???? ???? ????? ?? ??????.
  7. ????? ???? ?????????? ??????? ????????? ???????:

    ??????: ?? ????? ??????? ??????? ??? ??????? ????? ???? ????? (_) ?? ????? ????? ???? ?????? ???. ????? ????? ???? ????? ?? ????? ????? ??? ????? ????? ??? ?????????.
       Field: Country
          Table: Customers
          Total: Group By
          Crosstab: Row Heading
       Field: Expr1: Switch([CompanyName] Like "[A-Fa-f]*", "A-F", _
                     [CompanyName] Like "[G-Og-o]*", "G-O", [CompanyName]_
                     Like "[P-Zp-z]*", "P-Z", True, "Other")
          Total: Group By
          Crosstab: Column Heading
       Field: OrderID
          Table: Orders
          Total: Count
          Crosstab: Value
    						
    ???????? ???? ?? ?? "???" ? "???" ?? ????? ?????? switch () ??? ??????? ???? ????? ??????. ???? "True" ?? ??????? ???? Else ? ??? ???????? ?? ????? ??? ?? ?????? ???????.
  8. ?? ?????? ?????????.

?????

????? ?? ????????? ??? ??????????? ????????? ???? ??? ??????? Microsoft Access ??? ??????? ? ???? ????? ????? ????? ?? ?????? ??????? ??????? ?? "????? Office" ?? ????? ???????? ??? ???? ??? ????? ???? ???????? ???? ?? ???????.

????? ?? ????????? ??? ????? ?????? ?? ???? Visual Basic? ???? ??? ??????? Microsoft Visual Basic ??? ??????? ? ???? ????? ?????? ?????? ?? "????? Office" ?? ????? ???????? ??? ???? ??? ????? ???? ???????.

???????

???? ???????: 209141 - ????? ??? ??????: 13/???? ??????/1435 - ??????: 1.0
????? ???
  • Microsoft Access 2000 Standard Edition
  • Microsoft Access 2002 Standard Edition
  • Microsoft Office Access 2003
  • Microsoft Office Access 2007
  • Microsoft Access 2010
????? ??????: 
kbnosurvey kbarchive kbhowto kbinfo kbmt KB209141 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????209141

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

 

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