Multiple entries

[danelliott]

Hi all, this is my first post, so id like to say Hi to you all first.

Ok, little complicated to explain but i will do my best to make it as easy to understand as possible. (Bearing in mind im not fluent with Access at all lol)

I wish to create a database for my new business, the database needs to have the following fields;

ID number (auto number) (indexed duplicates not OK)
Name (text) (required) (indexed duplicates OK)
address (text) (required)
contact number (text) (required)


NI number (text) (required)
start date (date/time) (required) (indexed duplicates OK)
active (yes/no) (required) (indexed duplicates OK)
Leave date (date/time) (indexed duplicates OK)



Now....... i want to be able, when someone starts work with us to add all the information needed above to a database for obvious reasons, however i also need to be able to add to each employees file extra information at a later date, im in a sales based business and i want to be able to (at the end of each day) add to each employees information the information about their daily sales, ie, name of customer, customers address and contact number, customers email address, date of sale etc, this is so that at any time i need to check the information i would just look up the agents ID or name and then it will provide me with all the information relating to past sales and also with the option to add todays sales.

I dont know how difficault this will be but i am desperate to get this done so i can start being a little more efficient with my administration.

Many thanks in advance

Danelliott

[RuralGuy]

I would start by looking at all of the templates that ship with Access as well as those on the MS Office site. I suspect you can find something that is close to what you want that you can then tweak to your liking.

[Rixxe]

From looking at what you described, you could create 2 tables:
One with the information you posted:

StaffID
Name (text) (required) (indexed duplicates OK)
address (text) (required)
contact number (text) (required)
NI number (text) (required)
start date (date/time) (required) (indexed duplicates OK)
active (yes/no) (required) (indexed duplicates OK)
Leave date (date/time) (indexed duplicates OK)

Another with the other information you posted:

Staff ID
name of customer
customers address
contact number
customers email address
date of sale

I've added a StaffID, so that you can link your staff information, to the customer information (So you know which customer links to which staff member) OR you could just add in a 'staff name' field to do the same thing.

If its just you updating the tables, then you can leave it at that, or you can get fancy with forms and macros and the like once your happy with what you have. (Or have a set idea on what you want)
You could create a form to add data into, which will go straight into the tables that you want.
This would mean that other people could also use the database.

Hope this helps a bit, however you really had the answer already.

Good luck.

Rixxe

[Rixxe]

And RG said it in one sentence... /sigh!