Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 13 Minute(s)
Language
English
Taught by
Ermin Dedic
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Access VBA, Macros and GUI in one course. Follow database principles when Importing Excel to Access, via GUI and VBA.
Welcome to 'Microsoft Access: Access Tutorial, Level 1 & 2 (GUI, Macros, VBA)'.
We start with the Graphical User Interface of Access but then build up to Access Macros and Access VBA. We will also look at how to build a database by following all database principles.
All this means that you will go beyond learning how to use an existing database. We will give you a hands-on illustration of the key database principles so you can begin building a database on your own.
You will begin by exploring the 4 main objects of Access (tables, reports, queries, and forms), and then you build on that by learning about how to properly build a database.
We have seen quite a few courses on here who do a great job overall in teaching Access but then make fundamental mistakes when it comes to database design. These kinds of mistakes make it impossible to actually build a database on your own, unless the database is used for a trivial venture. You will learn about normalization, referential integrity, and other principles related to good database design.
For those of you spreadsheet experts from Excel, we have two course sections on importing Excel to Access via the GUI and Access VBA code. All of this while following database principles. If you're interested in learning the differences between Excel and Access, and how you may go about using both..this is a good opportunity.
This Microsoft Access Tutorial is perfect if you are a small business, or an individual, that needs to do a better job in terms of managing your data. If you want your data organized, and prepared for analysis and reporting. This course is perfect for you.
Microsoft Access is one of those programs that is currently highly undervalued, and this in large part because newer programs have come out, yet for 95% of businesses out there, Access has everything you need..and it is quite inexpensive and fairly easy to learn.
Microsoft Access is the perfect all-purpose database, and it can help your company store information and manage large amounts of data.
There is no risk. If you should not like the course, Udemy offers a 30-day money back guarantee. Get a valuable skill today!
Course Content
- 18 section(s)
- 99 lecture(s)
- Section 1 Introduction
- Section 2 Everything about Tables
- Section 3 Working with Reports in Access
- Section 4 Queries (Select Queries)
- Section 5 Action Queries
- Section 6 Forms in Access
- Section 7 Database Design 1 (Becoming a Database Expert from Other Areas)
- Section 8 Database Design 2, Illustrating Normalization Practically
- Section 9 Database Design 3, Table Design
- Section 10 Database Design 4, Relationships and Referential Integrity
- Section 11 Database Design Activity
- Section 12 Importing Excel into Access using GUI and Database Principles
- Section 13 Essence of Programming - Program Flow And Controlling Flow/Direction
- Section 14 An Intro To Access Macros
- Section 15 Importing Excel into Access using VBA
- Section 16 Finish Line
- Section 17 Extra Content - A bit about Dates and General Access Questions Answered)
- Section 18 Extra Free Content
What You’ll Learn
- Access Graphical User Interface and the 4 main objects (tables, reports, queries, and forms)
- Excel to Access Import While Following All Database Principles
- Access Macros - Discover How To Utilize Macros for simple tasks
- Access VBA Will Allow You To Import Excel Into Access Using Code
Skills covered in this course
Reviews
-
HHemant Gulati
Simple training for beginners! Downloadable resources if tagged with lectures with a link would have been perfect!
-
SScott D Fitts
Great course for refreshing basic skills.
-
BBarry Stapleton
Really liking this course. Making me think on how to construct a good working database
-
AAsad Ahmed
Overall good. But please stick to 1-2 databases. Also, more data analysis in access would be great. Perhaps give students a problem and ask them to solve it by building a query.
