Hotel Type Registry

[Jean]

I am attempting to put our paper daily log book into
Access. I have twenty beds that have guests checking out
and checking in and I need to keep track of the whole set
on one sheet. I know how to do this in a spreadsheet, but
want to do it in Access so I can link it to other tables
using this information.

So down the left side I would have the bed designations
these need to stay in place permanently, going to the
right from this would be other columns with information
like name, date in, date out, etc.

Thank you.

 

[Bob Wardlow]

Jean;

Since you are familiar with spreadsheets, you are thinking
about this project from the point of view of a spreadsheet
when you refer to "down the left" and columns. For a
database you need to think more in terms of what data you
need to collect and and how it relates to other data you
need to collect. Databases hold data in tables and then
you can represent that data in many different ways in
columns and rows. For example you may want to have a table
of beds, another of guests, another with information about
their stay. Then the tables are related to each other to
print on paper or view on the screen.

I hope this helped a little.

Bob