Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Intro to Access - Microsoft Access Basics for Beginners
Rating: 4.6 out of 5(4,284 ratings)
44,761 students

Intro to Access - Microsoft Access Basics for Beginners

Intimidated by Access? Microsoft Access Basics walks you through creating your first simple database from scratch.
Created bySteve McDonald
Last updated 10/2019
English
English [Auto],

What you'll learn

  • At the end of this course, you'll be able to create a simple database from scratch.
  • You'll learn how to navigate the Access dashboard, tools and ribbon.
  • You'll know how to create a Table in Access.
  • You'll know how to create a Query in Access.
  • You'll know how to create a Form in Access.
  • You'll know how to create a Report in Access.

Course content

1 section • 9 lectures • 32m total length

  • Intro to Access Basics0:52

    Explore the basics of Microsoft Access and its moving parts through hands-on practice. Build a simple database with forms, reports, and queries to gain confidence and overcome initial overwhelm.

  • Opening Access1:31

    Open access to start a blank database, name it at creation, and create your first table from the opening screen. Follow along for hands-on practice saving to the documents folder.

  • Tour the Access Ribbon, Tools and Dashboard6:48

    Explore the Access ribbon and table tools to navigate between datasheet and design views, and learn to create tables, import and export data, and customize the quick access toolbar.

  • Create a Table in Access8:03

    Create a table in Access using design view, then switch to datasheet view to enter first name, last name, address, city, state, and phone as short text, saving as practice.

  • Create a Form in Access4:53

    Create and customize Access forms by binding a form to a table, using the form wizard or blank form, and editing and saving records in design view.

  • Create a Query in Access5:10

    Create a simple Access query using the wizard to filter the practice table by city Seattle. Display first and last names and optionally add phone numbers for targeted outreach.

  • Create a Report in Access2:35

    Create a report from a query using the report wizard, then refine it in design or layout view, preview, and save with a clear header like Seattle customers.

  • What Have You Learned?
  • Conclusion and Thank You2:31

    Create and explore a complete Microsoft Access database with tables, fields, records, queries, forms, reports, and learn to relate tables and build practical, beginner-friendly guidance.

  • Learn More - Other Courses by Steve McDonald (bonus lecture)0:30

Requirements

  • This course requires no previous knowledge of Microsoft Access.
  • It is helpful if you have a copy of Microsoft Access on your computer, but it's not neccessary.

Description

When you think about learning Microsoft Access do you feel overwhelmed or intimidated?

If so, you're in the right place. 

Microsoft Access Basics for Beginners is designed to get you started in Access by creating a very simple database from scratch. 

This is a very hands-on course where I'll walk you through it step-by-step. The lessons are short and easy to follow, and all of the steps are explained in plain English.

With this course, anyone can get started learning Access. It isn't going to make you pro, but after you finish this short course, if your boss starts talking about Queries, Forms or Reports, you'll know exactly what they're talking about. And you'll understand how to create one.

Click on into the course. I promise it'll be easier than you thought.

Who this course is for:

  • This course is for anyone who wants to learn to create a database with Microsoft Access.
  • This course is for you if you feel intimidated or overwhelmed by the thought of trying to learn Access.

Report abuse