Adding a second employee to an event I have built an Operations Log database. In the database I have built built the following tables. tblLab(Lab where testing will occur) tblCustomer(customer who will test) tblEquipment(each piece of equipment we operate) tblEvent(particulars of event, i.e. startdate, starttime, enddate, endtime, purpose, employ... 8 Mar 2010 11:57
Keeping data private per User in a multi user database Hello. I have an Accounting Access DB that I intend at some point to split into front-end (tables, forms, reports) and back-end (data), then I hope to deploy on the web. I will eventually have around 30 distributed users (only about 5 concurrent) – each inputs the same type of financial data but does business ... 10 Mar 2010 13:06
help transition to access from excel I am transitioning from excel to access for the reason of the spreadsheet is only getting igger and harder to use. I am an Insurance agent and I am trying to set up a new database using the templates as munc as I can. I want to have the ability to access the customers information (contact management) and thei... 9 Mar 2010 13:31
Building a shareholder database using access 2007 nerak;21602 Wrote: I am trying to build a database for shareholders and the companies they are shareholders to. It has been quite a while since I build my last database and 2007 is very different to what I last used. I undersand I need enough tables so I don't repeat entries and also that I need to rela... 8 Mar 2010 08:36
Thanks to Allen Browne... and all MVPs..... Thanks you very much... for reply and thoughts.. convayed.. will look site and read again million thanks.. Dr. Khalak ... 8 Mar 2010 01:03
Food Pantry Database Thanks for the help. I will get back to you with some more specific questions. It took me a year to find the place where I asked this question! Roger Carlson wrote: To follow up on Duane's suggestion of reading up on database design, I havea 18-Dec-09 To follow up on Duane's suggestion of reading up on ... 7 Mar 2010 21:48
Relational Database Layout What I would like to do is create a database to track sales, customer info and customer demographics using 3 separate tables: Customer Info(name, address, phone, etc.), Sale info(what was purchased, date, size, etc), and Demographics(Gender, age, income, etc). I have the three tables populated with the need... 9 Mar 2010 12:22
Superclass have only a autonumber.. is it possible? Work with IT for many years, and have lately begun looking into DB and MS Access. So Im quite a rookie in this area. :) Ok, Got a superclass named table1. That class has only one attribute, an ID which is an auto number. Then I have to subclasses called table2 and table3. They have the foreign key to ID, ... 9 Mar 2010 19:16
Creating new row in other table Dear All, Please teach me, how to make a new row/list in other table by entering number in other table. Sample, In the table A and in the field "Details", I put the number 2 and it automatically creates two rows in table B. Can this be done in MS Access? Thank you for your help. Regards, Maulwy ... 8 Mar 2010 10:50
Can you help me make a simple database / template I need help making a database to track all 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 ... 7 Mar 2010 10:43 |