Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Is Microsoft Access a relational database?

Posted on 2008-06-15
18
Medium Priority
?
1,362 Views
Last Modified: 2010-07-27
I have heard in the past that Microsoft Access is not a relational database. Is this true?
0
Comment
Question by:dovidf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 5
  • 3
  • +1
18 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 1000 total points
ID: 21790699
I purchased "Step by Step", a book to walk you through the changes of Access 2007. The first sentance in the introduction starts out with "Microsoft Office Access 2007 is a powerful relational database application...." Yes, it's a relational database.

Flyster
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 21790786
Absolutely, positively, definitely, unequivocally for sure ... YES!

*WHERE* ... did you hear that it's not?
0
 
LVL 4

Author Comment

by:dovidf
ID: 21790816
In the industry, Access is not put together with Sql server, oracle or db2.

I guest that's because it does the querying work on the client side, doesn't have stored procedures or triggers, and it uses a non standard SQL.

However, it's a great and friendly system.

Thanks for the clarification.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 75
ID: 21790829
"Access is not put together with Sql server, oracle or db2."

On the contrary.  There are many place wherein Access is used as a front end to the enterprise databases you mention above.

mx
0
 
LVL 4

Author Comment

by:dovidf
ID: 21790845
I know that you can front end it but to get it run right you have to convert it to passthrough SQl.

Unfortunately, people who look for a database development job and only have Access on their resume are not considered to have relational database experience by many.

I've used access to link all sorts of incompatible databases such as Sybase and Oracle.

It deserves better.
0
 
LVL 75
ID: 21790876
"and only have Access on their resume are not considered to have relational database experience by many."

LOL.  Sorry, but that is just not the case.  The 'many' are only those that have no clue what can actually be done with Access.  And after  16 straight years of working with Access ... that ain't much :-)

mx
0
 
LVL 4

Author Comment

by:dovidf
ID: 21792892

"LOL.  Sorry, but that is just not the case.  The 'many' are only those that have no clue what can actually be done with Access.  And after  16 straight years of working with Access ... that ain't much :-)"

That's true. However, all too often the people doing the hiring are not the most knowledgeable.
0
 
LVL 22

Expert Comment

by:dportas
ID: 21932982
"Access" is the name of an application development tool, not a database. The Access product does include the Jet/ACE database engine. Jet, ACE and their related components are NOT relational because they are based on the SQL model of data, not the relational model.

It's true that SQL borrows certain ideas and terminology from the relational model but SQL is fundamentally non-relational, most obviously because it is bag-oriented rather than set-oriented and therefore SQL's tables are not relations. This is far from the only difference between the two models though. If you aren't familiar with the RM then I would suggest a good book on database foundations such as those by Date, Codd or Fabian Pascal.

So what dovidf heard is quite correct. Of course there must be many users of Access who don't mind one way or the other but if you have to ask the question then the answer must be no. Access is not a Relational Database Management System (RDBMS).

Note: Correctly speaking, "database" means an organised collection of data, whereas "DBMS" is the management system - the software used to manage that data. No piece of software is a "database".
0
 
LVL 75
ID: 21933964
""Access" is the name of an application development tool, not a database. "

LOL.   That's just wrong!

"So what dovidf heard is quite correct. "
No it is not!

 Access is, in every respect ... a relational database product, or to use your words ... an application development tool to develop 'relational' database applications.

mx
0
 
LVL 22

Expert Comment

by:dportas
ID: 21934360
DatabaseMX: Are you aware what a relation actually is? Perhaps you aren't. The data structures used by Access and other SQL DBMSs are not relations and the operators they use are not relational ones. These are quite precise definitions in the database canon, which leave no room for doubt about what is relational and what isn't.

If you were truly familiar with the relational model then I don't think you would make such assertions. On the other hand if you are only familiar with database vendor marketing and books about Access then you could be forgiven for not knowing the difference between a SQL DBMS and a relational one. If you are interested in furthering your knowledge then check out Chris Date's "Introduction to Database Systems" for example.
0
 
LVL 75
ID: 21934388
LOL !!!!

I'm not really going to debate this any further.

mx
0
 
LVL 75
ID: 21934396
"On the other hand if you are only familiar with database vendor marketing and books about Access"

LOL ... not that it would be matter to you, but I'm just a little beyond the 'book' phase of Access ... after 16 years of 24x7x365 !!

mx
0
 
LVL 22

Expert Comment

by:dportas
ID: 21934454
You've made my point for me. If your entire knowledge is based on Access then you won't know the relational model so you aren't qualified to comment on it. You are a prisoner of Plato's cave.

You apparently aren't interested in a serious discussion. Others who want to learn can look up the references I cited and draw their own conclusions. Then they can judge whether those references or your humorous remarks have been more useful to them.
0
 
LVL 75
ID: 21934497
Actually, I would say **YOUR** qualifications are in question here.  And the more you talk, the deeper you are digging yourself into a hole.  You either an IT guy or a VB guy who is totally clueless as to what Access is and what can actually be done with Access ... in terms of building RELATIONAL Databases, or any other aspect of Access!  

mx
0
 
LVL 22

Expert Comment

by:dportas
ID: 21934566
But I am not asking you to trust MY qualifications. I am asking you to read the standard texts on the topic by the people who discovered and studied the relational model.

I have barely ever used Access so I admit I am largely ignorant about it. However, I do know it is based on SQL. The fact that it is based on the SQL model means that it cannot be relational.

You never answered my question. Do you even know what a relation is?
0
 
LVL 75
ID: 21934578
"I have barely ever used Access so I admit I am largely ignorant about it."

We're done now, lol !!

out
0
 
LVL 22

Expert Comment

by:dportas
ID: 21934593
Yep. And you still didn't answer my question or even say anything interesting.
0
 
LVL 75
ID: 21934674
Nope ... but you SURE did:
""I have barely ever used Access so I admit I am largely ignorant about it.""

later
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question