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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|