A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to update old DB to New DB?



 
 
Thread Tools Display Modes
  #11  
Old December 17th, 2009, 07:19 PM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default How to update old DB to New DB?

sweetummy,

You are STILL to focused on the report and not paying attention to the
tables. Think of it like this...

Completed Database = House
Tables = Foundation
Queries = Rooms
Reports = Decor

You are so focused on the *Decor* that you don't realize you have built your
*House* on a POOR *Foundation*. So you need to refocus on the *Foundation*.
You have redundant fields (same fields showing up in more then one table).
That goes against normalization. So PLEASE go over the table set-up and
either redo or explain why you feel need redundant fields/data in more then
one place. Why is StudentID in the Areas tables when it will relate back to
Students table via the AreaID?

As a side note, stop using your reall eMail address or you will get alot of
unwanted mail. Spammers harvest here!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"sweetummy" wrote in message
...
Hi,
I must thank all of the great guys over here..supporting me right from
the intial stage..
I read tutorials regarding to your links given, they are simply
amazing and very helpful..

Coming to my database I have cut down all the tables according to
report demands..
1. We need reports according to the student id, by their course and by
their area they which belong by the academic year.

I understand that, the data should not be redundant should be unique
and should be related to each other table what we have logically in
our database and according to our demands..

So i have reduced to 3 tables.. namely
1. tbl_StudentDetails
2. tbl_courseDetails
3. tbl_AreaDetails

please look at this relationship and their fields in it.. i have
taken.. I thought a student is studying a so and so course and belong
to so and so area, here the only key is Student id so i make it as a
primary key and auto key column is the primary key for all these three
tables i have taken over here...

http://sites.google.com/site/gsvfilm...attredirects=0

thank you once again.






  #12  
Old December 18th, 2009, 07:12 PM posted to microsoft.public.access.reports
AxisNovice
external usenet poster
 
Posts: 4
Default How to update old DB to New DB?

Hi,

I understand

1. Tables to store related information and extract
whenever we need it.

2. Tables should maintain data uniquely without out any data
redundancy which may leads to database failure.

Justification :
But when the data is purely unique(having no relationship) to other
fields we cannot relate to other table hence we cannot extract the
data what we want.

Coming to my database i have taken 3 tables, tbl_Areasdetails and
course_details contains the data which is related to students..

the students table is said to be the master because I used the other 2
tables namely Areas and Courses are child table called as values from
these tables as combo boxes to restrict the unknown information...

I have restricted the user not to enter the erreneous information..
i have used the following sql statement to read the data from child
tables..
SELECT DISTINCT tbl_AreaDetails.str_Area FROM tbl_AreaDetails;

As you said the student id is not necessary in other tables so relate
the table just like this..

http://sites.google.com/site/gsvfilm...attredirects=0

I think important (uneditable) data should be in the tables so that we
cannot lost any information regarding to a student..

Ex: If we are maintaing all tables in a single file , If any student
is doing only BA degree if he has completed the course we need to
delete that information. At the same time we delete the course also
this make the data useless. So maintaining in other tables without any
data redundancy is better ..

thank you,

  #13  
Old December 19th, 2009, 02:18 AM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default How to update old DB to New DB?

AxisNovice,

Sorry but no, you don't understand. I can tell that by your table set-up
and the fields within the table. Please review the table set-up I outlined
for you in a previous post. You do not need Area and Region Belongs in two
tables only one the Area table. You do not Branch in two tables only one
the Courses table.

As for the restriction of data entry that can be handled on the form.

Storing all the information in one table is more like an Excel spreadsheet
which is a flat file. Queries will be used to form a *temporary* table to
get the information you need.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"AxisNovice" wrote in message
...
Hi,

I understand

1. Tables to store related information and extract
whenever we need it.

2. Tables should maintain data uniquely without out any data
redundancy which may leads to database failure.

Justification :
But when the data is purely unique(having no relationship) to other
fields we cannot relate to other table hence we cannot extract the
data what we want.

Coming to my database i have taken 3 tables, tbl_Areasdetails and
course_details contains the data which is related to students..

the students table is said to be the master because I used the other 2
tables namely Areas and Courses are child table called as values from
these tables as combo boxes to restrict the unknown information...

I have restricted the user not to enter the erreneous information..
i have used the following sql statement to read the data from child
tables..
SELECT DISTINCT tbl_AreaDetails.str_Area FROM tbl_AreaDetails;

As you said the student id is not necessary in other tables so relate
the table just like this..

http://sites.google.com/site/gsvfilm...attredirects=0

I think important (uneditable) data should be in the tables so that we
cannot lost any information regarding to a student..

Ex: If we are maintaing all tables in a single file , If any student
is doing only BA degree if he has completed the course we need to
delete that information. At the same time we delete the course also
this make the data useless. So maintaining in other tables without any
data redundancy is better ..

thank you,



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.