Hi Bill, I've crossposted this and set followups to microsoft.public.tables.dbdesign, where it seems to belong. Presumably you have tables for Customers,...

There's a "standarized" naming convention used in the design of a database...tbl, qry, rpt, etc. When I d/l a 2007 template, it uses the prefix "tlkp". It's...

Could someone explain to be the workflow/possibilities of Sharepoint or other Access services? Please forgive me, in advance, if I do not get all my...

Hello, I am trying to devise a system for checking out files and I have four tables 1)Files in file room 2)People who check out files 3)People who deliver...

Okay I'm back again, with the same problem, and at a loss. This is my 2nd database, and same brick wall! The loading of my form takes upwards of 40 seconds...

I am having trouble figuring out how to set up tables/fields for the following problem. Can someone please point me in the right direction? I currently have...

Hello I have been working with database since a couple of weeks now. The idea was to create a database that contains information about a student such as...

Each of my two tables has the same data except the last five fields which are different. I'm simply trying to combine the tables for a Report by joining the...

Hello kind and helpful people. I have a field in a table for which the syntax is 8 characters (both alpha and numeric). The last 3 digits of these 8 characters...

I was trying to add a first record to a table called BOOKING with the primary key defined as AUTONUMBER. I made a mistake because I needed to put a dummy...

I am progressing with my student database, thanks for all help so far, my next problem is this. I want to record student discipline infractions. This means...

Please send me details regarding cardinality and Multiplicity in DBMS

I recently posted a question about multipe M:M relationship tables. In one reply, RPW responded with the following: ************* Although the following is...

i keep questions in a table, each question has a different answer type. eg answer could be a number then there will be limits for the answer or it could be...

Similar to a previous post with forms .... I am trying to build cascading lookups (combo boxes) in an Access 2007 table. I have two combo boxes. While in the...

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...

Hello-- Whenever I run the Performance Analyzer I get the following "suggestion": Table 'tblTasks': Relate to table 'tblTasks' Why is it telling me to...

I want to highlight one row of a table and highlight that row, but when I do the font color change applies it to the whole table. Is there a way to highlight...

Hi, Can anyone reccomend a sample question and answer database example. My needs a Choose from a sample of 150 questions, multiple choice answer, to...

I have created a.. Table of contacts tblcontacts. Surname query qrySurname. A report base on rptQuerySurname. A macro to print a Selection mcrSelection. When I...