Microsoft Access
  Home arrow Microsoft Access arrow Page 3 - Getting to Know Microsoft Access, Part 7: ...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Mobile Linux 
App Generation ROI 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MICROSOFT ACCESS

Getting to Know Microsoft Access, Part 7: Forms
By: Sage Adams
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 20
    2005-01-19

    Table of Contents:
  • Getting to Know Microsoft Access, Part 7: Forms
  • Creating Your First Form
  • The Form Wizard
  • Customizing Your Form

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Getting to Know Microsoft Access, Part 7: Forms - The Form Wizard


    (Page 3 of 4 )

    The form wizard is probably the easiest way to create a form. Double-click the "Create form by using wizard" option in the database window with the forms objects visible to use the wizard. Choose your record source(s) and field(s). Choose how you want to view your data, select a layout and style for your form, and finally give your form a name.

    Instead of doing what you just did you could click the "New" button with the forms objects open in the database window to get the options I discussed previously, including the various AutoForm options. The AutoForm options include: Columnar, Tabular, Datasheet, PivotTable, and PivotChart styles. The Columnar style organizes the fields in columns while the tabular style puts the data for the records on a line across the form.

    The Datasheet style is similar to the Datasheet view for tables and is generally used for subforms. Subforms show data from records with related data to the current record. The PivotTable style analyzes and summarizes your data, while the PivotChart style shows this analysis and summary graphically.

    Once you’ve created your form you can modify the form’s design by adding headers and footers, resizing the form or window, adding special controls, moving or reformatting the controls, changing label text, adding lines, or changing the order of the cursor through the controls when the TAB button is used. These possibilities are available to you both from the form toolbar and through the form properties worksheet.

    More Microsoft Access Articles
    More By Sage Adams


     

    MICROSOFT ACCESS ARTICLES

    - Linking SQL Express 2005 Tables to MS Access...
    - Working with Access Projects in Access 2007
    - Exploring Access 2007
    - Working with Stored Procedures in an MS Acce...
    - Creating and Using Action Queries
    - Creating Data Access Pages with Charts using...
    - Advanced Ideas using VBA
    - VBA Details
    - Updating Records in MS Access
    - Using ADO`s Record Object with URLs
    - Exporting XML from MS Access 2003
    - Importing XML into MS Access 2003
    - On Using Pass-through Queries in MS Access
    - Distributed Queries in MS Access
    - Configuring a Linked Microsoft Access Server...





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
    Stay green...Green IT