Why donâ??t many people use Microsoft Access?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

It might be because, it is seen as not being a "Proper" database like SQL, Server, for example, a lot of database developers look down on it, which is to miss the point. Access provides a compelling and functional front end to the database, and there is no reason why that database cannot be SQL Server....
read more
It might be because, it is seen as not being a "Proper" database like SQL, Server, for example, a lot of database developers look down on it, which is to miss the point. Access provides a compelling and functional front end to the database, and there is no reason why that database cannot be SQL Server. Most Access developers will use an external by default as it is more robust and also known to perform better than the internal database. To develop a traditional application on top of SQL Server, using Visual Basic or another programming language is costly and time-consuming. The same functionality can be created using Access in a short time. This can either serve as the permanent solution or as a test system, or proof of concept for a more substantial final development, which will be more cost-effective as any process or logic or data glitches will have been ironed out. So it does have a place - you need to know how it best fits in. I hope this helps. read less
Comments

Related Questions

How to use vlookup in excel?
Syntax for using vlookup function is =VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUMBER)
Profile Photo
Ankita
0 0
View Comments7
I am looking to learn immediately Advanced Excel & VBA Macros. Please provide the Institute contact details and tutor availability in week ends ( Sat- Sun) .
Hi Pratap, Would you please let me know your educational background as to know VBA Macros , you must have good hands on Programming...and if you are novice or not from it background then I suggest you...
Profile Photo
Prathap
What is use of VBA? Can you explain it?
Hi Venkat, As per my opinion and experience, we are using VBA for reducing the repetitive task in excel. For example: Suppose every day you are preparing an attendance tracker in which you will mark present/absent...
Profile Photo
Venkat
0 0
View Comments5
How do I type new line inside a single cell? I don't want to go to another cell but there should be a new line inside 1 cell. Please help.
You can type Alt+Enter, in case you wanted word wrap, then goto the Home Tab, Alignment group and select Word Wrap otion
Profile Photo
Arjun

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

VBA Function - RIGHT
RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...
Profile Photo

PowerPivot For Excel
PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...
Profile Photo

Hidden Gems of MS Excel - Reapply Filter
Q) How does Reapply help? Or, when could I use Reapply?A) e.g. Please refer following screenshot: You are Analysing a Dataset.You have applied Filter on Date Column, to focus on April month entries.You...
Profile Photo


Advanced Excel and VBA concept
In this video, learn about Advanced Excel: - Data Input and Hidden Features, - Worksheet Navigation, - Excel Formulas & Functions, - Data Cleaning and Formatting. VBA and its useful Built-in Functions,...
N

Nagadarshan

0 0
View Comments0

Recommended Articles

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you