MS Access Front (Basic to Advance - 22 Hours)

Focused View

ajay parmar

22:20:12

5 View

1. Access Front End - Deep dive into TABLES

1. Access Terms - Let us get comfortable with Fundamentals.mp4

01:16:04

2. lmport Data techniques.mp4

51:49

3.1 assignment tables.zip

3.2 introduction.zip

3. Set Data Validations and Checks - Table Design.mp4

57:32

2. QUERIES - for Data modifications

1.1 Assignment.txt

1.2 introduction1.zip

1.3 introduction2.zip

1.4 introduction3.zip

1.5 introduction4.zip

1.6 introduction5.zip

1.7 introduction6.zip

1.8 queries.zip

1. Select Query.mp4

01:31:19

2. Delete Query.mp4

53:04

3. Append Query.mp4

46:47

4. Update and Make Table queries.mp4

45:32

5. CrossTab & Wizard features.mp4

38:32

6. Group Union & Drop Queries.mp4

01:01:59

7. Parameter Query & Project for you.mp4

26:16

3. JOINS TYPES with FUNCTIONS

1.1 db.zip

1.2 dlookup.txt

1. Joins with Primary Key.mp4

54:48

2. Joins -Unmatched.mp4

26:43

3. How to write functions - Left and Mid fx.mp4

47:55

4. Date functions.mp4

19:19

5. IF Function.mp4

24:27

6. DLOOKUP.mp4

35:05

7. SUM AVG MAX.mp4

08:07

8. GroupBy.mp4

08:41

9. SubQuery.mp4

18:06

10. Your Question - Use two functions to create a new output.mp4

20:24

4. FORMS

1.1 formsDb.zip

1.2 introduction.zip

1. Forms- Introduction.mp4

14:40

2.1 introduction.zip

2. Design View.mp4

31:05

3. Add Delete Duplicate Undo Form Buttons.mp4

15:55

4. Combo Boxes in forms.mp4

31:23

5. Linking of Combo Boxes.mp4

44:16

6.1 formsDb.zip

6. SubForms inside a Form.mp4

23:24

7. ListBox.mp4

05:36

8. How to use a query with form.mp4

45:12

9. Form Tips to improve Productivity.mp4

29:50

10. Formatting of Forms for a better view.mp4

10:26

11. Image Control.mp4

22:36

12. PROJECT.mp4

51:24

5. MACROS - Inbuilt

1. MessageBox.mp4

22:56

2.1 introduction.zip

2.2 introduction2.zip

2. How to Open a form.mp4

25:11

3. Multiple Macros in single macro.mp4

08:20

4. Set Var.mp4

25:49

5. IF OR.mp4

21:04

6. Import Export.mp4

34:13

7. Else if.mp4

32:21

8. DLOOKUP for Login Search using IF.mp4

32:02

Description

Tables ,Queries, SubQueries. Functions, Forms, SubForms, Inbuilt Macros ,Data Automation

What You'll Learn?

This course has 5 sections-Tables, Queries, Functions, Forms and Macros (22 hours content.)
You shall learn here a compete Access Front End. Its a Basic to Advance Level course
Access VBA Variables,Loops . SQL, Arrays, Collection Loops and much more
Learn how to create Dashboards using Access VBA -Super Advance
How to integrate MS Access with Excel Applicaiton to make reports and do data analytics
Answering student questions also. Supported files are available for you to download

Who is this for?

This course is for Data Analysts , MIS Analysts and those who want to clean, trim, structure data in ms access

If you want to create automation of reports, dashboards using access .especially if your data is very large

What You Need to Know?

You should have MS Access application on your system. 2007 Version or above is ok

More details

Description
This Course has Tables, Queries,Â Forms, Functions, Macros - 5 sections - Covered entire MS Access DB with you.

TABLES (CREATION,RULES,INTEGRITY)
What are the Tables- Their use, how to design them.
Why we use the Tables- Import and Export the data from external sources like text file, excel file, csv files and other sources like MS access itself.
Use of saving import and export steps to save time and automate the report. Its a great feature.
What are the different types of Validation we can apply on tables .
What are the rules one has to follow and keep in mindÂ while designing the Tables in MS Access- In detail discussion

Â Â Â Â QUERIES & SUB QUERIES
Select query with so many different examples including the SQL statement of same.Â Know select from front end as well as its SQL and why it is helpful if we know SQL too.
Update - Delete- Append- cross tab- Make Table - update - drop query - all action and select queries are discussed with examples
How to use query wizard to find out unmatched records or duplicate records .
How to use Group option in queries. To summarize the data like a pivot, how group feature works
Use of Sub- queries. It means how we can use one query inside the other query and how it works.
We talk about live situations and how to deal with them using joins or sub queries

Â Â Â Â FORMS & FUNCTIONS
How to use IIF in IFFÂ which is called nested IFF function
Deal with all date functions like dateserial, date,month,year,dateadd,datediff etc
How we can use text functions , upper, lower functions. MID LEFT RIGHT
How as a beginner we use the access query zoom option and wizard to find out the functions if they exist or not
Use functions using wizard and what are the things one should keep in mind while using them
Learn how to create a form from basics
What is the use of different types of views- Design,Layout and form view
Know about labels,text boxes,check boxes,option buttons,list-box and combo-box
How to put values in combo-box using SQL syntax
How to put value in combo box using select query wizard or manually
How to use row source property and customize the query being used in these controls
How to set up relationship between two combo-boxes
How to set up relationship between combo and list box
Learn how to use macro and query in forms - just a basic part
How to link form controls with queries and be able to generate wonderful projects
Learn about sub-forms from their design to their actual use in real life.
What is difference between control source and row source property of form controls and how to use control source for calculations
How to use add existing field tab

Â Â Â Â MACROS
This series is for those students who want to automate their access tasks by learning the in built access macros
Basic -intermediate and Advance level Macros explained in detail
How to use message boxes and input boxes with practical situations
Use of dynamic IF conditions using "AND" "OR" operators with else if
How to user IF macros and when and why we need multiple IFs so we can tackle multiple condtions.
Know the data import and export from outer applications like ms excel, text files and databases like ms access itself.
Learn about Auto-Keys and Auto Exec macros - their use
How to run queries, open tables and open forms
How to call one macro from other. How we can create a single macro which performs many actions in one go
How to define variables and use them in access macros.
Know about set temp vars and set property tasks
How to use DLOOKUP function in your projects and how it can lookup the IDs and validate the login information, if right user is logging in or not.
Copy object and delete the objects
How to set Filters

Who this course is for:
This course is for Data Analysts , MIS Analysts and those who want to clean, trim, structure data in ms access
If you want to create automation of reports, dashboards using access .especially if your data is very large

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Access

ajay parmar

Instructor's Courses

I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.