is this possible & is this hard to do Please help

[Debbie_P]

I require a database that will track 2 types of security cards 1 is a swipe card and 1 is an alarm card.



I have a list of locations, each location has a name, cost center number and a site number - these must stay together and are a set list of locations

I need to track the number of swipe cards that are 1) issued to a location and charged for (2) issued to a location no charge (3) date issued

I also need to track the alarm cards associated with a location 1) keypad # (2) Pin # (3) Name of Person Issued to; last name, first name (4) Company Name (5) Date Issued (6) Date Returned

I would like to have one form to do all the entry for both cards, which has a drop down list allowing me to choose a location and it will automatically fill in cost ctr number and site number (existing tbl), three forms or report using variations of the same info but has spaces for signatures and pick up date, that can be printed when the cards are picked up

then a couple of reports that will show me
1) the number of swipe cards issued by location, by month, charged, no charge
2) site number, location name, all cards associated with that site, person issued to (I understand how to do the reports/queries)

Okay so this is what I want. Here's what I need to know and take into consideration I am very basic in my knowledge of databases I am learning but the need for the database is greater then I can learn the ins and outs of Database design and I only have Access available to me.

1) can this be done?
2) how difficult is this to do?
3) Can it be secured/protected?

4) Is there anyone here who would be willing to help me, I have no problem creating basic tables, doing queries, reports and basic forms, I'm having trouble tying them all together to get what I want?

I know this is long and I would like to thank everyone in advance who may answer - Debbie

[orange]

Who will use the database? How will data be populated? What about updates?
Where are users located (in terms of network(s) --single LAN, remote users...?

[rpeare]

Are you tracking individual swipes of cards (some sort of card reader) in this database? Or just to whom cards are issued? Are the cards re-used (for instance visitor passes issued and recovered)? Can the individual cards change which doors/keypads they access (for instance like hotels do now with cards that are re-coded every time they are used for a different room)

Assuming you are just tracking cards issued and not individual swipes of cards at a specific door (without some sort of eternal software helping) this is very doable.

As far as security goes, what are your security needs? You can password protect the entire database so nobody can get into it without the password, or, if you want to get fancy, have your own security on the database that allows different users access to different things, or, finally you can put the database in a network location that only certain users have access to.

[Debbie_P]

for now only I will use the data base, I will enter the data my self. it may be shared with another person in my department, but the only people who would have access to the database will be me and my supervisor

Are you tracking individual swipes of cards (some sort of card reader) in this database? Or just to whom cards are issued?

Just the cards issued and to whom and date, not the actual swipes of the card

Are the cards re-used (for instance visitor passes issued and recovered)? Can the individual cards change which doors/keypads they access (for instance like hotels do now with cards that are re-coded every time they are used for a different room)

not often, if a card is re-issued to another person, it will be an alarm card for a specific location, it would only be a matter of replacing the name on the record- the swipe cards are never rekeyed

Assuming you are just tracking cards issued and not individual swipes of cards at a specific door (without some sort of eternal software helping) this is very doable.

As far as security goes, what are your security needs? You can password protect the entire database so nobody can get into it without the password, or, if you want to get fancy, have your own security on the database that allows different users access to different things, or, finally you can put the database in a network location that only certain users have access to.

For now til I'm sure it meets the needs of my supervisor, I will only need to password protect it. it will be stored in a secured shared file that can only be accessed by the two of us

[Debbie_P]

June7 - Thank you for tidying up the thread for me....