Related Topics

Making database to keep track of keys

Need a database
I am new to Access and need help finding, making a database!

It's for a school and need to keep track of volunteers.


Database Primary and Foreign Keys
Primary and foreign keys are the most basic components on which relational database theory is based. Primary keys enforce entity integrity by uniquely identifying entity instances. Foreign keys enforce referential integrity by completing an association between two entities.


Track users use of Access database
how can I relaise when somebody is using Access database.

I have to track when some change has been made on Access database, or when is it used.

my main idea is to track changes of MDB file - ie. updated date or something like that.

please, if you can help me how to accomplish this request.


hiding forms
I am making a database in which my users will add data to a form then they
will click a command button that runs a macro to view the information on a
report. How can I get the form to hide while they are viewing the report. I
did this in Access 97 with the send keys function and using "%W"h, then
opening the report. But in Access 2000 this does not work. Any ideas? I have
sort of fixed it by having two separate send keys functions; one to press %,
and the other to press wh. But sometimes this works and sometimes it doesn't.


Allocating multiple items to one master key
I am relatively new to using Access and I have been asked to put together a database for allocating keys at our school. Every member of staff has certain keys allocated to them based on their role.

There are also some keys which open multiple rooms. So for example a teacher will need a classroom key and a key for the storeroom and a key for the staffroom. The classroom key and the storeroom key are the same but the staffroom key is different. (This is a simple example).

I have created a table DOOR KEYS with the following fields:


re-use database?
so I have created my very first database. And what I need to know is. can I re-use the database?
What I mean is. I have created a students database that contains information on 1 years' (3 semesters) worth of students.
I will need to do this for each year. I have tried deleting all the information and saving just the database, but then when I went in to enter info for the next years students, the primary keys start again from where they left off instead of from 1.
Is there a way to wip out all the data and re-use the database?
I'm not sure if I'm making any sense. please let me know if you can


Get access to update webform
I am brand new to the forum so 'Hello'. I am a IT Tech for a school and I am making a simple database to track student laptop repairs. To submit a repair request with the laptop manufacture (acer) I have to complete a webform from their website. All the info is duplicated in the database I am making for our own personal tracking needs. I was hoping it would be possible for me to enter the data into the DB I am writing and 'Hit' a button and have the info populate this external webform and then all I have to do is then submit.


Make simple database / template
I need help making a database to track my financial account info. I want to keep track of all my accounts payable and receivable.

I have already set up 2 tables.
1) The contact information for my accounts
2)The specific account information (Acct #, monthly payment amt, due dates,
current/delinquent credit reporting status, account type)

I still need a table for all the receipts I have, and a table for my job incomes.

Such as all the accounts that I have at one place or all the accounts in a negative status. etc.

Is there anyone willing to create a template?

I have tried doing it on my own, but I cannot get past the tables.

I hit really bad financial times, and am starting to clear up my debts. The database will be for my personal reference.


Assigning Auto Keys for Aligning Controls
How to create hot keys to align controls in design view in a Microsoft Access database.


Iif inside an update satement.
The following update query is giving error-- "The operation must use an updatable query" while running.

UPDATE MEASUREMENT SET STATUS = ( IIF(
(SELECT SUM(QNTY) FROM Measurement_Individual_Delivery WHERE Measurement_Key_FK=[@KEYS] ) < (SELECT QUANTITY FROM MEASUREMENT WHERE KEYS=[@KEYS]) , 'Pending','Delivered'))
WHERE KEYS=[@KEYS


Useful shortcut keys in Access
Do you find that using the keyboard is sometimes quicker than using your mouse? Shortcut keys can help you bypass menus and carry out commands directly. You can use shortcut keys in many ways with Access, from accessing commands and toolbar buttons to inserting today's date. Shortcut keys are sometimes listed next to the command name on Access menus.


Creating a Web Page from a database
Basically I have created a database that allows me to track all my second hand goods that I would like to buy and sell on the internet. However I am having difficulty making the webpage. Ideally I would like to create a website like the Publisher Templates where you can have a product list and then a link to a second page with a larger photo and a small decription. I want it automated so that if I get the database perfect with photos and decriptions I can simply upload it onto the website.


Database to Track Training?
I was tasked with an urgent request to create a database to track training. I know this is kind of broad,

Any of the ones that I can find on the web are protected where I can't get any good ideas as how they are set up.


Keyboard Shortcuts
You can use shortcut keys for quick access to frequently used commands or operations. The topics below list the shortcut keys available in Microsoft Access. You can also use access keys to move the focus to a menu, command, or control without using the mouse.


Table Relationships
I'm trying to create a database that will track errors for each operator that has the following tables:

Operators
Processes

Primary keys in each table are:
OperatorID
ProcessID
ErrorID

I know that I have to link these tables together, but am unsure of how to do this as far as what fields should be added to each table that need to be linked together. (I know how to use theRelationships diagram to link them, but do not know which fields should link to which fields).


Tables for Different Types of Inventory
I am currently creating a database for a diamond/jewelry shop. There are very different characteristics for diamonds compared to finished jewelry and mounts. It seems to me that it makes the most sense to keep them in separate tables (as you can see from the diagram.)

The relationship between ID/Primary Keys and Secondary Keys seems awkward the way I have it. This database will be used for tracking inventory in the shop and invoicing customers.


Two primary keys
A book I am reading says, "Composite keys are typically used if a table has no single field (with a set of unique values) that can serve as the primary key." I have used Access for a while, but have never quite grasped what kind of situation needs two primary keys. Can anyone shed light on this?


How do I track users after they logged in to the database?
My database is set up in a way that it will ask username and password to log in to the database.
The database have some forms where the users have to fill and which later will be exported into excel file.

My question is: what should I do to have database track users so that when I export the file, It can tell me as to which user filled what form in like a separate column maybe.
Example. Form 1 was filled by abc and form 2 was filled by defgh


Database to track Workers Comp Premiums
I currently have an Excel Spreadsheet that I use to track Workers Comp Premiums but I need to create one in Access in order to get the reports that I need for the Workers Comp Companies that we work with. We have about 25 Companies that we track this for with an average Employee count of 10. We need to be able to input hours and flat pay for each employee. Workers Comp Premiums are calculated by Comp Rate x Included Wages. It will be similar to a payroll database but we don't need to incorporate any tax tables. If there is anyone out there who would be willing to help me out with this


Training Database Assistance
I have been tasked with setting up a database to track employee training. The easy stuff is to track completed trainings by employee. Additionally I need to be able to track the status of required training by both department or job class. My initial table structure is:
[code]
Where I am stuck is how to best query for training that has not been completed but is required for an employee based on either department or job class.