im working on a database in relation to my work as data processor.. it's a database where i need to store montlhy stipends and tuiition fees that we give to...

how to design our project stepby step procedure in tables,forms, quieries and reports?

If I make any keystrokes between curring and pasting I only get the option to paste a bitmap image of the screen. Something's changed - it never used to be...

I have a flat database that will not do.. and need to make it as relational as I possibly can. This is for a non-profit organization, and deals with coal...

Hello, I'm trying to create a database to keep track of my customers'transactions and don't know which table to choose. Here is the business process. A...

Hi All, I have transfered my Access database file into MS SQL using the upsizing wizard. There are 5 tables that have relationships with each other and I...

Hi All, I was wondering the point where an MDB file might start to have data integrity problems. What is the benefit/cost of putting all tables/data in 1...

Hi All, I am new to Access and 'Referential Integrity' is a new concept for me. In order to understand it better I started working on some sample tables with...

I have a report with 691 clients with each assigned one Account Officer (AO). There are 74 Account Officers. I currently have a query based report that prompts...

Hello, Please explain the usage of a "fact table" in an MS-Access database... Thank you, -- Charles L. Phillips

Does anyone know why the SQL view may not be available to use for a table of form? I have read that you can get the SQL view by clicking on the view button...

Hello, When designing a database, what is considered normal table size??? a.. How many fields should a table contain? b.. I know trial & error is the best...

Hello, I have an MS-Access 97 database, that I am cleaning up. Are there examples of VBScripts or VBA code, I can use to delete duplicate files??? Better yet,...

Over the last 2 years I developed a data base used in transportation. I have developed a few different versiosn to accomodate diferent locations. In it has...

Over the last 2 years I developed a data base used in transportation. I have developed a few different versiosn to accomodate diferent locations. In it has...

I have developed a database in 2003 and now I need to install it in a mixed enviroment some PC have 2003 and some 2007 is there an easy way to make...

I designed a database in 2003 and was working fine. I upgraded the desktop to 2007 and the databse was working fine after resolving some security issues. When...

My database classes were nearly a decade ago and I was never very good with normalization to begin with. I could use some help with this: I am writing a db to...

I've run across a design issue that I'm asking for any help and advice anyone if willing to offer. The easiest way to explain my question/problem is just to...

I have a client form that depends on a client table. One of the fields in both objects is a pull down which lists the different programs to which the client...