....what I am missing? If I have training courses and employees, I know that each employee attends many training courses and each course is attended by many...

Seriously... if I have, for example, employee numbers in an Employees table, should I use the employee number (will never change) or should I add an...

my table relations. From left to right: "Employees" Payroll (PK: 1) Employee Work Status Rate

I am new to Access 2007 and recently reviewed all the online tutorials on the Microsoft website and reviewed the provided templates (none of which fit my...

I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name,...

I created a table with two fields named "projectestimate" and "inspectionfee". The inspection fee is 5% of the project estimate. I want the "inspectionfee"...

Access allows a table to have an autonumber field which could be considered a record number. In an application I am involved in developing there are a number...

I still don't buy that this is either product-specific or amateur-specific. I've seen countless numbers of experienced, formally trained (and who learned it...

Dear all, Although many Microsoft Access books advise to set an autonumber field as primary index (a so called pseudo primary key),...

Whenever I've created junction tables in the past, I always made the PK of the junction table the combined pks from the two other tables. Ex: Table1 PK=A;...