Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

relational databases

Forum home » Delegate support and help forum » Microsoft Access Training and help » Relational databases

Relational databases

ResolvedVersion 2003

Janice has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Relational databases

How can a relational database be defined?

RE: Relational databases

Hi Janice,

I would say a relational database is a database having data logically organised into tables that are related.

One that isn't relational would for example be where all the data is in one big table. In this case you might know the data is related within the table but the database program won't know because you haven't organised or defined it into tables and stated how which data relates to which and how.

Organising data into different tables is more efficient.

Regards, Mark (delegate)

RE: Relational databases

Dear Janice

Thank you for attending Access courses!! I hope you enjoyed the course and benefited from it.


Mark has kindly volunteered to answer your question. He has clearly defined the term. If you have further query please do not hesitate to relply to this post and ask for further clarification.


You have done the intermediate course after you posted this question. I am hoping that you have understood the benefits of a relational database such as relating tables so that you can have sub datasheets and sub forms, Creating calculated queries, etc...

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.18 secs.