HOT
blank

Microsoft Access 2019/365: Beginner To Advanced

Office Productivity

Rating4.6
Enroll Now

Microsoft Access 2019/365: Beginner To Advanced, available at $34.99, has an average rating of 4.6, with 35 lectures, based on 121 reviews, and has 5707 subscribers.

You will learn about Access Fundamentals: Creating Tables, Understanding the Primary Key and Data Types How to Query your Database: Select queries, filtering, sorting and queries that change data Relational Databases: Why and how we create links between tables All about Forms: Interfacing with our Databases, create forms with and without the wizard, creating sub forms to create sophisticated data capture and using split forms Reporting with ease: Using the Wizard to build a report or building a more bespoke report and adding special fields Data life-cycle: Exporting Data to Excel, Word or PDF. Importing Data from a variety of sources including a mail merge set up between Access and Word VBA & Macros in Access: Using buttons to carry out advanced functions, conditional outputs, use VBA to connect to SQL Server and much more! This course is ideal for individuals who are Anyone in who needs to create and maintain a Database for a small team /project. You could be an Analyst, Accountant, Management Consultant, Project Manager, Office Manager, EA,VA, PA etc It is particularly useful for Anyone in who needs to create and maintain a Database for a small team /project. You could be an Analyst, Accountant, Management Consultant, Project Manager, Office Manager, EA,VA, PA etc.

Enroll now: Microsoft Access 2019/365: Beginner To Advanced

Summary

Title: Microsoft Access 2019/365: Beginner To Advanced

Price: $34.99

Average Rating: 4.6

Number of Lectures: 35

Number of Published Lectures: 35

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: £99.99

Quality Status: approved

Status: Live

What You Will Learn

  • Access Fundamentals: Creating Tables, Understanding the Primary Key and Data Types
  • How to Query your Database: Select queries, filtering, sorting and queries that change data
  • Relational Databases: Why and how we create links between tables
  • All about Forms: Interfacing with our Databases, create forms with and without the wizard, creating sub forms to create sophisticated data capture and using split forms
  • Reporting with ease: Using the Wizard to build a report or building a more bespoke report and adding special fields
  • Data life-cycle: Exporting Data to Excel, Word or PDF. Importing Data from a variety of sources including a mail merge set up between Access and Word
  • VBA & Macros in Access: Using buttons to carry out advanced functions, conditional outputs, use VBA to connect to SQL Server and much more!

Who Should Attend

  • Anyone in who needs to create and maintain a Database for a small team /project. You could be an Analyst, Accountant, Management Consultant, Project Manager, Office Manager, EA,VA, PA etc

Target Audiences

  • Anyone in who needs to create and maintain a Database for a small team /project. You could be an Analyst, Accountant, Management Consultant, Project Manager, Office Manager, EA,VA, PA etc

Access has been around for over two decades and it’s not going anywhere due to it’s ability to be ‘up and running’ very quickly!

Sure, big companies like big databases that serve the company needs on an enterprise level but the value of access is about what can be done at a local level, in small teams and on smaller or temporary projects.

For example if you are working in a small company and you want to be able to manage your data whether that be some kind of sales data, expenses, marketing information or project focus data and you need to get up and running quickly with a database to handle it, well Access is definitely the tool for you.

You can be up and running in an afternoon with no need to get IT permissions or ask for a big budget! That’s why Access is known as a self-serving or end-user tool.

Given that is how Access is now used we have built a course with exactly that in mind, to teach you how to use Access for it to be a great end-user tool that you can get up and running quickly but also give your Database more advanced capability if you wish to.

In order to build the right course for you, we worked with Guy Vaccaro, who has been building Databases, including Access Databases for over two decades. Rather than build an unnecessarily long training, Guy has condensed his two decades of mastery in under 6.5 very focused hours, not learning unnecessary functionality so you can get up and running and maintaining your database in a very quick time frame!

As with all of our courses, if you are not happy, no worries, you have 30 days to get a full, no questions asked refund!

Course Curriculum

Chapter 1: Creating Tables

Lecture 1: 1. Creating and Saving a Table in Design Mode

Lecture 2: 2. The Primary Key

Lecture 3: 3. Important Field Properties

Chapter 2: Creating Queries

Lecture 1: 4. The Select Query

Lecture 2: 5. Filtering and Sorting Records using Numeric and Date Fields

Lecture 3: 6. Filtering and Sorting Records using Text Fields and Wildcards

Lecture 4: 7. Adding a Calculated Field to a Query

Chapter 3: Action Queries

Lecture 1: 8. Queries that Change Data

Lecture 2: 9. Adding Pop Up Parameters to Queries

Chapter 4: Linking Tables

Lecture 1: 10. Two Reasons for a Relational Database

Lecture 2: 11. Creating Links Between Tables

Lecture 3: 12. Multiple Table Queries

Chapter 5: Creating Forms

Lecture 1: 13. Creating a Form Using the Wizard

Lecture 2: 14. Creating and Editing a Form WITHOUT the Wizard

Lecture 3: 15. The Clever ComboBox Record Finder

Chapter 6: Creating SubForms

Lecture 1: 16. Forms Within Forms in a Relational Database

Lecture 2: 17. SubForms Based on Query Data

Chapter 7: Creating Splitforms

Lecture 1: 18. Use of the SplitForm Feature

Chapter 8: Creating Reports

Lecture 1: 19. Create a Report with the Wizard

Lecture 2: 20. Create a Report from Scratch and add Special Fields

Lecture 3: 21. Grouping with Reports

Chapter 9: Exporting Data

Lecture 1: 22. Export Data into Excel

Lecture 2: 23. Export a Report to Word or PDF

Chapter 10: Importing data

Lecture 1: 24. Import from Excel

Lecture 2: 25. Use of Paste Append

Lecture 3: 26. Import an Access Table from another Database

Lecture 4: 27. Create a Mail Merge in Word using Data from Access

Lecture 5: 28. Mail Merging in Word using Data from Excel

Chapter 11: Building VBA/Macros

Lecture 1: 29. Introduction to Access Macros

Lecture 2: 30. Introduction to Events in Access using VBA

Lecture 3: 31. Create a Form with Buttons to open/close other objects

Lecture 4: 32. Refresh the data in one combo box when another combo box is changed

Lecture 5: 33. Decide on a course of action based on user input

Lecture 6: 34. Using VBA to connect Access to a SQL Server backend database

Lecture 7: 35. The special AUTOEXEC macro

Instructors

Rating Distribution

  • 1 stars: 1 votes
  • 2 stars: 1 votes
  • 3 stars: 8 votes
  • 4 stars: 51 votes
  • 5 stars: 60 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

Google Ads MasterClass – All Advanced Features