Ms Access Front – Hindi

person icon Ajay Parmar

4.3 ★★★★ ★

Buy Now

Ms Access Front – Hindi

Name: Ms Access Front – Hindi
Rating: 4.3 (64 reviews)
Author: ajay parmar

Ms access for mis reports - Hindi lang

updated on icon Updated on Mar, 2024

language icon Language - English

person icon Ajay Parmar

category icon Office Productivity,Microsoft,Microsoft Access

Lectures -14

Duration -13.5 hours

4.3 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

This course is talking about MS ACCESS Front end. Program is for those students who want to learn MS Access and take their knowledge to new heights.
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
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 the access operators like in , not in, <>, wild characters (*,?) , between,> ,< signs
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.
Project discussion in the end so that what we have learn can be easily understood .How it works in real life.
This course talks about different types of Joins like inner, left, right,outer or full
we talk about live situations and how to deal with them using joins or sub queries
we talk about use of IIF function in access query
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
how to 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
how to email the data without using vba
how to work with images if you like to do it
In last . one project shared with you which covers above said point in detail. Everything is downloadable and you can practice.
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 convert inbuilt macro to VBA Code .
Your questions time to time is attended and given the resolution.
Project for you – how to open the second form from inside the first form but on opening the form, its controls should be locked.
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

Goals

What will you learn in this course:

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

Prerequisites

What are the prerequisites for this course?

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

Curriculum

Check out the detailed breakdown of what’s inside the course

Let us start
14 Lectures

Introduction to Tables – Data import and export 01:16:03 01:16:03
Intro to Tables continues – Rules and Integrity 01:04:23 01:04:23
Queries – Select with many examples 01:17:22 01:17:22
Append make table update Queries 52:00 52:00
Group By Union & Cross tab query and wizard 20:35 20:35
Functions 55:56 55:56
JOINS Types -Lookup easy now 01:28:37 01:28:37
UserForms 53:49 53:49
Userforms more discussion 01:41:07 01:41:07
Forms with Macros 48:04 48:04
Subforms and combo and listbox 49:10 49:10
Idea for a project for you 34:09 34:09
Macros Tempvar setval – Very important for automation 42:40 42:40
Data import export Macro 52:41 52:41

Instructor Details

ajay parmar

Course Certificate

Use your certificate to make a career change or to advance in your current career.