98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » database development in london - MS Access - best practice regarding forms | Access forum
database development in london - MS Access - best practice regarding forms | Access forum
Resolved · Low Priority · Version Standard
Thu 9 Aug 2007, 10:16Delegate Frances said...
Frances has attended:
Access Introduction course
Access Intermediate course
MS Access - best practice regarding forms
Hi there,
I'm in the process of creating an Oracle linked database which has about 48 tables. All the tables have been set up and I'm now working on forms... A colleague has recommended that I restrict my forms to cover one table at a time as including multiple tables could lead to problems (unspecified)... Is this your view too? It was my understanding that you can join tables in queries and then generate forms from them.
My database will capture Marine monitoring data at the project/program/series/platform/instrument/geographic, and other levels....
Frances
Thu 9 Aug 2007, 13:33Trainer David said...
RE: MS Access - best practice regarding forms
Hi Frances
I have not used Oracle myself, but I do have a lot of experience with IBM DB2. I think you should be OK using forms across multiple tables. I do not know of any problems using from across multiple tables in Oracle.
I assume that you are creating the forms for data input. If this is the case I do not see why you would need to do a query. Queries of for data extraction. If you are doing an sql insert across multiple tables it would look something like:
insert table1.name, table1.a, table1.b, table2.name, table2.a, table2.b into table 1, table 2Then if needed you can add on a where clause.
I suggest that you get a good grasp of what you are doing before you attempt it. Access is a very different database application compared to Oracle and implementing things learnt in access will probably not work with Oracle.
Hope this helps
David
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Changing MS Programs Text SizeA handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize. |
