Is it possible to post my tables and relationships for advice and to do so privately? I posted a couple questions on this DB and based on responses, I'm...

I am having a problem with my tables, when I select them from the side and they open up, there is no tab on the table in the left hand corner to click on in...

is there a way to make the field larger Mary Lou

We have a simple table set up for customers. The table only consists of 4 fields, CustID, Last Name, First Name, Middle Initial. All fields were originally...

Hello, First, I'm not sure if this a "tables" design question or "forms" question so I'm posting in both groups. I receive a daily force / headcount report...

I'm building a process-flow type program, keeping track of 20-30 steps and sign-off dates and emp Ids. I'm wavering between a flat table design, with all...

Hello, I would like to ask advice on database / query design. I intend to create a salary calculator in Access 2007. In my plan there are different job...

Hi, I'm wanting to set this up but am unsure of the best way to go about it. All I have is basically a 'service' which will belong to particular areas...

All To easier explain my problem I'm making up the following example: Suppose you have a Table of Referees (PKID, LName, FName) - Each game you play requires...

Hi, I'm not sure if this is the correct place to post for the problem I'm having. I already have a db design and it has been working well for quite some time,...

Hello all, I've run into this issue before, and am just curious as to your opinion as to how best to handle. I have these tables: tblProjects ProjectID...

I have a table for equipment. If the equipment has a service tag we use it as the primary key if the equiment does not have a service tag we want to start at...

I am using Access 2003 I have a table of nearly 10,000 records which I have transferred from Excel to Access. The table consists of contact names, company...

Hi, I'm trying to build a datamart using Access as our database. Ideally I'd do it in SQL server, but I belong to a business group and SQL server would...

Hi, I am using the table analyzer to break up a table that has grown too big. I am manually breaking up the tables (versus having the wizard do it). Now...

I have one table for a persons details and all the fields are single entry. ie they have only one date of birth. However I want to create another table that...

Hello, I'm trying to combine two tables into one form, without using subforms. One table has 255 fields and the second table has about half of that. Is...

I am looking for advice on table and form design as they relate to database performance. I have a Main table with 48 fields. To organize my data better and...

I want to build a relationship between a query and a table. MS Access allows me to create a text(4) in the query and an integer field in the table. Does it...

1. I am attempting to create a db with 62 checklist tables and one table with the checklist titles that will be used in a form with a combo box and text box. ...