Learn Microsoft Access from Basic to advance Leven in Hindi

We will start this course from beginner’s level and after completion you can create complex applications independently. We took practical examples for better understanding of the concept of Database Management System.

Why should we learn MS Access?

There are plenty of Business Applications or ERP systems available to handle Business transactions. They all are readymade applications but there always need to customize these applications for some business transactions e.g. all businesses avail Transport, Taxi Services having different types of rate contract for using services. Company receive invoices for services received and has to verify these invoices with supporting documents and rate contracts and process their payments. No option available in the ERP Systems for verification such invoices because company have different kind of business, ERP systems made for handling their main business . Such Applications can be created for verification of invoices with Rate contract.

But we can do much more in MS Access. The scope of MS Access is very high in the Market.

There are major Four Parts in MS Access

Table – handle data
Form – Display data or Interact with User
Query – Generate MIS & Business Reports
Report – Display or Printing Reports : Final Output of Data

We explained above all topics in details and used in the Practical example of program of Electronic Store.

Course Curriculum

Introduction of Access and Understanding table structures
	1.1 What is the use of Access	FREE	00:00:00
	1.2 Basic understanding of Database		00:00:00
	1.3 Tips to make Best Database		00:00:00
	1.4 Start Access 2013		00:00:00
	1.5 Tools & Tab in Access		00:00:00
	1.6 Create First Table – Part 1		00:00:00
	1.7 Create First Table – Part 2		00:00:00
	1.8 Create Quick Table		00:00:00
	1.9 Create Table in Design Mode		00:00:00
	1.10 Table		00:00:00
Validation Rules and relationships
	2.1 Table		00:00:00
	2.2 Database Relation		00:00:00
Form Designing
	3.1 Create Forms Auto Mode		00:00:00
	3.2 Create Forms Auto Mode		00:00:00
	3.3 Design Forms using Wizard		00:00:00
	3.4 Form Designing Layout		00:00:00
	3.5 Tab Order Tab Stop		00:00:00
	3.6 Add Button in Forms		00:00:00
	3.7 Form Design Properties		00:00:00
	3.8 Form with Sub Forms		00:00:00
	3.9 Sub Form		00:00:00
Query Designing
	4.1 Introduction of Query		00:00:00
	4.2 Simple Query Wizard		00:00:00
	4.3 Query Design		00:00:00
	4.4 Query Filter		00:00:00
	4.5 Wildcard and Pop up		00:00:00
	4.6 Calculation Field		00:00:00
	4.7 Query Sum		00:00:00
	4.8 Cross Tab Query		00:00:00
	4.9 Query Other		00:00:00
	4.10 Update Query		00:00:00
	4.11 Delete Query		00:00:00
Report Designing
	5.1 Introduction of Reports		00:00:00
	5.2 Report Wizard – Part 1		00:00:00
	5.3 Report Wizard – Part 2		00:00:00
	5.4 Report Wizard – Part 3		00:00:00
	5.5 Creating Reports – Manual -1		00:00:00
	5.6 Creating Reports – Manual -2		00:00:00
	5.7 Printing Labels		00:00:00
Advance Techniques
	6.1 Message from Trainer		00:00:00
	6.2 Open Form at Opening of Access		00:00:00
	6.3 Add Header in Form		00:00:00
	6.4 Add Buttons in Form		00:00:00
	6.5 Dlookup		00:00:00
	6.6 Add Subtotal in Form		00:00:00
	6.7 Add Tax Rate in Form		00:00:00
	6.8 Open Report with Filter and Print		00:00:00
Linking Data with other applications
	7.1 Export Data in Excel		00:00:00
	7.2 Import data in excel		00:00:00
	7.3 Table linking with Excel		00:00:00
	7.4 Linking Excel with Access		00:00:00
Advance Database Tools
	8.1 Send email from Access		00:00:00
	8.2 Compact and repair database		00:00:00
	8.3 Encrypt with password		00:00:00
	8.4 Split Database		00:00:00