Micrsoft Access Guru's: Can I do this with Access (look inside)?

AmdInside

Golden Member
Jan 22, 2002
1,355
0
76
I am trying to come up with a way to to develop a seating arrangement for my wedding reception in a few months. I thought with Access, I could come up with not just a seating arrangement (where I can arrange the names in an order and Access will rearrange the layout appropriately) but also use it to keep track of guests address, if we sent them a thank you card and any other information we may be able to come up with. I took an Access class for a few weeks a few years back but now I forgot it. I still have my book which I could look at and still have plenty of time to learn Access. Would it be to much trouble or would it not work well, what I am trying to do in Access? Thanks.
 

bunker

Lifer
Apr 23, 2001
10,572
0
71
Way too much trouble. Access is not really the ideal application for a seating chart. To store the addresses and what you got, whether or not you sent a thank you, it would be good for.
 

calpha

Golden Member
Mar 7, 2001
1,287
0
0
Originally posted by: bunker
Way too much trouble. Access is not really the ideal application for a seating chart. To store the addresses and what you got, whether or not you sent a thank you, it would be good for.

If you just wanted to use a seating chart and see the names ordered by a RowNum/SeatNum, it's not too hard.......

like this:
Name: Seat:
John Smit Row 1, Seat 1
Have None Row 1, Seat 2
Jackey Jones Row 2, Seat 3
....etc

If you wanted a visual layout where names were placed on top of seats graphically, then HELL NO.

But, setting up a db to manage seat numbers, row numbers, address, other information, sent thank you cards is not a lot of work.
BTW....if you do do this. Make sure you set a column for row, and a column for seat for each person.

Then you'd do a select like this:

Select * from Names order by Row, Seat


 

bunker

Lifer
Apr 23, 2001
10,572
0
71
From the sound of his post he wants a graphical representation, hence my response. calpha is correct though, if you just want to keep track of it, then yes, access will work fine.