Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

previousPrevious article   Next articlenext back to categoryAccess articles

article Different Ways To Use Forms In Access 2007

Ever wondered if you're using Access database Forms in the most effective ways? You may have created Forms in Access based on tables, so you can easily view, add or edit data in your tables. You may have also built different types of forms using the Create tab in Access 2007 - the options cover regular forms, split forms and forms showing multiple items, and these are described in detail in other articles. This article looks other more unusual ways you can use forms.

We'll first look at forms used to navigation between other forms, open tables, run queries and so on. Then we'll look at forms used as containers for one or more tables, then lastly we'll look at forms used to view attachments such as images.

Firstly, forms can be used for navigation between forms, tables, reports and queries within your database. To do this you first create a blank form, give it a name such as Home, and then in design view, add one or more command buttons to this form from the Controls group in the Design tab. Once a command button is added a wizard helps you choose which item you want the button to open when clicked. You can use buttons in this way to open other forms, reports and tables, and run queries or macros. On the other forms you can also add one or more command buttons to allow you to return to your Home form or navigate elsewhere, so you can build a complete navigation system around your Home form.

Secondly you can use a form to show more than one table or table view - the Split Form type in Access 2007 is an example of this. If you create a split form based on a specific table you'll see an upper part showing a regular columnar form showing one record per screen and in the lower part you see a table like layout showing all the records in that table. The split form is really showing two views of the same table.

You may wonder - what's the point of showing a table in a form? Well if you add a table to a form in design view and set the view to be datasheet view, the table looks exactly the same as it normally does, but the advantage is that you can then add command buttons above or below the table, so you can click a button to navigate elsewhere directly from the form - you can't do this from a table. This way you can open and close forms, tables and reports using command buttons. This makes it very easy for a user to move between different parts of a database without going anywhere near the database design areas.

By the way, users of Access 2003 can create a form navigation system called a Switchboard. Access sets this up for you through a wizard and all you do is define the various switchboard forms you need, which buttons you want on each, and which items you want the buttons to open. Access then builds the switchboard for you complete with main Switchboard form and subforms, all with command buttons. Access 2007 has done away with this feature, instead letting users define categories and groups in the new navigation pane which you see when a database opens - this lets users do much the same as the switchboard, but with greater flexibility.

You can also create an Access form to show more than one table - but this does depend on the size of each table. To do this, first building a form based on a particular table, and ensure the view is set (in design view) to datasheet view. This way the form will display the normal table view. Once this is done you may need to resize your form and/or resize or move the existing form fields to create some empty space on the form. Then in the Design tab, ensure the "Use Control Wizards" option in turned on - this should be showing in orange.

To add a second form, look in the Design tab and click once on the subform/subreport button, then draw a rectangle in an empty part of your form where you want the other form to go. The Subform wizard will run and lets you choose which table to base your second form on. When the wizard asks which fields are common, choose "none" - that way the whole second table will show in the form, and ensure the second table is also showing in datasheet view. Save the form and return to form view, and you'll now see your two tables. And because both tables are showing on the one form, data can be entered or edited in both tables at the same time from the single form.

The third use of forms we'll look at is using a form as a viewer, often to display attachments stored in tables. You can add different kinds of attachments to an Access 2007 table, such as pictures, Word files and Excel files using the new attachment data type. In Access 2003 the data type for a picture is OLE. However when the table is opened you only see the attachment paperclip symbol rather than the actual item.

If you now build a form based on the table you'll actually see the image - you can change the attachment displayed size in the form design view to suit. If you've attached a Word or Excel file you see a symbol which you can double click on the open the actual file, provided Word or Excel is installed on your computer of course.

These are just some examples of using Access database forms in different ways. To really get to grips with Access forms and many other Access features, consider attending one of the many excellent training courses available, and really start to use Access in very effective ways.

Author is a freelance copywriter. For more information on access training london, please visit http://www.microsofttraining.net


Original article appears here:
http://www.microsofttraining.net/article-831-different-ways-use-forms-in-access-2007.html


Back to article list

Distribution notes

PUBLICATION GUIDELINES

  • You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
  • Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
  • Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
  • If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
  • Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
  • If you do not agree to these terms, please do not use this article.


Microsoft Office courses London
Course rating:
4.7 stars - based on 829 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom