Microsoft Access is a DBMS (also known as Database Management System) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
Course Fees: Rs. 5500 /-
Course Duration: 20 Hrs.
After completing this course, students will be able to:
- Identify the components of the Microsoft Access 2010 environment.
- Identify the components of a database.
- Organize data in tables. View data in tables.
- Query a database.
- Design forms.
Access is the database package within the Microsoft Office suite. We are often asked why we recommend MS Access over other databases, so here is a list of what we believe are the benefits and advantages of using Microsoft Access.
- Quick and easy to create database systems.
Microsoft Access is an excellent tool for creating bespoke systems that have a database at their heart. It includes various wizards to speed up the process of creating a database application, and a vast array of readily available functionality. For an expert programmer specialising in MS Access, we find that development time is approximately half that needed for creating the same system using a different platform. This is a huge advantage. It translates directly into a cost-saving for you and it means that turn-around times are usually a matter of a few weeks from inception through to delivery.
- Microsoft Access produces very user-friendly applications through its comprehensive programming language (VBA).
You may find that you can produce a very basic database in Access yourself. But with a bit of magic from an expert VBA programmer you can turn a database into a fully-fledged user-friendly application. There are hundreds of examples of how we have used programming code in our clients’ systems to provide a user-friendly interface, and to automate processes – from buttons to open screens or to jump between them, to buttons to calculate and submit VAT returns to HMRC; from automatically populating one box dependent on the user’s choice in another, to automatically sending out reminder emails when a milestone is passed. The end result is always an easy-to-use system that fits around the way that your business works.
- MS Access produces flexible and adaptable database systems.
Access really scores here. Nothing in your system need ever be written in stone! Whilst it isn’t as quick to make changes as it is to create systems in the first place, it is still much quicker to amend things in Access than it is in other packages. And if you need to add new bits into your system they can often be integrated as quickly as creating something new. In practice this means that Access is perfect for the real-life business world. Things change and your system can change with them – without costing you the earth, and without long time delays.
- Well-known so you can get help and support easily.
Access and its VBA programming language are known by many developers, programmers and software companies. This means that if you create a system using MS Access, you will not be stuck with the person who created it for you. So, if they move on or retire, you will not be left high and dry. One important point to note here though – you must make sure that you have the source files. These will be .mdb or .accdb files; .mde or .accde files are not source files and cannot be examined or amended by another programmer. A reputable developer will always make sure that you have the source files and that you know it! Another point to note here is that, because Microsoft Office and VBA are so widely-known, programmers’ rates are lower than for other programming languages, again contributing to a lower cost to you.
- Microsoft Access has been around for a long time, so expertise is not going to disappear.
We have been creating systems in Access since 1994, and Access was already around then. It has always been included as part of Microsoft Office, and this is not going to disappear any time soon! Businesses who chose Access back in 1994 still have a system that is not obsolete, and there aren’t many other businesses who can say the same thing. If you want a system that is going to have longevity, then Access is a great choice.
- Part of the Microsoft Office suite so is fully integrated with the other MS Office packages, like Word, Excel & Outlook.
Simple examples here are mail merging in Word, sourcing the names and addresses (and anything else you like) from your Access database, and then sending out the mailshot via email using Outlook. And this is the level of integration available to a normal user, without any programming or anything! Similarly, with exporting data and reports to Excel for ad hoc analysis or turning an Access report into a pdf and attaching it to an email using the standard menus within Access. Via programming we can export data to specific file layouts or templates to satisfy the requirements of other systems; trigger emails from actions taken in a database; link and import data from external files automatically into an Access database; and so on. You won’t find any other database package with this sort of functionality so readily available.
- The capabilities of Access are constantly improving – now with good web integration.
With each new version of Microsoft Office, Access evolves bringing new capabilities. For example, Access 2013 allows you to create fully-integrated web apps that enable users away from their desktops to enter and view information from your business’ Access database system through a browser on any web-enabled device. This can be immensely useful to some businesses, and you can read more about some examples here.
- Often included in your existing Microsoft Office licence – for business users at least.
If you already have a business version of Microsoft Office then you may well already have Access. This means that you can run and edit an Access application already using the existing software on your computer. Furthermore, users do not even need a licence for Access to run a system created in it. There is a free run-time version available from Microsoft for this situation. Be aware though, that the system needs to include, for run-time users, a few extra features that a developer might not otherwise include. And those users will not have the in-built functionality that comes free with a full Access licence.
- Scalable integration for large systems and expansion.
One criticism sometimes levelled at Access is that it is ???small-fry??? and not suitable for the ???big boys???. This is based around the undeniable fact that it has a basic database engine. Where we find that we need to create a system where there will be more than about 10 users using it at any one time, or where there are very large numbers of records (several hundred thousand, plus), we would stick with Access for the user interface files but would migrate the data to SQL Server. There is a free version of SQL Server available from Microsoft, and Access includes a wizard to move the data across. In practice, we have not needed to go down this route often, but when we have done so, it has worked well. And it has left the client with all the above benefits of using Access, whilst utilising the powerful database engine of SQL Server.
Yes, we provide 100% placement support to our students. Our curriculum is so extensive that our students rarely are unsuccessful in Job interviews.
All undergraduates will be eligible for paid internships in our mother organisation Innovative Media Services. The stipends will vary from INR 4500 to INR 10,000. Graduates and above will be eligible for Job placements.
Yes, Fees can be paid in instalments.
Yes, backup classes are provided but up to 12 hrs.
Yes, trainers are available over phone but the students are advised to use discretion when calling up the trainers.
Yes, we offer live project exposure to students after the end of every module.
No, you will be able to develop your website by yourselves.
You may contact the administration for any queries regarding study in non-office hours.
You will be eligible for 12 certifications.
A standard 10+2 with basic computer operational knowledge is sufficient for eligibility.
A minimum of 75% marks and an attendance of 80% is mandatory to gain certified status.
We have flexible batch timings for all students including working professionals.
we offer training materials in the form of study books to our students. E-books/PDF formats are free but hard bind books will incur a small charge for printing.
Doubt clearing sessions are held from time to time. Students may avail these sessions and if the doubt is regarding an entire module then student needs to co-ordinate with the admin for a class change.
Yes, you will receive $100 worth of free software, tools, plugins and themes from the institute.
Send an Enquiry