Hi. I have a school project where I need to design a database with four tables. Will there be 4 different primary keys and 4 different foreign keys? Does this...

I am designing a system for entering tickets. I want it to be auto number. Problem is the company is at ticket # 3516, and I wish to start the autonumber...

In a training records database, each training session has one or more instructors. Most of the training sessions are one-time events, perhaps to learn about...

How do you guys go about with your table design... how do you make sure that it's right before proceding with the implementation/coding? Any pointers for a...

I have developed a (what used to be) simple inventory control database to replace the old Cardex system the buyers in my company use to track product...

I have a design application question. Does anyone have an idea on how to set up an access application to keep track of gallons going in and out of a large...

Hi, I have a database full of names (for geneology) where I have Last, First, Middle and Title. My table has an auto-number for primary key. From reading...

Hi I would like some advice how to develop a resource forecasting database to view resourcing graphs. At the moment i have to copy the 'Task Usage' Hours...

I have three tables: BusinessContacts, IndividualContacts, and Donations. BusinessContacts has a one to many relationship with Donations (Donations being the...

Is there a maximum number of rows advised in an Access 2003 table? Client says table with 160,000 rows is not allowed, and an MS support engineer agreed with...

Hi I import data tables, that come in through another source (mainframes & Spreadsheets), every week. However the fields names of the tables are all coded...

I have set up an inventory of my video collection and I am unable to get the responce from the data that I am looking for. The tables have the...

I have a question on normalizing tables that has come up several times. As an example: If I have ten pieces of equipment with ten guages and I want to record...

Hi! I'm doing an electronic file indexing program..... tblUSERS connected to tblCABINETS connected to tblDRAWERS connected to tblFILEFOLDERS connected...

Hi Guys...My first question is should I create this in Access 2003 since we will be getting that installed in a few months? We will still have Access 2000 on...

The backpacker hostel in Panama again. What is the best way to organize my unique client numbers when more than one guest stays in the same room? For...

Hi all, Is there a definitive view on whether to allow null's in foreign keys, or whether it is better to have a bogus entry in the parent table to...

I am using Access 2003. Is there a way to add a calculated field to a Db Table. I know I can do create a calculated field in a form or a report - but can...

I am writing some documentation for an application and needed to know if there is a correct term for a table in which the data does not change as a normal...

I am using Access as a front-end to an SQL database. I need to be able to prevent having duplicate keys without using a composite primary key. I have a...