Prev: Multiple Users?
Next: Digits on right of Decimal points
From: Ron A. on 5 Jul 2008 01:58
I need to create a database to track convention attendees, their lodging
arangements, Hotel info, if attendees need transportation to and from the
airport and convention and pickup/dropoff times, convention volunteers and
their assignments.

Would it be logical to do it all in one database or should I make 2. One for
the convention attendees info and lodging and 1 for the transportation needs
of the attendees? What would be the best solution?

--
Aloha,
Ron A.
From: boblarson on 5 Jul 2008 02:36
If it is all for the same thing, I see no benefit to doing it up as separate.
I would do it all together.

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________


"Ron A." wrote:

> I need to create a database to track convention attendees, their lodging
> arangements, Hotel info, if attendees need transportation to and from the
> airport and convention and pickup/dropoff times, convention volunteers and
> their assignments.
>
> Would it be logical to do it all in one database or should I make 2. One for
> the convention attendees info and lodging and 1 for the transportation needs
> of the attendees? What would be the best solution?
>
> --
> Aloha,
> Ron A.
From: Douglas J. Steele on 5 Jul 2008 06:01
Are you talking separate MDB (or ACCDB) files, or are you misusing the term
databases, and really mean tables? If the former, I definitely agree with
Bob. If the latter, yes, you'll need multiple tables to model it correctly.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Ron A." <RonA(a)discussions.microsoft.com> wrote in message
news:5A177AAE-2A7E-4527-BE53-1B426E500D89(a)microsoft.com...
>I need to create a database to track convention attendees, their lodging
> arangements, Hotel info, if attendees need transportation to and from the
> airport and convention and pickup/dropoff times, convention volunteers and
> their assignments.
>
> Would it be logical to do it all in one database or should I make 2. One
> for
> the convention attendees info and lodging and 1 for the transportation
> needs
> of the attendees? What would be the best solution?
>
> --
> Aloha,
> Ron A.


From: Ron A. on 6 Jul 2008 00:15
I am talking about seperate ACCDB files. It am not sure if tracking such
different types of data (convention attendee contact info and limousine type
services for the convention) in one database is the way to go. I just want to
start out with a solid foundation to prevent issues when the database will be
put to use.
--
Aloha,
Ron A.


"Douglas J. Steele" wrote:

> Are you talking separate MDB (or ACCDB) files, or are you misusing the term
> databases, and really mean tables? If the former, I definitely agree with
> Bob. If the latter, yes, you'll need multiple tables to model it correctly.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Ron A." <RonA(a)discussions.microsoft.com> wrote in message
> news:5A177AAE-2A7E-4527-BE53-1B426E500D89(a)microsoft.com...
> >I need to create a database to track convention attendees, their lodging
> > arangements, Hotel info, if attendees need transportation to and from the
> > airport and convention and pickup/dropoff times, convention volunteers and
> > their assignments.
> >
> > Would it be logical to do it all in one database or should I make 2. One
> > for
> > the convention attendees info and lodging and 1 for the transportation
> > needs
> > of the attendees? What would be the best solution?
> >
> > --
> > Aloha,
> > Ron A.
>
>
>
From: John W. Vinson on 6 Jul 2008 17:21
On Sat, 5 Jul 2008 21:15:01 -0700, Ron A. <RonA(a)discussions.microsoft.com>
wrote:

>I am talking about seperate ACCDB files. It am not sure if tracking such
>different types of data (convention attendee contact info and limousine type
>services for the convention) in one database is the way to go. I just want to
>start out with a solid foundation to prevent issues when the database will be
>put to use.

One accdb database can contain many, many tables - upwards of 1000 if I recall
aright. Since attendee information is logicallly related to how those
attendees are transported, then I would absolutely recommend using on database
with multiple tables (e.g. tables for attendee information, convention
information, locales, transportation providers, trips, and doubtless others).
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Multiple Users?
Next: Digits on right of Decimal points