Override Excel limitation by Access
Learn basic Access programming
Override Excel limitation by Access
Breakthrough Excel’s barrier of One to Many Data protocol
Generate dynamic report out of existing data in the blink of an eye
Override Excel’s complicate Vlookup with Access simple Query Matching
Value added on career path
Learn how to handle bundles of data by ultimate database handling tool
Data mining will be just a piece of cake
Learn how to design program
Can make systems analysis with actual prototype in just a day
Learn how to convert program from standalone to network multi users system
Can produce printed form out of specific data, e.g. Staff Record, Invoice, PO, Quotation, Receipt etc.
Use the right tool for the right job.
Most of us use Excel for Database handling while doesn’t know the existence of Access which stand directly for Database job and being put on Microsoft Office next to Excel for decades.
Excel, actually, is great for Calculation, plenty of mighty function included and even good at figures presented with fantastic chart of all means. However, it’s far inferior than Access in term of Database handling.
There are many problems being addressed by using Excel for database handling, no matter of ‘one too many’ protocol, tough using of VLOOKUP, normalization, Dropdown making, data filtering, relational data handling and Network conversion etc.
Through this course, you will learn how to use Access, manage your database effectively.
And you will discover by yourself that all difficult tasks faced on Excel for database handling
will become just a piece of cake on Access.
Let’s enjoy knowing how Access work!
This Course covers Basic Access Programming, System Analysis, How to Design Effective Data Structure, Create Table; Query; Form Interface; Report; Printed Form and final at Program Conversion from standalone to network.
By the completion of this course, you will be able to create any Access programs on your own, causes all programs normally going on the same path but different on individual vision.
My course designed by Ms Access 2016 on basic tools, then it can be applied to all Access version from 2007, 2010, 2013. The only difference is menu or command location that change place from time to time on each version
About the course:
Course Published By Veerachai Junhunkit (Average rating- 4.4/5, Total Ratings- 40 )
Short Biography of Instructor:
I’m handling logistic and supply chain for more than 20 years.
Since it is chain operation, I know if I want to work well on my job I needed data from all parties concerned, no matter from Sales, Purchase, Planning, Store, Production, Warehouse or even my own Logistic, including Accounting and HR.
In the past, I had no real time data on hands, I’m blind. What I did, is just dump everything in as much to prevent shortage of material which will cause more worse on time and wages than space and interest paid for inventory. However, that’s not a real solution, caused I finally, ran out of space. Dead and slow, scattered around my store by such a dumping.
Then, I happened to realize that what I seriously needed is a Data and it is the only best solution to out of the mess. That’s where my first course in IT began.
I took PPD (Professional Programming Developer) course for 2 years, and hang on with Ms Access for over 20 years after that, because I learnt that Access is best fit for me. I’m not a programmer by the original. I just want some easy tool that can build up program for me and my chain on the fast track with highest mobility since trial and error is inevitable.
Access do the best job for me, whenever I need someone to give me info on real time, I give them my program interface. Once they key in, I got it! and all problem solved before it goes on big. And that’s where my Mini ERP started.
Since I got a lot of benefit from Access to my own Job, I’m willing to share it out to the one who are in the same situation or one who have in mind on how to improve their career part or their own organization, but no tool to express it out for real. I, then, open my private Access Training Class to give people all what I know from 22 years experience accumulated. And it’s already 5 years passed with more than 200 peoples being direct train up, and over 200,000 on YouTube, but I still willing to give more message to the rest that still keep on finding some tools to answer their requirement on data concerned jobs. So I create this course to share more.
Areas of Expertise
-Logistic and Supply Chain
-ERP (Enterprise Resource Planning)
-Shipping and forwarding
-Account and Finance
-Banking and Forex
Free Programming for your own use by MS Access course