I am in the process of creating a database the will track the attendance for each student, and I would like to store all dates that each student has attended...

Hi All, I am wondering if someone here could help me and hopefully help me get somewhat un-confused. I am in a class in college for database design. We...

I am greener than green on Access but I am learning as I go along. I'm trying to set up a database to keep track of our company's vechicles and when the...

Hello All, I am in real need of suggestions for best approach. The database I am re-designing tracks donations which can be 1x donations related to...

Hello! I need to enhance an Access 2000 db by Feb 2008. I have a bit of Access development experience but have not used it since 2001. I am looking for help...

Hello - I am trying to create a unique index for values in 2 fields. However, one of the fields does not alway contain a value. Is it possible to create...

Hello All, I have a membership database. I have a table for members, and a table for their payments linked one to many. This works great. However, Now I...

I know this question has to do with Data Normalization but the concept of exactly how to do it still eludes me. I need to create a database that will be...

Hi all I have the following fields in a single table with no relationships to other tables: FeatureType LowWeightingValue...

Hi John, You have so kindly responded and been very patient in the past, and I am hoping that I can ask your advice again. I am modifying AYS and things are...

I want to design a databse that ahndle general ledger like msaccess ledger template but in that template there is no check handling and bank reconcile...

In my databse I was try to add a field, and it said that I have too many fields. But when I went and deleted one that I never use, it still says I have too...

I want to create a self relationship to track parnets of Goats. each Mother Goat has a tag and tag is the key field. An example of the tag could be...

I am new to Access and have the daunting task of creating a DBase in Access 2003. I have created 2 tables one for File Information (file name, client,...

I've reached the 2 gig mark because I have a couple large tables and lots of pictures. Never thought it would happen but here I am...so I need a strategy to...

I want to create a new report based on a query...using the wizard and selecting the query for the report, I noted a in the list of available fields "expr...

Am wondering if I should put the description of each table in its properties (right-clicking, selecting Properties and typing the Description, OR should I...

I have looked through the knowledge base and tried to do a cascade lookup but I'm having difficulty. For simplicity I have genericized the names of my...

Referring to my previous post "Designing a DB for Tract Home Models w/ Many Options" I have decided to use Access to accomplish this task. I work for a...

We have residents that have multiple doctors and Doctors that have multiple residents as patients. So I am guessing that a third table needs to be...