473,320 Members | 1,794 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

New to relational databases

Hello,

I'm new to relational DBs and I'm trying to learn. Just curious if
anyone has any suggestions on what I should be reading or taking a
class in first? Essentially, I'm looking to utilize Access to set up
a work management system.

Any suggestions are appreciated.

Thanks,

Ian

Jun 7 '07 #1
4 1180
Hi, Ian.
I'm new to relational DBs and I'm trying to learn. Just curious if
anyone has any suggestions on what I should be reading or taking a
class in first?
Microsoft MVP Tom Wickerath has a few links he always recommends for
beginners. One of the links to former Access MVP Jeff Conrad's Access
Junkie lists has been moved to another Web site. Please see the following
Web pages for resources:

http://www.accessmvp.com/JConrad/acc...abaseDesign101

http://groups.google.com/group/micro...1b19428ac92d0c

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
Jun 7 '07 #2
I would also recommend Dev Ashish's 'The Access Web' (http://mvps.org/
access/) as this contains lots of different code samples that will
give you a very good idea about the capabilities of Access.

As a rule of thumb, your application (if developed completely in
Access) should not have a size bigger than 2GB and should have
(depending on various factors) no more than 25 concurrent users.

I have found Access to be the *best* entry point to learn the
fundamentals (and more!) of relational databases so your starting
point is a solid one.

Good luck!

Jun 7 '07 #3
boston_dude wrote:
class in first? Essentially, I'm looking to utilize Access to set up
a work management system.
Ian
Hi Ian,

As someone who has written and worked with various work management
systems since 1bout 1991, I'd strongly recommend you get a very strong
backing in database theory and some practice before you embark on as
involved a project as this. You might have a simple concept at first,
but work management systems eventually and inevitably, because of user
requirements, spread out to all sorts of things, such as equipment and
vehicle management, fixed assets, parts inventories, scheduled
work/maintenace and a host of other things.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Jun 7 '07 #4
On Jun 7, 11:29 am, Tim Marshall
<TIM...@PurplePandaChasers.Moertheriumwrote:
boston_dude wrote:
class in first? Essentially, I'm looking to utilize Access to set up
a work management system.
Ian

Hi Ian,

As someone who has written and worked with various work management
systems since 1bout 1991, I'd strongly recommend you get a very strong
backing in database theory and some practice before you embark on as
involved a project as this. You might have a simple concept at first,
but work management systems eventually and inevitably, because of user
requirements, spread out to all sorts of things, such as equipment and
vehicle management, fixed assets, parts inventories, scheduled
work/maintenace and a host of other things.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me


Everyone,

Thanks a million for the advice. I'll start taking a look at the
sites and get back to you with any questions that I have.

Cheers!

Ian

Jun 7 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Matt Saunders | last post by:
There's lots of ways of representing a hierarchical data structure in a relational database. These range from the trivially easy to implement in PHP (adjacency list; each node has an ID and a...
34
by: yensao | last post by:
Hi, I have a hard time to understand difference and similarities between Relational database model and the Object-Oriented model. Can somebody help me with this? Thank you in advance. ...
18
by: comcast | last post by:
Hello all, I am developing an interface system for an application I was written. This interface will connect to other system to share information. I would like to use xml and xsl to generically...
0
by: Stylus Studio | last post by:
DataDirect XQuery(TM) is the First Embeddable Component for XQuery That is Modeled after the XQuery API for Java(TM) (XQJ) BEDFORD, Mass.--Sept. 20, 2005--DataDirect Technologies...
5
by: Martin Marques | last post by:
Has someone read this: http://www.wiscorp.com/sql/Sql99_p2.zip Are this guys at Whitemarsh Information Systems Corporation important in the SQL99 writing? -- select 'mmarques' || '@' ||...
49
by: Mike MacSween | last post by:
I frequently hear that there isn't a commercially available dbms that fully implements the relational model. Why not? And which product comes closest. Mike MacSween
1
by: Tim Fierro | last post by:
Hello, I have had many years using flat file databases (File Express from way back) but am now at a company where a relational database is needed and would carry us into the future. Since I...
6
by: Shwetabh | last post by:
Hi, I have a very simple question. In what cases are relational databases necessary? Are they really necessary in cases where only a single type of query is to be performed based on one unique...
7
by: Pradeep | last post by:
Hello, I need to take a set of input tables and create an XML output file. The format of the XML output must be user-definable and must be intuitive enough for non-techies to use. input...
13
by: sulyokpeti | last post by:
I have made a simple python module to handle SQL databases: https://fedorahosted.org/pySQLFace/wiki Its goal to separate relational database stuff (SQL) from algorythmic code (python). A SQLFace...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.