Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-12-2015, 09:45 AM   #1
JamesJoey
Newly Registered User
 
Join Date: Dec 2010
Posts: 510
Thanks: 118
Thanked 0 Times in 0 Posts
JamesJoey is on a distinguished road
Database Design Question

My database currently uses 7 different data table ranging from a movie library, auto maintenance, reminders, home inventory...

Is it good practice to have all this data (which is a backend database) being accessed in one front end database?

Or should I create separate front ends for each specific type of data?

Any help will be appreciated,
James

JamesJoey is offline   Reply With Quote
Old 05-12-2015, 01:23 PM   #2
GohDiamond
"Access- Imagineer that!"
 
GohDiamond's Avatar
 
Join Date: Nov 2006
Location: Hartford, CT
Posts: 548
Thanks: 17
Thanked 48 Times in 46 Posts
GohDiamond is on a distinguished road
Re: Database Design Question

A single front end can handle it. If you want to keep the data in separate visual views then link it to different forms using tabbed documents and open all the forms at once. You'd have 7 tabs each with the table names on the tab that is its record source.

With the front end linked, you could place a copy of the FE on any computer on your LAN that has access to the BE and View the same data simultaneously (although editing the same record is by default locked).

Question is then, what are you going to do with this data? just store it so that its not forgotten?

CHeers!
Goh

Last edited by GohDiamond; 05-12-2015 at 01:23 PM. Reason: sp & gram.
GohDiamond is offline   Reply With Quote
The Following User Says Thank You to GohDiamond For This Useful Post:
JamesJoey (05-13-2015)
Old 05-13-2015, 11:10 AM   #3
JamesJoey
Newly Registered User
 
Join Date: Dec 2010
Posts: 510
Thanks: 118
Thanked 0 Times in 0 Posts
JamesJoey is on a distinguished road
Re: Database Design Question

Ok.
Thanks much,
james

JamesJoey is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database design question; Limit records via table design or a query or both TimTDP Theory and practice of database design 3 06-05-2013 12:35 PM
Question on database design marcenmoni Tables 2 09-07-2010 05:15 AM
Database Design question merlin666 Theory and practice of database design 3 05-07-2009 02:27 AM
Database Design question lmnop7854 General 14 12-01-2004 05:31 AM
Database Design Question IP076 General 3 10-15-2004 08:23 AM




All times are GMT -8. The time now is 03:12 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World