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

Using the Navigation pane

From: Access 2013 Essential Training

Video: Using the Navigation pane

The Navigation panel on the left-side of your screen here is the Table of Contents for your database. It displays all the objects, the Tables, Queries, Forms, Reports & Macros that make up this database. It also allows you to filter and search through those objects to get to the ones you are looking for quickly. Right now the Navigation pane is in its default configuration. It says All Access Objects across the top. And I'm going to actually open this up a little by clicking and dragging open to make it little wider. Below, we have a search box, so we can type in to filter the list of objects.

Using the Navigation pane

The Navigation panel on the left-side of your screen here is the Table of Contents for your database. It displays all the objects, the Tables, Queries, Forms, Reports & Macros that make up this database. It also allows you to filter and search through those objects to get to the ones you are looking for quickly. Right now the Navigation pane is in its default configuration. It says All Access Objects across the top. And I'm going to actually open this up a little by clicking and dragging open to make it little wider. Below, we have a search box, so we can type in to filter the list of objects.

I'm going to click here and type phone to see all of the objects that have the word phone in their name. When you want to clear the search, click on this filter icon to the right and that will clear the search string and return you to viewing all objects. Below each of the objects are listed under a collapsible type header. Click on the up arrows to the right to collapse the group. I can collapse of Tables here, then Queries, Forms and Reports. If I want to work with my Query objects I can simply open it again, use the one I want and then close it when I'm done.

I'm going to go head and expand all these again. At the top of the Navigation pane there is a dropdown menu that allows us to change the configuration of the pane, here. This menu is separated into two different groups. The top one says Navigate To Category, and I personally think this should just simply read grouping, because that's exactly what it does. We can choose an option in the top half to change the way the objects are grouped together. Right now they're grouped by Object Type, but I can group them by Custom group, by Tables and Related groups, based off of the Date they are Created or the Date they were last Modified.

The bottom half of the menu says Filter By Group, here we can choose to display only a single object type. I'll click Tables to filter my navigation pane to show just the tables in my database. You'll notice that the top now reads Tables, instead of All Access Objects. I'll change it back in the dropdown, down here to All Access Objects, to view everything again. There is also a right-click menu at the top of the Navigation pane with some more options. I'll go up here and right-click, you'll see we have the same categories and sorting options, we can also sort Ascending or Descending alphabetically.

We also have a View By option where I can choose how I want to view my objects. Right now they are in List view which is a small icon in the text. I can change it to Details to view a larger icon and some additional information about each object. I'm going to go back up and right-click, go to View By, and change it back to List. If you want even more options, you can go in the Navigation options button here. This will give us a really detailed look at what options are available for organizing our Objects menu, go ahead and say OK, and finally in that same menu, go back up and right-click, we get turn on and off our search bar.

So if you don't use it, you can turn it off here. If you want to get the Navigation pane out of your way, you can use this Shutter Bar button here to the right. If you click it once, the Navigation pane collapses to the left, if I click it again, it opens up again. Now one of the most useful keyboard shortcuts in all of Access is the F11 key. This will collapse and reveal the Navigation pane. If I press F11, you'll see it shrinks down and it opens up again. Using F11 you can quickly open up the pane when you need it, then get it off the screen so you have more room to work.

So that's the Navigation pane. It's the central hub to the entire database. Getting around your objects using the Navigation pane is really easy, and with so many options to Group, Sort and Filter your objects to meet your exact needs, means that you can be moving around from object to object in the most efficient manner possible.

Show transcript

This video is part of

Image for Access 2013 Essential Training
Access 2013 Essential Training

84 video lessons · 28338 viewers

Adam Wilbert
Author

 
Expand all | Collapse all
  1. 1m 47s
    1. Welcome
      1m 5s
    2. Using the exercise files
      42s
  2. 23m 43s
    1. Key database concepts
      4m 21s
    2. Launching Access and the Backstage screen
      1m 41s
    3. Creating the database file
      3m 25s
    4. Understanding the Trust Center
      3m 2s
    5. Digging in to Ribbon tabs
      3m 39s
    6. Using the Navigation pane
      3m 36s
    7. Using the Quick Access Toolbar
      1m 14s
    8. Signing in to Microsoft Live
      50s
    9. Taking backups
      47s
    10. Accessing help
      1m 8s
  3. 23m 54s
    1. Understanding table structure and relationships
      4m 18s
    2. Creating a table and setting data types
      4m 15s
    3. Entering data
      4m 0s
    4. Understanding primary and foreign keys
      6m 24s
    5. Importing tables
      4m 57s
  4. 29m 37s
    1. Establishing relationships and maintaining referential integrity
      6m 28s
    2. Editing table structure in Design view
      3m 58s
    3. Controlling input with masks
      5m 4s
    4. Setting the default value
      2m 15s
    5. Establishing validation rules
      3m 21s
    6. Creating lookup fields
      4m 29s
    7. Setting additional field properties
      4m 2s
  5. 11m 3s
    1. Formatting columns
      2m 52s
    2. Sorting table data
      3m 18s
    3. Filtering table data
      2m 21s
    4. Searching and replacing values
      2m 32s
  6. 39m 35s
    1. Understanding queries
      2m 2s
    2. Creating queries with the Simple Query Wizard
      4m 24s
    3. Building queries in Design view
      4m 58s
    4. Establishing constraints with criteria
      4m 14s
    5. Specifying criteria with wildcards
      3m 50s
    6. Leveraging multiple criteria with AND and OR statements
      4m 32s
    7. Filtering with mathematical comparisons
      2m 20s
    8. Creating flexible queries with parameter requests
      3m 45s
    9. Building expressions
      5m 23s
    10. Obtaining summary statistics
      4m 7s
  7. 19m 13s
    1. Using update queries
      3m 21s
    2. Using make table queries
      2m 57s
    3. Using delete queries
      2m 48s
    4. Using append queries
      2m 49s
    5. Getting a different look with crosstab queries
      2m 58s
    6. Creating a union query in SQL view
      4m 20s
  8. 12m 47s
    1. Understanding the role of forms
      2m 52s
    2. Generating forms from tables
      3m 10s
    3. Adjusting form elements in Layout view
      4m 7s
    4. Using the Form Wizard
      2m 38s
  9. 44m 23s
    1. Creating forms in Design view
      3m 50s
    2. Exploring the form property sheet
      3m 13s
    3. Setting data sources
      5m 39s
    4. Adding components with form controls
      6m 8s
    5. Understanding input boxes
      3m 31s
    6. Recording navigation
      2m 36s
    7. Adding buttons
      4m 18s
    8. Assigning tab order
      4m 5s
    9. Checking out the More Forms options
      7m 27s
    10. Creating a navigation form
      3m 36s
  10. 32m 56s
    1. Introducing reports
      2m 15s
    2. Using the Report Wizard
      5m 9s
    3. Creating a report in Design view
      5m 20s
    4. Grouping and sorting records
      4m 5s
    5. Creating calculated totals
      3m 32s
    6. Applying conditional formatting rules
      5m 19s
    7. Creating labels
      4m 18s
    8. Adjusting print settings
      2m 58s
  11. 25m 0s
    1. Creating macros
      5m 3s
    2. Embedding macros into buttons
      7m 50s
    3. Attaching data macros to tables
      9m 5s
    4. Launching macros at startup
      3m 2s
  12. 12m 12s
    1. Exporting tables to Excel
      3m 8s
    2. Emailing with macros
      4m 4s
    3. Linking to data in an Outlook database
      2m 18s
    4. Setting up labels and mail-merge documents in Word
      2m 42s
  13. 27m 23s
    1. Organizing the Navigation pane with custom groups
      2m 59s
    2. Compacting and repairing the database
      1m 20s
    3. Examining database object relationships
      2m 58s
    4. Documenting your work
      4m 41s
    5. Printing the blueprint of your database with the Database Documenter
      2m 40s
    6. Splitting a database into front and back ends
      2m 33s
    7. Protecting the database with a password
      2m 55s
    8. Creating custom Ribbon tabs
      3m 35s
    9. Setting startup options and custom icons
      3m 42s
  14. 1m 6s
    1. Next steps
      1m 6s

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 2013 Essential Training.

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.