Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Forms

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Forms

Resolved · Low Priority · Version 2007

Reply Tue 24 Mar 2009, 17:19Delegate Lauren said...

Lauren has attended:
Access Introduction course
Access Intermediate course

Forms

How do I make or change tabs in the form view?

For upcoming training course dates see: Pricing & availability

Reply Mon 30 Mar 2009, 12:36Trainer Carlos said...

RE: Forms

Hi Lauren

Tab forms are usually used to display data from two or more tables on a form.

If you need to create tabs on an Access form you do the following:

1. In the form design view select Design under Form Design Tools .

2. In the Controls section select the Tab Control

3. With the mouse draw the area to be covered by the Tab. The Tab object appears on the screen with 2 page tabs

4. Use the Property window to rename the Tabs

5. Click the Add Existing Fields button in the Design ribbon.

6. Select the fields from the relervant table and drag them to the relevant tab page

The form will now allow the user to enter/view data in two or more tables.

Hope this helps

Carlos

Access articles

· Be Top Of The Form With Access 2007
· User-Level Security In Access
· What Is The Database Documenter And How Is It Used?
· Share And Share Alike With Microsoft Access 2010
· How To Create Calculated Fields In Access 2010 Tables

Please browse our web site to find out more about
advanced micorosoft access training and other Microsoft training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips