Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Organizing screen space with tabs

From: Access 2010: Forms and Reports in Depth

Video: Organizing screen space with tabs

A Tab control can be used to add extra space to your form or group similar or related objects together. A Tab control is a great way to organize your form, but it's not going to work very well on a printed report, since you'll only be able to see the first tab when it's printed and clicking on paper really doesn't work that well. Let's go ahead and open up our Controls form by right-clicking on it and selecting Design view. The Tab control is this button right here. We'll click on it once and we'll drag out a tab. I'm going to go ahead and draw a box that fills up most of the bottom of my form. Access adds in two tabs here. If I wanted to add additional tabs, I can right-click and say Insert Page; if I wanted to delete a tab, I can right- click and say Delete Page; and if I want to rearrange the tabs, I'd right-click and say Page Order.

Organizing screen space with tabs

A Tab control can be used to add extra space to your form or group similar or related objects together. A Tab control is a great way to organize your form, but it's not going to work very well on a printed report, since you'll only be able to see the first tab when it's printed and clicking on paper really doesn't work that well. Let's go ahead and open up our Controls form by right-clicking on it and selecting Design view. The Tab control is this button right here. We'll click on it once and we'll drag out a tab. I'm going to go ahead and draw a box that fills up most of the bottom of my form. Access adds in two tabs here. If I wanted to add additional tabs, I can right-click and say Insert Page; if I wanted to delete a tab, I can right- click and say Delete Page; and if I want to rearrange the tabs, I'd right-click and say Page Order.

Access will bring up a Page Order dialog box, in which case I can move up or down the tabs however I see fit, okay. So what can we do with a tab? Well tab essentially doubles or triples or quadruples the screen real estate we have on each form. For instance, if I click on Page4, it highlights the content area of that tab. Anything that I put in here won't appear when I click on Page5. We can have discrete and individual content for every tab. I'll click on the Page4 tab, and I'll go ahead and just add a label in here. I'll select the Label control from the toolbox and I'll move down into the tab.

Once I get over the tab area it turns black. This is Access's way of telling me that the next thing I'm about to do is going to go inside of this tab, not inside of the form. I'll click to add a label, and I'll just say, "This is page 4." Let's go ahead and click on the other tab. This time I'll just draw a line inside of it. I'll click on the Line control and I'll drag out a line. Okay, let's go ahead and take a look at this in Form view. I'll click on the Form View button here, and now I can see the tabs. I can switch back and forth between the first tab here and the second tab here, and I can see they've got different content in each one. Okay, let's go back into Design view. Now we can change the titles of these tabs. Page4 and Page5 really is not going to help me very much, so I'll click on the first one here, and in the Property Sheet, I'm going to change the caption for the tab.

The caption for this one is just going to be Text. Let's go ahead and change the caption for second one. This one I'm going to call Line. Now you can put any kind of content that you want inside of here. Later on we're going to take a look at subforms. You can put an entire form inside of this tab. You can put all kinds of content: buttons, selectors, hyperlinks, text boxes, and charts. Anything that you can put on your form you can put inside of a tab. Now there is another control in Access 2010 called the Navigation control. This is similar to a tab, but it only works with the forms inside of it. Let me take a look at one of these. I am going to go ahead and select these tabs and delete them.

We'll use the Navigation control here, the one with the pink bar at the top. I'll click and I'll drag out a Navigation control. Now the interface is a little bit unusual with the Navigation control. When I first put it in, it's selected, but nothing is showing up here in the Property Sheet. I'll click on the Add New here, I'll double-click on it, and I will change its name. For instance, I'll say Employee Directory and press Enter. When I press Enter, Access adds a little tab right here and moves over to the next one. I can add a second tab by double- clicking here and adding another name. I'm just going to call this Orders by Product and press Enter.

Now I have the opportunity to add a third tab and so on. Once I go back to the first one that I created, the Property Sheet is live now. I can go ahead and change what's connected to it. So for instance I can go to the Data tab. In the Navigation Target Name it automatic shows as Employee Directory because that's what I named the tab. If I wanted to change that, I can use this dropdown menu and choose different forms that are already present in my database here. The Orders by Product tab, again, it automatically selected it, because I changed the name to that up here in the tab. But you can make the name whatever you'd like and then change the target here to whatever form you want.

So let's take a look at this form in Form view. We'll click on the Form view button, and I can scroll down to see my employees directory. You change this tab here and look at the Orders by Product one. Now the Navigation controls, they're little bit hard to deal with. I honestly think the regular Tab control works much better than the Navigation tab control for this sort of object. The reason being is that the regular Tab control, you can put a form in it using a subform, like we'll see later on. So there is nothing really special about the Navigation control in these tabs. One other thing about the Navigation control: if you go to the Create tab or the Ribbon, under the Form section here, you get this whole navigation group.

If I click on here, you can see a whole bunch of different forms that are preset up with the Navigation control and the tabs in different arrangements. For instance, I can select Vertical Tabs Left and that will create a new blank form, ready for me to type in the values that I want in here. So for instance, I can do the same thing. I can double-click on the tab on the left and type in Employee Directory and press Enter. Then I can add the second tab here, and this time I'll type Product Selection and press Enter again. Now if I view this form in Form view, you can see how the tabs are working a little bit better. Employee here, Product there.

All it's doing is pulling in the content from these other forms and placing it inside of this navigation form. So that's a couple of ways that you can add tabs to add dimension and organization to your forms when screen space is at a premium. Later on when we take a look at subforms, we'll see how we can make a regular Tab object function almost exactly like this navigation form, and we'll have more control over it with that method.

Show transcript

This video is part of

Image for Access 2010: Forms and Reports in Depth
Access 2010: Forms and Reports in Depth

38 video lessons · 14629 viewers

Adam Wilbert
Author

 
Expand all | Collapse all
  1. 1m 27s
    1. Welcome
      1m 2s
    2. Using the exercise files
      25s
  2. 15m 53s
    1. Introducing forms
      2m 41s
    2. Designing for the end user
      45s
    3. Exploring the database
      1m 49s
    4. Creating a form with the Form Wizard
      6m 43s
    5. Refining the form in Layout view
      3m 55s
  3. 24m 33s
    1. Organizing the form elements
      7m 14s
    2. Formatting
      4m 48s
    3. Modifying the form through its properties
      6m 56s
    4. Adding a header and some polish
      5m 35s
  4. 1h 2m
    1. Introducing form controls
      3m 48s
    2. Using lines and rectangles
      2m 48s
    3. Organizing screen space with tabs
      4m 47s
    4. Adding buttons
      5m 3s
    5. Linking to external content
      4m 15s
    6. Entering and selecting data
      5m 8s
    7. Controlling input with option groups
      6m 0s
    8. Attaching documents
      6m 49s
    9. Attaching images
      5m 8s
    10. Understanding the subform control
      4m 13s
    11. Adding charts
      7m 9s
    12. Linking controls
      7m 41s
  5. 21m 42s
    1. Creating the main menu
      8m 49s
    2. Adding a splash screen with startup options
      5m 35s
    3. Creating a customer form
      7m 18s
  6. 45m 20s
    1. Grouping and sorting data
      4m 36s
    2. Understanding report structure
      6m 12s
    3. Building reports from wizards
      5m 0s
    4. Building reports from queries
      6m 34s
    5. Formatting conditionally
      6m 59s
    6. Calculating fields
      4m 35s
    7. Adding the finishing touches
      4m 49s
    8. Populating pre-printed documents
      6m 35s
  7. 15m 8s
    1. Printing reports
      3m 6s
    2. Tweaking the design
      7m 10s
    3. Automating the workflow with macros
      4m 52s
  8. 58s
    1. Next steps
      58s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now "Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Access 2010: Forms and Reports in Depth.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.