Hi, I am new to access. I am looking for a way or a template if any to track activities of a motorpool (30 vehicles) on fuel comsumption,...

Hi, Recently, I start a small database for my shop selling electrical appliances... The database run fairly good, but still a have a question. Some items...

Hi, I have 5 tables, 4 of which use for lookup. Those 4 table are tblProvinces, tblDistricts, tblCommunes, tblVillages. tblProvinces Pv_ProvinceID ...

Hi, I have a database which work fairly good except that it does not containt any security control. My supervisor wants each staff member, who is below the...

Have another question. I've split most of my tables so that 90% of them contain only 2-4 fields and then related them (tblCompetencies, tblWardCompetencies,...

Need help with the relationships now. If you can help me set up the first set, I'm sure I can set the rest up. Have the following: tblEmployees EmployeeID...

I have three tables (tblData, tblMilitaryData, and tblCompetency). All have the SSN as the primary key. I cannot get them to have a one-to-one relationship....

I have a main table that gets some of it's data from other tables (i.e. Rank, Work Section, States, etc) using combo or list boxes. How do I lock the...

Hi, I have a small homemade inventory database that work fairly good in keeping track of my customers purchase'and payment. Recently I face a situation like...

Hi, I have a small db for my project. I have a project table (tblProject with ProjectID, ProjectName, Location...). I want to incorporation each project...

Hi, Access 2003, I want to implement security by allow user to login. I have a table with user name, password but I want to encrypt the password field. How...

Hi, My office has a staff database consists of 3 tables. tblEmployee, tblEducationAllowance, tblMedicalAllowance. tblEmployee has EmpID, Empname,...

Can I use Access to store workplan that have the following structure? If yes how? N° Main Activities Year 2009 Lead (Support) Jul Aug Sep ...

Hi, I have a small database for storing workplan of aroung 40 partners.. The speadsheet look like the following No Main Activities June W1 June...

Hi, Is that true that implementing information lookup in MS access is a bad ideas? SF

Hi, I'm trying to add key in to my tables. Is it possible to add secondary key? Thanks, Sarah

Hi, I have a table name hardware, with field tag number etc. I want the tag number starting with 2001, and the new record will be 2002....., which means it...

I am in the process of desiging a database that contains employee skills I have resolved most of the problems, except for one that allows for one employee to...

I started building a db for laboratory Blood testing. Main Purpose is to make labels for all tubes drawn for the patient and also to track when certain tests...

Currently i import 2 excel files into my database, at different times. I am looking to update one of the tables depending on the information on the other....