Black Friday 2024: 25+ Ways to Save on Online Learning

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Microsoft Access Tutorial - Beginner to Advanced Training

via YouTube

Start learning Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Grab it

In this Access 2019 Beginner to Advanced training course, we cover the basics of Microsoft Access and expand to more advanced skills. We'll go over database templates, creating and saving your very first database, using the lookup wizard, backing up your database, and creating linked tables.

We'll also explore the datasheet view, how to set up a Northwind Database, link to tables in other databases, install the SQL Server Express, the basics macros, and so much more!

We've even included downloadable instructor and exercise files from our paid-for courses so you can follow along and complete the exercise in this course. This will help you put what you are learning into practice and master MS Access 2019.

Syllabus

- Simon Sez IT Intro
- Introduction to Access 2019
- Acquiring Access 2019
- Structure of the Course
- Using Database Template
- Creating, Saving, and Opening Databases
- Access Workspace and Backstage
- Online Help
- Working with the Ribbon
- Quick Access Toolbar
- Contextual Menus
- The Status Bar
- Keyboard Shortcuts
- Key Tips
- Access Options
- Creating a Table and Fields
- Indexing Fields
- Lookup Wizard
- Numeric Fields
- Exercise 01
- Importing Data from Excel
- Exercise 02
- Backing Up Your Database
- Compact and Repair
- Design in the Datasheet View
- Sorting and Filtering in Datasheet View
- Entering and Modifying Data in Datasheet View
- Creating a Link Table
- Setting Up Relationships
- Exercise 03
- Advanced Course Overview and Content
- Primary Keys and Indexing Rules and Guidelines
- More About Indexes
- Setting Up Northwind Database
- Working in Datasheet View
- Customizing Datasheet View, Sorting and Filtering Options
- Subdatasheets
- Exercise 01
- Linking to Tables in Other Databases
- Acquiring and Installing SQL Server Express
- Exercise 02
- Splitting Database into Front-end and Back-end
- Converting a Shared Table into a Local Table
- Exercise 03
- Addressing Multi-User Issues when Sharing Data
- Basics of Macros
- Macros on Events; AutoExec
- More about AutoExec
- Macro Security Settings
- Exercise 04

Taught by

Simon Sez IT

Reviews

5.0 rating, based on 4 Class Central reviews

Start your review of Microsoft Access Tutorial - Beginner to Advanced Training

  • Profile image for Fethi Ben Yahia
    Fethi Ben Yahia @fethiby
    it's a great course in addition to being concise and easy to follow the exercises are there to finish with the doubt the speaker in a soothing tone that I can follow her for hours. thank you also for the quality videos.
  • Mayuom Ajokber
    Students spend a great deal of time and money on tertiary study; therefore online subjects would be a better investment in terms of immediate job opportunities.
  • Profile image for Mohammed Adnan
    Mohammed Adnan
    good expirence and excelent teaching with great learning with online teacher and thanks

    Microsoft Access Tutorial: 7 Hours of Beginner to Advanced Training
  • Mario Melvyn Jimenez Alcántara
    Muy bueno aprendí muchas cosas que no sabia les recomiendo este curso quisiera repetir pero quiero aprender muchas cosas nuevas
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.