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
  #1  
Old December 10th, 2009, 07:51 PM posted to microsoft.public.access.reports
sweetummy
external usenet poster
 
Posts: 20
Default How to update old DB to New DB?


hi,
i want renew my old DB to New DB.. so i have started to update the
tables to minimize the effort to display queries without any errors..
so i have created a NEWDB but how to insert the old DB Information to
new information..
how to put all old DB to new DB according to the contents i have chose
please help...

please follow the link to download and suggest me to how to connect..
and utilize the old db..

http://sites.google.com/site/gsvfilm...edirects=0&d=1

thankyou,
  #2  
Old December 10th, 2009, 08:23 PM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default How to update old DB to New DB?

I'm not willing to risk following links I'm not familiar with, but I do have
a possible approach for you...

If you open the new Access database, link to the tables in the old DB, and
use queries to 'load' the new DB's tables from the old, would that do what
you want?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"sweetummy" wrote in message
...

hi,
i want renew my old DB to New DB.. so i have started to update the
tables to minimize the effort to display queries without any errors..
so i have created a NEWDB but how to insert the old DB Information to
new information..
how to put all old DB to new DB according to the contents i have chose
please help...

please follow the link to download and suggest me to how to connect..
and utilize the old db..

http://sites.google.com/site/gsvfilm...edirects=0&d=1

thankyou,



  #3  
Old December 11th, 2009, 03:10 AM posted to microsoft.public.access.reports
sweetummy
external usenet poster
 
Posts: 20
Default How to update old DB to New DB?


hi jeff,
I have changed the structrure of the database so i want to put the old
db to new db..using the old data..
you can safely download it no pwd required..i have created a subform
to call the expenditure entries by particular student in the
database.. now to reinnovate i need to cross tab the present old
database.. I'm struck up there..
if you can see the structure of the database and the form i have
created you can understand...

thank you for replying me...
  #4  
Old December 11th, 2009, 05:06 PM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default How to update old DB to New DB?

Please reconsider posting some of the details here in the newsgroup ...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"sweetummy" wrote in message
...

hi jeff,
I have changed the structrure of the database so i want to put the old
db to new db..using the old data..
you can safely download it no pwd required..i have created a subform
to call the expenditure entries by particular student in the
database.. now to reinnovate i need to cross tab the present old
database.. I'm struck up there..
if you can see the structure of the database and the form i have
created you can understand...

thank you for replying me...



  #5  
Old December 11th, 2009, 06:18 PM posted to microsoft.public.access.reports
sweetummy
external usenet poster
 
Posts: 20
Default How to update old DB to New DB?

Hi,

The database belongs to voluntary organization - Higher education
grant for poor students the organization helps for their education. In
the mean time 5 years back one of my senior collegue designed a
database with some basic database knowledge..

About the database: According to their courses the tables are designed
for each course he created a new table to enter the data.. There are
nearly 10 different courses with the same fields using with mail merge
option we used to take prints and send them to field offices loacted
in their areas.. so we need to enter the details according to their
personal details and amount given to them according to their academic
year..
i have designed the reports how i need it.. but i have nearly 10
thousands of records in the file now i want to merge the whole data..

The main two drawbacks are
1. we are unable to extract the data what we want...
2. As the data is enormous we are unable to merge the whole data in
one table as their id are autonumbers and the same numbers are in
other tables also..
3. for each year we have to add the academic year and expenditure of
the present year other wise we cannot extract the record..

so i'm in great confusion to get the data properly..
if you can see the data and its structure of old and new and other
word documents given you can get a clear idea to explain back to me..

thank you once again..

bye..
  #6  
Old December 16th, 2009, 12:30 AM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default How to update old DB to New DB?

?There's a new table for each course? That sounds like a spreadsheet, not a
relational database.

If there is one table per course, my first recommendation is to review
"normalization" and "relational database design". In a well-normalized
Access database/application, you'd probably need only ONE table for course
information. That would seem to make querying much easier.

To combine data from one table to another, please see my previous response.
If you are saying "database" but meaning "table", you wouldn't have to link
to the other database before creating a query that appends data from one to
another.

NOTE: backup, backup, backup, before running an append query or any other
function that alters data.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"sweetummy" wrote in message
...
Hi,

The database belongs to voluntary organization - Higher education
grant for poor students the organization helps for their education. In
the mean time 5 years back one of my senior collegue designed a
database with some basic database knowledge..

About the database: According to their courses the tables are designed
for each course he created a new table to enter the data.. There are
nearly 10 different courses with the same fields using with mail merge
option we used to take prints and send them to field offices loacted
in their areas.. so we need to enter the details according to their
personal details and amount given to them according to their academic
year..
i have designed the reports how i need it.. but i have nearly 10
thousands of records in the file now i want to merge the whole data..

The main two drawbacks are
1. we are unable to extract the data what we want...
2. As the data is enormous we are unable to merge the whole data in
one table as their id are autonumbers and the same numbers are in
other tables also..
3. for each year we have to add the academic year and expenditure of
the present year other wise we cannot extract the record..

so i'm in great confusion to get the data properly..
if you can see the data and its structure of old and new and other
word documents given you can get a clear idea to explain back to me..

thank you once again..

bye..



  #7  
Old December 16th, 2009, 04:54 PM posted to microsoft.public.access.reports
sweetummy
external usenet poster
 
Posts: 20
Default How to update old DB to New DB?

Hi ,
thank you for replying me..

Yes, thats why i've started renewing the database to new.. even that
too useful some extent... we used to call that data by mail merging
the each table in ms-word. so it would be easier for us to distribute
the reports to the areas.. but its very hard to calculate the
expenditures and other advnced features..

thank you for your valuble tip.. i have made synchonised the required
fields to 3 tables..

1. Students table.
subform table.. (inclusive course details)
2 Course Table
3. AreaRegions Table..

the tables are related logically according to reports how we want..
you can see the picture here..

http://sites.google.com/site/gsvfilm...attredirects=0
(no need to take risk its simple as photo)

The main form will be like this..
http://sites.google.com/site/gsvfilm...attredirects=0

i got a doubt in main form .... I would like to trim it to some fields
like
trans_id, student_id, course, expenditure only not the whole course
table...

if the user tick the mark one more form should be displayed to enter
the higher education details.. is it better or only 1 sub form is
enough..

as you have seen the data is like a speadsheet , so i would like to
cross tab to suit my database design..

please suggest me..
  #8  
Old December 16th, 2009, 08:59 PM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default How to update old DB to New DB?

Please review normalization and relational database design. You can try to
make your database structure match the reports you want, but that is a
little like trying to use a bicycle to pull a train...

Instead, first get the data structure designed in a way that Access can use
(i.e., normalized), then use queries to pull the pieces of data you wish to
display in a report.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"sweetummy" wrote in message
...
Hi ,
thank you for replying me..

Yes, thats why i've started renewing the database to new.. even that
too useful some extent... we used to call that data by mail merging
the each table in ms-word. so it would be easier for us to distribute
the reports to the areas.. but its very hard to calculate the
expenditures and other advnced features..

thank you for your valuble tip.. i have made synchonised the required
fields to 3 tables..

1. Students table.
subform table.. (inclusive course details)
2 Course Table
3. AreaRegions Table..

the tables are related logically according to reports how we want..
you can see the picture here..

http://sites.google.com/site/gsvfilm...attredirects=0
(no need to take risk its simple as photo)

The main form will be like this..
http://sites.google.com/site/gsvfilm...attredirects=0

i got a doubt in main form .... I would like to trim it to some fields
like
trans_id, student_id, course, expenditure only not the whole course
table...

if the user tick the mark one more form should be displayed to enter
the higher education details.. is it better or only 1 sub form is
enough..

as you have seen the data is like a speadsheet , so i would like to
cross tab to suit my database design..

please suggest me..



  #9  
Old December 16th, 2009, 10:28 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 have a few issues with your tables... No Primary Key's, field names
that are Reserved Words, etc... So here goes nothing.

Your tables are not set for the benefit of your forms or your reports.
That's what queries are for. Your table structure should look more like...
(The *(???)* means, I have no clue what that is and why that is in that
table.)

tblStudents
sStudentID (PK)
sFirstName
sLastName
sSex
sCommunity (???)
sVillage (???)

tblCourses
cCourseID (PK)
cCourse
cBranchID (???)
cCourseTypeID (FK)
cGrantPerYear (???)
cRsInWords (???)

tblColleges
cCollegeID (PK)
cCollegeName
etc...

tblCollegeCourses
ccCollegeCourseID (PK)
ccCollegeID (FK)
ccCourseID (FK)

tblCourseEnrollment
ccCollegeCourseID (FK)
ceStudentID (FK)

tblAreas
aAreaID (PK)
aRegionBelongs (???)
aRegion (???)
aArea

If you don't understand the above then have a look at...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

http://www.databasedev.co.uk/table-of-contents.html

For a complete list of Reserved Words see:
http://allenbrowne.com/Ap****ueBadWord.html

--
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 ,
thank you for replying me..

Yes, thats why i've started renewing the database to new.. even that
too useful some extent... we used to call that data by mail merging
the each table in ms-word. so it would be easier for us to distribute
the reports to the areas.. but its very hard to calculate the
expenditures and other advnced features..

thank you for your valuble tip.. i have made synchonised the required
fields to 3 tables..

1. Students table.
subform table.. (inclusive course details)
2 Course Table
3. AreaRegions Table..

the tables are related logically according to reports how we want..
you can see the picture here..

http://sites.google.com/site/gsvfilm...attredirects=0
(no need to take risk its simple as photo)

The main form will be like this..
http://sites.google.com/site/gsvfilm...attredirects=0

i got a doubt in main form .... I would like to trim it to some fields
like
trans_id, student_id, course, expenditure only not the whole course
table...

if the user tick the mark one more form should be displayed to enter
the higher education details.. is it better or only 1 sub form is
enough..

as you have seen the data is like a speadsheet , so i would like to
cross tab to suit my database design..

please suggest me..



  #10  
Old December 17th, 2009, 06:56 PM posted to microsoft.public.access.reports
sweetummy
external usenet poster
 
Posts: 20
Default How to update old DB to New DB?

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.




 




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 11:52 AM.


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