Google
microsoftaccess doCommand - Google Search
http://www.google.com/search?esrch=Axs&q=microsoftaccess+doCommand&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
microsoft access doCommand - Google Search
http://www.google.com/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&esrch=Axs&q=microsoft+access+doCommand&btnG=Search
********************
MS ACCESS
********************
Database Objects:
Tables
Queries
Forms
Reports
Data Access Pages
Show or Open a Database Object:
ShowOpen a macro
ShowOpen a table
ShowOpen a form or subform
ShowOpen a report or subreport
ShowOpen a query (select or crosstab) that shows records
ShowOpen a data access (web)page
ShowOpen a macro
ShowOpen a module
Query type Description
---------- -----------
Select query Retrieves data from one or more tables and displays the recordset in a datasheet.
This is the most common type of query.
Parameter query Prompts the user to enter values that define the query, such as a specified region
for sales results, or a specified price range for houses.
Cross-tab query Arranges a recordset to make it more easily visible, using both row headings and column headings.
Action query Creates a new table or changes an existing table.
SQL query An advanced query that is created by using an SQL statement.
Viewing Dependency Information (& Name AutoCorrect)
http://office.microsoft.com/en-us/access/CH010127191033.aspx
About Object Dependencies
http://office.microsoft.com/en-us/access/CH010127191033.aspx
Form Types
Switchboards
Messages
Subforms
Create a form:
Form Wizard - click Forms under Objects in the Database window, and then click New on the Database toolbar.
In the New Form dialog box, you would click Form Wizard to select this method.
AutoForm - click Forms under Objects in the Database window, and then click New on the Database toolbar.
In the New Form dialog box, you would click one of the AutoForm options to select it.
Design view - click Forms under Objects in the Database window, and then click New on the Database toolbar.
In the New Form dialog box, you would click Design View to select this method.
Forms I: Create a form to enter and view your data
http://office.microsoft.com/training/Training.aspx?AssetID=RP010175441033&CTT=6&Origin=RC010162551033
Forms II: Use Access subforms
http://office.microsoft.com/training/Training.aspx?AssetID=RP101178861033&CTT=6&Origin=RC101178791033
Work with a database you didn't create
-Find out how your database is structured
-First things first - back up your data
-Talk to people who designed and used the database - questions:
-Who used the database, both for data entry and for generating queries and reports?
-How is the data organized, and why is it organized that way?
-What did you use the data for, and did you use reports, queries, or labels?
-What measures did you use to validate and help protect the data?
-Who was the database administrator?
-What are the various sources for the data - was all the data entered, or did you import some of it from other sources?
-What problems have you encountered, and how have you dealt with them?
-***Examine the switchboard and its links***
-The switchboard often has links to commonly performed tasks.
-Find out what your database contains
-You can view many objects in the Database window. You can switch
to the Database window by pressing F11 or by clicking the link
for your database on the Window menu. Then browse the objects by
clicking the types of objects in the left part of the window.
-To show hidden objects, on the Tools menu, click Options, and
then click the View tab. Under Show, select the Hidden objects
check box.
-You can also see a quick overview of the objects in your database
by clicking the Database Properties command on the File menu, and
then clicking the Contents tab.
-Table Structure (Relationships) ERD
-To open the Relationships window, press F11 to switch to the
Database window, and then click the Relationships button Button
image on the Database toolbar.
- 1->1 one to one
- 1->~ one to many
- ~->~ many to many
-View object dependencies
-Working with object dependencies
-The following are required for the Object Dependencies task pane to
work correctly:
- Tracking name AutoCorrect info must be enabled to view
dependency information, but Perform name AutoCorrect does not need
to be enabled.
- You must also close all the objects before viewing their
dependencies.
-Setting Track name AutoCorrect information
1. On the Tools menu, click Options, and then click the General tab.
2. Select the Track name AutoCorrect info check box.
-Note If the Object Dependencies task pane still does not appear,
close and then reopen the object whose dependencies you want to view.
-Note The task pane doesn't show macros and modules. If you'd
like to learn more about automating your database by using macros
and modules, please visit the Office Developer Center
http://msdn.microsoft.com/en-us/office/default.aspx .
Access 2003 Online Info
15 Access 2003 items:
http://office.microsoft.com/en-us/access/HA011189511033.aspx
Interactive Access 2003 to Access 2007 command reference guide - Access - Microsoft Office Online
http://office.microsoft.com/en-us/access/HA102388991033.aspx