New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Start learning with our library of video tutorials taught by experts. Get started

Access 2013 Essential Training
Illustration by

Access 2013 Essential Training

with Adam Wilbert

Video: Welcome

(music playing) Hi! My name is Adam Wilbert and I would like to welcome you to Access 2013 Essential Training. We'll start by taking a look at what makes the relational database work, and how moving your information into Access can help make you more efficient with your time and with your data. We'll build tables to store our data and attach rules to help minimize data entry errors in order to ensure that our data remains consistent and reliable. Next, I'll introduce Queries, a powerful way to find, filter and sort your data in order to reveal exactly the information you need precisely when you need it.
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

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Access 2013 Essential Training
5h 4m Beginner Feb 08, 2013

Viewers: in countries Watching now:

Join author and database expert Adam Wilbert on a tour of the essential features of Microsoft Access 2013 and discover how to build a database and store your data more efficiently. First, Adam explains the concepts behind relational databases, before moving onto building tables—the foundation of any database. He then shows how to define the relationships between tables and use queries to find and filter data. The course also shows how to apply rules and validation to minimize data entry errors; build an interface for the database from forms, complete with interactive buttons and combo boxes; create reports for printing and sharing; and automate these tasks and many others with macros.

Topics include:
  • Understanding table structures and relationships
  • Setting primary and foreign keys
  • Establishing relationships and maintaining referential integrity
  • Sorting and filtering data
  • Building queries with constraints and criteria
  • Editing table data with queries
  • Generating forms from tables
  • Adding form controls
  • Creating reports with totals and labels
  • Embedding macros in buttons
  • Repairing your database
  • Protecting databases with passwords
Subjects:
Business Data Analysis Databases Teacher Tools Education Student Tools
Software:
Access Office Office 365
Author:
Adam Wilbert

Welcome

(music playing) Hi! My name is Adam Wilbert and I would like to welcome you to Access 2013 Essential Training. We'll start by taking a look at what makes the relational database work, and how moving your information into Access can help make you more efficient with your time and with your data. We'll build tables to store our data and attach rules to help minimize data entry errors in order to ensure that our data remains consistent and reliable. Next, I'll introduce Queries, a powerful way to find, filter and sort your data in order to reveal exactly the information you need precisely when you need it.

With forms we'll create a main user interface to your database. We'll build custom interactive elements with buttons and combo boxes to help us populate a database with data, and move around to accomplish different tasks efficiently. Reports will help us create a structure for printed documents and allow us to easily share insights about the data. And finally, Macros will help us automate tasks and keep everything running smoothly. So thank you for joining me in Access 2013 Essential Training.

There are currently no FAQs about Access 2013 Essential Training.

 
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.
Upgrade now


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 Upgrade now

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

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.