I have finished building my database and it's almost ready to place on my company's SQL server to be accessed via our intranet. I have never done this before....

1. I have set up a DB in access 2003 (ac200 format). I have split the db to front/back end. Installing a new version of the front end is easy. Copy - paste -...

I want to add a field called Payments to a table. The value of this field is calculated by multiplying the Days field and the Fee field together (the Days and...

I want to be able to create a database that would allow me to make my job easier. I want to create a database to input data on quarterly damage reports from...

It's getting rather complicated now! I'm not sure what I need to do now! I will try and upload a screenshot of my relationships! I need to display all 32...

A worksheet for pricing the cost of repairing cars....

I just wanted to post my tables and their relationships to get some feedback from the pros on whether or not this database is headed in the right direction....

I have inherited a flat data base that has something like 50 fields, a heap of queries, forms and reports. I need to Normalise the table and fields. Is it...

I am after an opinion as to whether or not it is advisable or necessary to index a field that is used in a relationship with a field on another table. I do...

Hi I have been going through the At Your Survey template (thank you Duane) and have a question. I would like my 'RspnsType' to be various things, some...

I've got a form based on a table in my application, and I have a command button that does some processing after filling in the fields for a record. When the...

I have a table with peoples names, and multiple questions to be filled out by a supervisor. If this is to be done 4 times a year, can I have sub groups for...

I want to have Access add the next number in a sequence to the Next Record automatically. My format is D-2467 and I want Access to add the next number which...

I've created a form (as a menu) and on this form there is a button. When I press this button it opens a list box. The list box is based on a query which has...

I am a coordinator for the local AARP tax aide program. I want to create database for the local sites that I run. Site table. How can I construct the Site Info...

I have multiple queries that have data which was accumulated. I was able to calculate the totals of each field at the bottom. However I now need to...

I have a MS Office 2000 Access program that I would like to clear the data out of. The problem is that I did not write the program and it has data (approx...

Hi all I'd like advice on the following issue: I have a "Categories" table with fields (*CatID, CatName), and in my "Items" table I need to have the necessary...

I am trying to create a database for my wife for Mary Kay. I need to be able to input product info, customer info, and use those databases to create orders. ...

My goal is to prompt users to enter in their Beacon (credit) score and BNI Score and Access will query the table and generate the correct interest rate. But...