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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

can you change from one template to another



 
 
Thread Tools Display Modes
  #1  
Old October 17th, 2009, 06:07 AM posted to microsoft.public.access.tablesdbdesign
deebarb
external usenet poster
 
Posts: 1
Default can you change from one template to another

This is my first attempt at using access so please be gentle.

I am uncertain at this time which fields I will actually need for my
database. If I select one template, can I convert or import the data to a
new template at a later time or would it be easier to start with what I know
I need and add on as necessary.
  #2  
Old October 17th, 2009, 04:50 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default can you change from one template to another

Start with a template that is the closest to what you need. If another
template has one or more tables you would like to use, go to File - Get
External Data and import the table(s). Once you import the tables, modify as
necessary and then be sure to create any necessary relationships between the
imported tables and the original tables. In the same way you can also import
queries, forms, reports and modules.

Steve



"deebarb" wrote in message
...
This is my first attempt at using access so please be gentle.

I am uncertain at this time which fields I will actually need for my
database. If I select one template, can I convert or import the data to a
new template at a later time or would it be easier to start with what I
know
I need and add on as necessary.



  #3  
Old October 19th, 2009, 01:50 PM posted to microsoft.public.access.tablesdbdesign
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default can you change from one template to another

You would do well to read up on Access and relational databse fundamentals.
Here are some links to get you started. IMHO Crystal's tutorial is as good a
place as any to get started.

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

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

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

In answer to your questions, you can import data from one database to another,
but it may not be a trivial task. You need to assure all expressions, code,
and queries are using the new names, establish relationships between the
tables if they are not already exactly what you need, and a number of other
things to be sure the data works as intended in the new database. It would
be best to establish your design before adding any data.

deebarb wrote:
This is my first attempt at using access so please be gentle.

I am uncertain at this time which fields I will actually need for my
database. If I select one template, can I convert or import the data to a
new template at a later time or would it be easier to start with what I know
I need and add on as necessary.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200910/1

 




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 06:18 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.