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
 
A split form is a new characteristic of Microsoft Office Access 2007 that allows obtaining two views of data simultaneously: a Form View and a Data sheet View.
 
The two views are connected to the same data source and are synchronous among them.
 
5) In order to create a split form, use the tool Split Form.
 
6) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form.
 
Illustration 5: Create a split form based on a query.
 
7) In the Create, in the group Forms, clicks in Split Form.
 
Illustration 6: Create a split form based on a query.  Click here to view larger image.
 
8) Access creates the form and shows it in the Presentation View. Inside this View, changes in form's design can be made while it shows data.
 
Create a form that shows several records
 
If it is desired to have a form that shows several registries instead a data sheet, you can use the tool Multiple Item's Forms.
 
Illustration 7: Multiple items forms.
 
9) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form.
 
10) In the Create, in the group Forms, clicks in Multiple Items.
 
Illustration 8: Multiple items forms.  Click here to view larger image.
 
Create a form with the wizard
 
In order to select with better criteria the fields that are going to appear in a form, you can use the Wizard for forms instead of the diverse tools of form creation previously mentioned.
 
11) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form.
 

 
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