????? ????? ????? ????????? ?? Microsoft Access

?????? ????????? ?????? ?????????
???? ???????: 304356 - ??? ???????? ???? ????? ????? ??? ???????.
???????: ????? ????? ????? ???????? ??? ????? ??????? ???????? ??????.

??? ????? ??? ?????? ??? ??? ????? ?????? Microsoft Access (.accdb ? mdb.).?????? ??? ????? Microsoft Access 2000 ?? ??? ???????? ????304357.
?????? ??? ????? Microsoft Access 97 ?? ??? ???????? ????304451.
????? ???? | ?? ????

??????

???? ??? ?????? ????? ????? ????? ????????? ?? Microsoft Access. ???? ??? ????????? ????? ??? ??? ???? ?? ?????? ????? ???:
  • ????? ??? ??????.
  • ????? ????????? ?????? ??????.
  • ?? ?????? ??? ?????? ?????.
  • ????? ???????? ????????? ?????? ??????????.

??????? ????

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

???? ???? ????? ?????????? ?? ????? ????? "?????" ??? ???????? ???? ????? ?????? ?? ????? ????? ?? ???? ????? ?????????? ??? ?? ???? ??????????????? ????????. ?? ??? ????????? ?? Access? ????? ??? ???? ??????? ?????????? "????? ????? ?????". ???? "????? ?????????"? left-click ?? ????? ????? ?? ???? ????? ?????????.


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

?? ??? ??????????? ??? ??????
??? ??????????
???????? ??????????????? ?????? ??????? ??? ???????? ??????? ?? ?????? "????? ??????" ????? ??? ???? ???? ?? ??????? ????.
????? ????? ??????????????? ???????????? ????? ??????????????? ????? ????? ??? ??? ???????.
????? ???? ??????????? ???????OutputAllFields??????? ?????? ???? ?????? ?? ???? ???????? ??????? ????????? ??? ????? ?????? ??????? ?? ???????. ???? ????? ??? ??????? ????? ???? ???? ???? ?????? ??? ?????? ??? ????? ???????????? ?? ???? ????? ????????? ??? ??? ?? ?????????.
????? ??????????? ???????????? ??????????? ?????? ??? ???? ?? ??????? ?? ???? ????? ?? ??????? ???? ??? ????????? ???? ??????. ??? ???? ??????? ?? ????? ??? ????? ????? 10 ?????? ?? 25 ??????? ??????? ?? ???? ????? ?? ???.
??? ?????????? ?????????? _ ?????????? ????? ???? ??? ??????? ???? ????? ??? ?????? ????? ?? ?????? ???????? ?? ????? ????? "???? ????????". ??? ???? ??????? ??? ???? ????? ????????? ???? ?? ??? ????? ??? ?? ???? ?????? ????? ?? ???? ?????? ????? ???? ???? ??? ?????? ?? ???????.
????? ?????????? ???????????? _ ???????????? ?????? ?? ??? ??? ?????? ??????? ??????? ??? ???????? ??? ???? ?????? ?? ???? ???????? ???????? ?? ???? ??? ?????? ???????? ?? ????????? ????.
?? ?????? ????????????? ????????????? _ ???????????? ?? ???? ?????? ?????????? ?? ?????? ??? ???? ?????? ?????? ???????? ????????. ???? ?? ??? ???? ??????? ?? ?????? ????? ?????? ????? ???? ?? ??????? ??????? ???? ?? ???? ??? ???????. ??? ???? ??????? ???????? ?? ???? ???? ??? ??????? ??? ???????????? ????? ???? ??????????? ?? ??? ???????/???????. ?? ???? ????? ???????????? _ ?????????????? ?????? ?????? ??????? ????? ????? ??????? ?????? ?????? ????? ??? ????.
????? ?????? ???????????SourceDatabase???? ??????? ????? ???????? ???????? ?????? ??????? ?? ??????????? ???????? ?????? ???.
????? ????? ???????????SourceConnectStr???? ??????? ??? ??????? ???????? ?????? ????? ?????? ??????.
????? ???????????? ???????RecordLocksproperty to determine how records are locked and what happens when two users try to edit the same record at the same time.
Recordset TypeYou can use theRecordsetTypeproperty to specify what kind of recordset is available.
ODBC TimeoutYou can use theODBCTimeoutproperty to specify the number of seconds Microsoft Access waits before a time-out error occurs when a query is run on an Open Database Connectivity (ODBC) database. By setting this property to zero (0), no time-out will occur.
FilterYou can use theFilterproperty to specify a subset of records to be displayed when a filter is applied to a form, report, query, or table.
????? ???You can use theOrderByproperty to specify how you want to sort records in a form, query, report, or table.
Max RecordsSpecifies the maximum number of records that will be returned by an ODBC database to an Microsoft Access database (.mdb).
OrientationYou can use theOrientationproperty to specify or determine the view orientation.
Subdatasheet NameYou can use theSubdatasheetNameproperty to specify or determine the table or query that is bound to the subdatasheet.
Link Child FieldsYou can use theLinkChildFields?LinkMasterFieldsproperties together to specify how Microsoft Access links records in a form or report to records in a subform, subreport, or embedded object, such as a chart. If these properties are set, Microsoft Access automatically updates the related record in the subform when you change to a new record in a main form.
Link Master FieldsYou can use theLinkChildFields?LinkMasterFieldsproperties together to specify how Microsoft Access links records in a form or report to records in a subform, subreport, or embedded object, such as a chart. If these properties are set, Microsoft Access automatically updates the related record in the subform when you change to a new record in a main form.
Subdatasheet HeightYou can use theSubdatasheetHeightproperty to specify or determine the display height of a subdatasheet when expanded.
Subdatasheet ExpandedYou can use theSubdatasheetExpandedproperty to specify or determine the saved state of all subdatasheets within a table or query.

Field List Properties

To view the field list properties, in Design view of any query, right-click in any cell in the query design grid, and then click?????on the shortcut menu.

?? ??? ??????????? ??? ??????
Property Name???
AliasYou can use theAliasproperty to specify a custom name for a source table or query when you use the same table or query more than once in the same query.
SourceYou can use theSourceproperty to specify the source connection string and source database for a query's source table or query.


??????The following two properties are not available in Access 2000:
  • Default
  • View Orientation
??????The following two new properties were added in Access 2007 for queries:
  • Filter On Load
  • Order By On Load
For additional information about lookup field properties, click the article number below to view the article in the Microsoft Knowledge Base:
304462ACC2002: How to Add Lookup Fields in a Microsoft Access Table

?????

For more information about modifying query properties, clickMicrosoft Access Help???Helpmenu, typechange query propertiesin the Office Assistant or the Answer Wizard, and then clickSearchto view the topics returned.

You can also view this information on the World Wide Web at the following Microsoft Web site:For additional information about creating select queries, click the article number below to view the article in the Microsoft Knowledge Base:
304325ACC2002: How to Create a Select Query in Microsoft Access
????? ?? ????????? ??? ????? ????????? ????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
304352ACC2002: ????? ????? ??????? ????? ?? Microsoft Access
????? ?? ????????? ??? ????? ??????????? ????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
304349ACC2002: ????? ????? ??????? ????? ?? Microsoft Access
????? ?? ????????? ??? ????? ??????? ????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
304354ACC2002: ????? ????? ??????? ????? ??? ??????? ?????
????? ???? ??? ??????????? ????? ???????? ??????? ?? ??? ???????? ?? ??? ???? QrySmp00.exe ?? ??????? ???????:
207626???? 2000 ????? ????????? ???????? ?? ???? ???????

???????

???? ???????: 304356 - ????? ??? ??????: 25/?? ??????/1431 - ??????: 1.0
????? ???
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbquery kbhowto kbmt KB304356 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????304356

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

 

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