0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Microsoft Products

Access Beginners

**This course includes practice exercises and LIFETIME access** Learn to harness the power of Microsoft Access and get control of your data with this 2019 course.

4.1
(198 ratings) 609 students



Enroll now


What you will learn

Where to start in Microsoft Access and whether to use a template or not
How to modify Access to suit your needs
All about importing data and the datasheet view
How tables work in Access and how to create relationships between them
Creating forms and sub-forms that feed data into your tables
How to run queries in Access
Setting up validations and calculations using expressions in Access
Printing from Access
To start to use macros and Modal Dialog
The basics of the Access web app
Exporting and reporting in Access

Who should take this training

Prerequisites

  • Microsoft Access 2019 for Windows

Target audience

  • Anyone new to Microsoft Access Users new to Microsoft Access 2019 and those upgrading from previous software versions Anyone new to the data management role Anyone who wants to learn data management and Microsoft Access

About this training

Introduction to Microsoft Access:

- The training typically begins with an introduction to Microsoft Access, explaining basic concepts, the user interface, and associated terminology.

Database Creation:

- Participants learn how to create databases from scratch, defining tables, fields, and relationships between data.

- Form Design: The training covers the creation of custom forms for user-friendly data entry, viewing, and modification.

Query Creation:

- Participants discover how to create queries to extract specific data, perform calculations, and generate reports.

Reports and Outputs:

- The training also teaches how to design professional reports to effectively present data stored in the database.

- Task Automation: Participants may learn how to automate repetitive tasks using macros and VBA (Visual Basic for Applications) modules.

- Performance Optimization: Participants can learn techniques to improve the performance of their databases and avoid maintenance issues.

Hands-On Exercises:

- Microsoft Access training often includes practical exercises to allow participants to apply the concepts they have learned.


Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 290

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 520 $ 495

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 810 $ 648

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

1. Introduction
1. Introduction to Access 2019 03:20 mins
2. Acquiring Access 2019 04:24 mins
3. Structure of the Course 02:23 mins
2. Getting Started with Access 2019
1. Using Database Templates 10:57 mins
2. Creating, Saving and Opening Databases 06:41 mins
3. The Access Workspace and Backstage 13:42 mins
4. Online Help and Tell Me What You Want To Do 08:43 mins
3. The Ribbon and Toolbars
1. Working with the Ribbon 09:29 mins
2. The Quick Access Toolbar 05:58 mins
3. Contextual Menus 02:39 mins
4. The Status Bar 04:07 mins
4. Keyboard Shortcuts and Key Tip
1. Keyboard Shortcuts 03:37 mins
2. Key Tips 03:53 mins
5. Access Options
1. Exploring Acces Options 09:16 mins
6. Tables
1. Creating a Table and Fields 11:31 mins
2. Indexed Field 08:43 mins
3. Lookup Wizard 11:36 mins
4. Numeric Fields 07:47 mins
Practice Exercise 01 03:08 mins
7. Importing Data
1. Importing Data from Excel 10:57 mins
Practice Exercise 02 05:39 mins
8. Backup, Restore and Repair
1. Backing up your Database 03:57 mins
2. Compact and Repair 06:24 mins
9. Datasheet View
1. Design in the Datasheet View 10:13 mins
2. Sorting and Filtering in Datasheet View 09:56 mins
3. Entering and Modifying Data in Datasheet View 10:56 mins
10. Relationships
1. Creating a Link Table 10:36 mins
2. Setting up Relationships 09:55 mins
Practice Exercise 03 10:22 mins
11. Forms
1. Creating a Form 12:41 mins
2. Modifying a Form 05:16 mins
Practice Exercise 04 02:08 mins
3. Forms in Layout View 11:12 mins
4. Forms in Design View 10:00 mins
5. Form Design 11:11 mins
Practice Exercise 05 01:33 mins
12. Subforms
1. Setting Up Subforms - Part 1 13:02 mins
2. Setting Up Subforms - Part 2 09:14 mins
3. Setting Up Subforms - Part 3 13:24 mins
Practice Exercise 06 04:13 mins
13. Queries
1. Creating a Query 13:27 mins
2. Joins 08:30 mins
3. Query Wizard 12:40 mins
Practice Exercise 07 09:46 mins
14. Expressions
1. Setting Up Validations 10:41 mins
2. Calculation using Expressions 08:44 mins
15. Reports
1. Basic Reports 07:46 mins
2. Report Design 10:44 mins
3. Complex Reports 13:29 mins
Practice Exercise 08 02:23 mins
16. Printing
1. Printing and Print Properties 07:55 mins
17. More Data Types
1. Yes/No, OLE Objects and Hyperlink Data Types 11:22 mins
18. More About Forms
1. Form Controls 11:15 mins
2. Form Themes 12:37 mins
3. Navigation Forms 09:52 mins
19. Exporting
1. Exporting an Access Database 04:16 mins
20. Application Parts
1. Adding Application Parts to a Database 04:49 mins
21. More Access Options
1. Additional Access 2019 Options 05:42 mins
22. Info Tab
1. Edit Database Properties and Encrype with Password 05:32 mins
23. Course Close
Course Close 01:07 mins

Request more information

Similar courses

Join our mail list for news