Affiliates

Amazon.com


Popular Microsoft Access Books

Building Microsoft Access Applications
Building Microsoft Access Applications
Author: John L. Viescas 

Access 2003 All-in-One Desk Reference for Dummies
Access 2003 All-in-One Desk Reference for Dummies
Author: Alan Simpson 

Access 2003 for Dummies
Access 2003 for Dummies
Author: John Kaufeld 

Office 2007 All-in-One Desk Reference For Dummies
Office 2007 All-in-One Desk Reference For Dummies
Author: Peter Weverka 

Microsoft Office Access 2003 Step by Step
Microsoft Office Access 2003 Step by Step
Author: Online Training Solutions Inc. 

Access 2007 Bible
Access 2007 Bible
Author: Michael R. Groh 

Microsoft Office Access
Microsoft Office Access
Author: Steve Lambert 

Beginning Access 2003 VBA
Beginning Access 2003 VBA
Author: Denise M. Gosnell 

Microsoft Office Access 2003
Microsoft Office Access 2003
Author: Gary B. Shelly, Thomas J. Cashman.... 

Popular MS Access Related Websites

Microsoft Corporation 













Microsoft Access 2007 Tutorials for beginners    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Access tutorials for beginners, covering the following categories - Databases, Customization, Table, Forms, Queries, Reports, etc.,

  Microsoft Access Tips and Tricks for beginners
Programming with Access 2007  
 
Written by Ravi Prakash  
Friday, 22 June 2007
Category MS Access 2007 - Macros.  
 
General Information
 
 
Macros
Create a form that shows several records
Create a report with the wizard
Create a report from blank template
Set up report properties
Close a database
 
 
Macros in Access can be considered like a simplified programming language that can be used to increase the functionality of the data base. For example, it can enclose a macro to a command button in a form, so the macro is executed when clicking in the button. The macros contain actions that make tasks, like opening a report, executing a query or to close the data base. Almost all the operations of data bases that normally are made manually can automate by means of macros, thus saving time. 
 
Modules, like macros, are objects that serve to increase the functionality of the data base. Whereas the macros in Access are created selecting actions of a list, the modules are written in the Visual BASIC programming language for Applications (VBA), a version of the language of macros of Visual Microsoft BASIC who is used to program applications based on Microsoft Windows and who is included in several programs of Microsoft. A module is a collection of declarations, instructions and procedures that are stored jointly like a unit. There are two kinds of modules: standard modules and class modules. The class modules are joined to forms or reports, and normally they contain specific procedures of the form or the report to which they are enclosed. The standard modules contain general procedures that are not associated to any other object. 
 
Macros
 
1) In the Create tab, in the group Other, click in Macro command, then Macro menu item.
 
Illustration 1: Select the Macro command.  Click here to view larger image.
 
2) The Macro definition panel will appears.
 
Illustration 2: You will configure the macro in this panel.  Click here to view larger image.
 
3) Select the OpenForm action.
 
4) Configure the OpenForm arguments.
 
Illustration 3: You will configure the macro in this panel.  Click here to view larger image.
 
5) A condition specifies certain criteria that must be met before an action will be performed. You can use any expression to evaluate to true or false or Yes or No the expression and execute or not some commands based in these results.
 
Illustration 4: Configure all action Arguments.  Click here to view larger image.
 

 
Advertisement



Advertisement



Copyright MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster