I need to design a database that will track the supplies ordered from a supplier as well as track these supplies when they a shipped to investigator sites. I...

I am using AYS as a base in creating a survey database. I have the questions in one table with a questionID PK. I have the answers in another table with the...

Hi, I am creating a field the states the relationship of a survey respondent in relation to the head of the household. These are coded - 1 = spouse, 2=son,...

I am creating a database and trying to stick to standard naming conventions, using prefixes such as tbl frm, etc. I have come across two definitions of...

I have received great advice regarding my database. Am reading Database Design for Mere Mortals and have also downloaded "At Your Survey" database, both of...

I need to design a database that will hold contact information about our investigator sites, contacts we meet at conferences, contact information about our...

I had asked about this questions about a month ago but I am still stuck. I need to create a table for Sites, a table for Personnel at the sites, and an...

I need to create a database that holds information about Sites and the Personnel and these sites. Usually the site info (address etc) is the same for all...

Hi, I have a student database and wish to generate a report based on a query that contains: Student Last Name (from Family Info table) Student First Name...

I just posted regarding sort order of fields and realized that my problem is that when I specify a text field length of 12 for my question number (it may be...

This is my first attempt at using access so please be gentle. I am uncertain at this time which fields I will actually need for my database. If I select...

how do convert the first letter of a name to capitals in access

I would like to compare 2 Files in Access Database 2000. One File is questions and aswers correct and the other file is a selection of choose the correct...

I want to manage data in one table that has several fields with the same information. Example: Fields with 1 didgit differences "Qty" and "Qty2" I've learned...

Does anyone know of anything out there or within Access that will allow you to see how all the tables and queries are associated. In other words...I would...

I have designed a table and in one field of the table I have used 'look up wizard' to make a relationship with another table in the database. When I open the...

My office installed MS Access 2007 recently. I have designed a contact database and have a simple table. I want to add an attachment. I went through MS...

I need some ideas for good robust design for additions to our MS Access database. We are marketing/client servicing company but I need to focus on...

At the moment I have simple Access DB with 3 tables Companies, Contacts and Activities. In the Company table we have stored the address...

1.01 million is perfect I need the land , I will bleed purple in july and christ help me you hang me out on this one I will do...