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
Forms {Tutorial for beginners}  
 
Written by Ravi Prakash  
Friday, 29 June 2007
Category MS Access 2007 - Forms.  
 
General Information
 
 
Create a form
Create a form that shows several records
Create a form with the wizard
Create a form from blank template
 
 
A form is a database object that can be used to write, to modify or to show the data of a table or queries. The forms can be used to control the access to the data, as what fields or rows of data are going to be showed. 
 
Consider the forms like windows by which the users see and reach the data bases. An effective form accelerates the database's uses, since the users do not have to look for what they need. 
 
Create a form
 
You can use the tool Form to create a form with a single click. When you uses this tool, all the fields of the underlying data source are placed in the form. You can begin to use the new form immediately, or, can modify it in the View Presentation or Design to fit it with your needs. 
 
1) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form.
 
Illustration 1: Select the Files tables.
 
2) In the create tab, in the group Forms, clicks in Form.
 
Illustration 2: Select the Form command.
 
3) Access creates the form and shows it in the Presentation View. Inside this view, changes of form's design can be made while it shows data.
 
Illustration 3: Form in presentation view.  Click here to view larger image.
 
4) If Access finds a single table that has a relation to one or several tables or queries, will add a data sheet to the form based on the table or consults related.
 
Illustration 4: Form based on a table with related tables.  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