Prev: disabling mouse wheel on forms
Next: copy records from a table in one file to a table in another fi
From: Mark on 1 Jul 2008 15:16
Hi Aria,

You have been at this for over two weeks!!! Do you want to stop struggling?
I provide users a resource help with Access applications for a very
reasonable fee. I can design your table structure for you and provide you a
map of the tables. The map will show all the tables you need and for each
table the map will show the the name of the table, all the fields in the
table, the primary key and all foreign keys in the table. The map will also
show all the relationships between the tables and for each relationship will
show the type of relationship. You will then be able to keep the map at your
fingertips when you design the forms and reports for the database and their
associated queries. If you want my help, contact me at rlaird(a)penn.com.

Steve



"Aria" <Aria(a)discussions.microsoft.com> wrote in message
news:67E4D56A-6F2A-41E5-9D9A-9A9B408D179B(a)microsoft.com...
> Hi,
> I'm still struggling to organize my tables and fields but I'm not as
> *totally confused* as my original post; at least I hope I'm not. I'm new
> to
> Access. This is my first database and I fluctuate between feeling hopeful
> I
> can do this one minute and despairing that I can't the next because I've
> thought of yet another complication that I don't know how to handle. I
> have
> scoured the Internet and this disscussion group searching for the answers
> that I need. I found some but I am still at a loss as to what to do about
> others. I was wondering if someone would be kind enough to review my table
> structure and respond to some questions at the end. I am truly grateful.
>
> The information is as follows:
>
> tblEmployees
> Inactive- Yes/No
> Date- Date/Time
> Date Modified- Date/Time
> Employee ID- (PK) Auto number Long Integer
> School Data (Classification, Title, Dept. Name, Subject)- text
> Personal Info (LN FN MI etc.)- text
> Emergency Info - text
>
> tblKeys
> Key ID (PK)- text
> Campus- text
> Wing- text
> RoomType(Classroom, Auditorium, Grand Master, etc.)- text
>
> tblKeysEmployees
> Key ID- composite key(FK to tblKeys)- text
> EmployeeID-composite key (FK to tblEmployees)- Autonumber
>
> tblKeysRequests
> Request ID-Autonumber
> Key ID (FK to tblKeys)- text
> Emp. ID
> Rm. number- text--I think there is a problem here. This info is part of
> tblrooms.
> Rm. phone- text
> Date Requested- Date/time
> Date Recvd.- Date/time
> Date Issued- Date/time
>
> tblRooms
> Key ID (PK)-text
> Room number- text
> Remarks-text
>
> tblSubs
> Sub ID (PK)-Autonumber
> SubLN-text
> SubFN-text
> MI-text
> SubPhone-text
> Key ID (FK to tblKeys)
> Date Issued-Date/Time
> Date Returned-Date/Time
>
> If you're still reading, I have the following questions:
> 1. How many fields are too many in a table? I understand that Access will
> accept up to 255. I read a post that suggested that 20-30 fields may
> indicate
> there may be a normalization problem. I'm wondering about tblEmployees
> where
> there are approx. 25 fields.
>
> 2.tblRooms has a field for Rm.#; the problem is that not all rooms have a
> #.
> Ex.-Storage rms., clinic, auditorium, etc. This is why I added remarks to
> tblRooms because I may have to describe a location rather than a room #.
> Will
> there be a problem with this method?
> One of the desired reports is a reverse directory by room #/room phone #.
> The phone # is currently in tblEmployees. Should it be moved to tblRooms?
> If
> I leave it where it is, will I be able to update any queries and reports?
> I've read that multitable queries aren't updateable. We have had mass
> staff
> room changes right before the school year begins. It just seems it would
> be
> better if the phone # was listed with tblRooms but someone told me that's
> incorrect.
>
> 3. I forgot to include the following fields: Date assigned, Return Date
> and
> Permission to Retain (over the summer) for Emp. Keys. Should this be added
> to
> tblKeys or tblEmployees? I was told not to put *anything* into the
> junction
> table (tblKeysEmployees) besides the composite key already listed.
>
> 4.Keys Requests--Somethimes are request will not have a name associated
> with
> it. For instance, we need to request a key for the vault. I have not
> accounted for this situation and don't know how to handle it. If I need to
> order a sub. key, I can use the name of the permanent staff member
> associated
> with that room. What do I do about the vault? Should I enter "vault" in
> the
> emp. table w/o any additional data?
>
> 5. Maybe I should cross this bridge when I get to it but I eventually will
> get to the point where I will make forms and subforms. There are approx.
> 400
> seperate keys, not including multiple copies of the same key. If I have a
> combo box, is there a way to filter so that I am not looking at all 400
> possiblities at once?
>
> I am so sorry if this is too long and I'm asking too many questions at
> once.
> I understand that you are trying to help as many people as possible. I
> have
> searched and searched for answers and tried to adapt the customers/orders
> format as much as possible to my situation but...I need help.
>
> --
> Aria W.


From: Aria on 1 Jul 2008 15:52
Doesn't me I'm not making progress. Sorry, I didn't realize their was a time
limit on learning.
--
Aria W.


"Mark" wrote:

> Hi Aria,
>
> You have been at this for over two weeks!!! Do you want to stop struggling?
> I provide users a resource help with Access applications for a very
> reasonable fee. I can design your table structure for you and provide you a
> map of the tables. The map will show all the tables you need and for each
> table the map will show the the name of the table, all the fields in the
> table, the primary key and all foreign keys in the table. The map will also
> show all the relationships between the tables and for each relationship will
> show the type of relationship. You will then be able to keep the map at your
> fingertips when you design the forms and reports for the database and their
> associated queries. If you want my help, contact me at rlaird(a)penn.com.
>
> Steve
>
>
>
> "Aria" <Aria(a)discussions.microsoft.com> wrote in message
> news:67E4D56A-6F2A-41E5-9D9A-9A9B408D179B(a)microsoft.com...
> > Hi,
> > I'm still struggling to organize my tables and fields but I'm not as
> > *totally confused* as my original post; at least I hope I'm not. I'm new
> > to
> > Access. This is my first database and I fluctuate between feeling hopeful
> > I
> > can do this one minute and despairing that I can't the next because I've
> > thought of yet another complication that I don't know how to handle. I
> > have
> > scoured the Internet and this disscussion group searching for the answers
> > that I need. I found some but I am still at a loss as to what to do about
> > others. I was wondering if someone would be kind enough to review my table
> > structure and respond to some questions at the end. I am truly grateful.
> >
> > The information is as follows:
> >
> > tblEmployees
> > Inactive- Yes/No
> > Date- Date/Time
> > Date Modified- Date/Time
> > Employee ID- (PK) Auto number Long Integer
> > School Data (Classification, Title, Dept. Name, Subject)- text
> > Personal Info (LN FN MI etc.)- text
> > Emergency Info - text
> >
> > tblKeys
> > Key ID (PK)- text
> > Campus- text
> > Wing- text
> > RoomType(Classroom, Auditorium, Grand Master, etc.)- text
> >
> > tblKeysEmployees
> > Key ID- composite key(FK to tblKeys)- text
> > EmployeeID-composite key (FK to tblEmployees)- Autonumber
> >
> > tblKeysRequests
> > Request ID-Autonumber
> > Key ID (FK to tblKeys)- text
> > Emp. ID
> > Rm. number- text--I think there is a problem here. This info is part of
> > tblrooms.
> > Rm. phone- text
> > Date Requested- Date/time
> > Date Recvd.- Date/time
> > Date Issued- Date/time
> >
> > tblRooms
> > Key ID (PK)-text
> > Room number- text
> > Remarks-text
> >
> > tblSubs
> > Sub ID (PK)-Autonumber
> > SubLN-text
> > SubFN-text
> > MI-text
> > SubPhone-text
> > Key ID (FK to tblKeys)
> > Date Issued-Date/Time
> > Date Returned-Date/Time
> >
> > If you're still reading, I have the following questions:
> > 1. How many fields are too many in a table? I understand that Access will
> > accept up to 255. I read a post that suggested that 20-30 fields may
> > indicate
> > there may be a normalization problem. I'm wondering about tblEmployees
> > where
> > there are approx. 25 fields.
> >
> > 2.tblRooms has a field for Rm.#; the problem is that not all rooms have a
> > #.
> > Ex.-Storage rms., clinic, auditorium, etc. This is why I added remarks to
> > tblRooms because I may have to describe a location rather than a room #.
> > Will
> > there be a problem with this method?
> > One of the desired reports is a reverse directory by room #/room phone #.
> > The phone # is currently in tblEmployees. Should it be moved to tblRooms?
> > If
> > I leave it where it is, will I be able to update any queries and reports?
> > I've read that multitable queries aren't updateable. We have had mass
> > staff
> > room changes right before the school year begins. It just seems it would
> > be
> > better if the phone # was listed with tblRooms but someone told me that's
> > incorrect.
> >
> > 3. I forgot to include the following fields: Date assigned, Return Date
> > and
> > Permission to Retain (over the summer) for Emp. Keys. Should this be added
> > to
> > tblKeys or tblEmployees? I was told not to put *anything* into the
> > junction
> > table (tblKeysEmployees) besides the composite key already listed.
> >
> > 4.Keys Requests--Somethimes are request will not have a name associated
> > with
> > it. For instance, we need to request a key for the vault. I have not
> > accounted for this situation and don't know how to handle it. If I need to
> > order a sub. key, I can use the name of the permanent staff member
> > associated
> > with that room. What do I do about the vault? Should I enter "vault" in
> > the
> > emp. table w/o any additional data?
> >
> > 5. Maybe I should cross this bridge when I get to it but I eventually will
> > get to the point where I will make forms and subforms. There are approx.
> > 400
> > seperate keys, not including multiple copies of the same key. If I have a
> > combo box, is there a way to filter so that I am not looking at all 400
> > possiblities at once?
> >
> > I am so sorry if this is too long and I'm asking too many questions at
> > once.
> > I understand that you are trying to help as many people as possible. I
> > have
> > searched and searched for answers and tried to adapt the customers/orders
> > format as much as possible to my situation but...I need help.
> >
> > --
> > Aria W.
>
>
>
From: John... Visio MVP on 1 Jul 2008 17:44
"Aria" <Aria(a)discussions.microsoft.com> wrote in message
news:F66B24A9-079F-4C29-9802-A8A6DAB1B6A3(a)microsoft.com...
> Doesn't me I'm not making progress. Sorry, I didn't realize their was a
> time
> limit on learning.
> --
> Aria W.


If you are enjoying your trip of discovery, take your time, there is no
rush. If you run into any problems there are many qualified people here who
are more than willing to help. Steve of course, is not one of them. His only
interest is helping himself to your money.

John... Visio MVP

From: StopThisAdvertising on 2 Jul 2008 03:23

"Mark" <notmy(a)email.com> schreef in bericht news:xeGdnero14fmH_fVnZ2dnUVZ_vzinZ2d(a)earthlink.com...
> Hi Aria,

<snipped the salvation options>

> Steve

Aha, now you think the OP is waiting for your 'rescue' ??
Please go see your mental coach again...


*********************************
If anyone wants to help us getting rid of Steve ??
abuse(a)giganews.com (appropriate action will follow when there are enough complaints)
*********************************

(Earthlink and SuperNews kicked him out ?? ==> updated 'abuse-reporting')
http://home.tiscali.nl/arracom/whoissteve.html
Until now 5850+ pageloads, 3675+ first-time visitors

Arno R
From: BruceM on 2 Jul 2008 07:11
Good one. If Steve or whoever he is had any real competence he wouldn't
need to troll here for business, and would have something other than Coming
Soon (several years now) on the Access Tips (or something) section of his
web site.

"Aria" <Aria(a)discussions.microsoft.com> wrote in message
news:F66B24A9-079F-4C29-9802-A8A6DAB1B6A3(a)microsoft.com...
> Doesn't me I'm not making progress. Sorry, I didn't realize their was a
> time
> limit on learning.
> --
> Aria W.
>
>
> "Mark" wrote:
>
>> Hi Aria,
>>
>> You have been at this for over two weeks!!! Do you want to stop
>> struggling?
>> I provide users a resource help with Access applications for a very
>> reasonable fee. I can design your table structure for you and provide you
>> a
>> map of the tables. The map will show all the tables you need and for each
>> table the map will show the the name of the table, all the fields in the
>> table, the primary key and all foreign keys in the table. The map will
>> also
>> show all the relationships between the tables and for each relationship
>> will
>> show the type of relationship. You will then be able to keep the map at
>> your
>> fingertips when you design the forms and reports for the database and
>> their
>> associated queries. If you want my help, contact me at rlaird(a)penn.com.
>>
>> Steve
>>
>>
>>
>> "Aria" <Aria(a)discussions.microsoft.com> wrote in message
>> news:67E4D56A-6F2A-41E5-9D9A-9A9B408D179B(a)microsoft.com...
>> > Hi,
>> > I'm still struggling to organize my tables and fields but I'm not as
>> > *totally confused* as my original post; at least I hope I'm not. I'm
>> > new
>> > to
>> > Access. This is my first database and I fluctuate between feeling
>> > hopeful
>> > I
>> > can do this one minute and despairing that I can't the next because
>> > I've
>> > thought of yet another complication that I don't know how to handle. I
>> > have
>> > scoured the Internet and this disscussion group searching for the
>> > answers
>> > that I need. I found some but I am still at a loss as to what to do
>> > about
>> > others. I was wondering if someone would be kind enough to review my
>> > table
>> > structure and respond to some questions at the end. I am truly
>> > grateful.
>> >
>> > The information is as follows:
>> >
>> > tblEmployees
>> > Inactive- Yes/No
>> > Date- Date/Time
>> > Date Modified- Date/Time
>> > Employee ID- (PK) Auto number Long Integer
>> > School Data (Classification, Title, Dept. Name, Subject)- text
>> > Personal Info (LN FN MI etc.)- text
>> > Emergency Info - text
>> >
>> > tblKeys
>> > Key ID (PK)- text
>> > Campus- text
>> > Wing- text
>> > RoomType(Classroom, Auditorium, Grand Master, etc.)- text
>> >
>> > tblKeysEmployees
>> > Key ID- composite key(FK to tblKeys)- text
>> > EmployeeID-composite key (FK to tblEmployees)- Autonumber
>> >
>> > tblKeysRequests
>> > Request ID-Autonumber
>> > Key ID (FK to tblKeys)- text
>> > Emp. ID
>> > Rm. number- text--I think there is a problem here. This info is part of
>> > tblrooms.
>> > Rm. phone- text
>> > Date Requested- Date/time
>> > Date Recvd.- Date/time
>> > Date Issued- Date/time
>> >
>> > tblRooms
>> > Key ID (PK)-text
>> > Room number- text
>> > Remarks-text
>> >
>> > tblSubs
>> > Sub ID (PK)-Autonumber
>> > SubLN-text
>> > SubFN-text
>> > MI-text
>> > SubPhone-text
>> > Key ID (FK to tblKeys)
>> > Date Issued-Date/Time
>> > Date Returned-Date/Time
>> >
>> > If you're still reading, I have the following questions:
>> > 1. How many fields are too many in a table? I understand that Access
>> > will
>> > accept up to 255. I read a post that suggested that 20-30 fields may
>> > indicate
>> > there may be a normalization problem. I'm wondering about tblEmployees
>> > where
>> > there are approx. 25 fields.
>> >
>> > 2.tblRooms has a field for Rm.#; the problem is that not all rooms have
>> > a
>> > #.
>> > Ex.-Storage rms., clinic, auditorium, etc. This is why I added remarks
>> > to
>> > tblRooms because I may have to describe a location rather than a room
>> > #.
>> > Will
>> > there be a problem with this method?
>> > One of the desired reports is a reverse directory by room #/room phone
>> > #.
>> > The phone # is currently in tblEmployees. Should it be moved to
>> > tblRooms?
>> > If
>> > I leave it where it is, will I be able to update any queries and
>> > reports?
>> > I've read that multitable queries aren't updateable. We have had mass
>> > staff
>> > room changes right before the school year begins. It just seems it
>> > would
>> > be
>> > better if the phone # was listed with tblRooms but someone told me
>> > that's
>> > incorrect.
>> >
>> > 3. I forgot to include the following fields: Date assigned, Return Date
>> > and
>> > Permission to Retain (over the summer) for Emp. Keys. Should this be
>> > added
>> > to
>> > tblKeys or tblEmployees? I was told not to put *anything* into the
>> > junction
>> > table (tblKeysEmployees) besides the composite key already listed.
>> >
>> > 4.Keys Requests--Somethimes are request will not have a name associated
>> > with
>> > it. For instance, we need to request a key for the vault. I have not
>> > accounted for this situation and don't know how to handle it. If I need
>> > to
>> > order a sub. key, I can use the name of the permanent staff member
>> > associated
>> > with that room. What do I do about the vault? Should I enter "vault" in
>> > the
>> > emp. table w/o any additional data?
>> >
>> > 5. Maybe I should cross this bridge when I get to it but I eventually
>> > will
>> > get to the point where I will make forms and subforms. There are
>> > approx.
>> > 400
>> > seperate keys, not including multiple copies of the same key. If I have
>> > a
>> > combo box, is there a way to filter so that I am not looking at all 400
>> > possiblities at once?
>> >
>> > I am so sorry if this is too long and I'm asking too many questions at
>> > once.
>> > I understand that you are trying to help as many people as possible. I
>> > have
>> > searched and searched for answers and tried to adapt the
>> > customers/orders
>> > format as much as possible to my situation but...I need help.
>> >
>> > --
>> > Aria W.
>>
>>
>>

 |  Next  |  Last
Pages: 1 2
Prev: disabling mouse wheel on forms
Next: copy records from a table in one file to a table in another fi