Database Design - Page 23 - OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

		Home » OfficeFrustration forum » Microsoft Access
Database Design

Home

Page 23 of 581

Threads in Forum : Database Design

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Primary and Foreign Keys by Kathy R. It's the end of the day and I'm second-guessing myself and need some clarification regarding Primary and Secondary Keys and which tables they should be... ( 1 2)	February 21st, 2010 04:12 PM by Bilky_White	12	736
Best way to design tables for cascading on my form by Pamela My company inspects damaged cars for insurance purposes. Up to now, (relating to this issue) I've had tblDamageArea populate a list box on my form where the... ( 1 2)	January 13th, 2010 03:06 PM by Pamela	12	485
Writing and IIf statement in Access? by Roger Drews I am trying to write an IIf statement to use in a calculation where if PT1 is zero it will use PC1 to determine the value. Here is the state I have tired but... ( 1 2)	April 5th, 2010 06:14 AM by John W. Vinson	12	1,153
data dictionary by GOwsley How do I create a Data Dictionary report (table name and description + column name and description) from either Access or Visio after the database has... ( 1 2)	April 22nd, 2005 05:20 PM by Jeff Conrad	11	352
how do i setup a field in office access to automatically assign 4. by zaid hi, I have this quesion.. i have jus started using Access, and im sure a lot of ppl would know to do this. i want to create a field "employee ID" and i have to... ( 1 2)	May 3rd, 2005 09:04 AM by Jamie Collins	11	212
Using Date as one of the field in Access by Jack Hi, I am using Date as one of the fields in a Access table. Now when I am tring to run a update query (UPDATE tblExpense SET Date... ( 1 2)	April 27th, 2005 02:18 PM by Jamie Collins	11	289
Best approach for this problem? by Joe I have to create a Microsoft Access 97 database (with a SQL Server back-end) which acts as a quotation engine for an insurance company. The problem I have is... ( 1 2)	April 29th, 2005 10:24 AM by Joe	11	328
Design help - simple ? by Brian Apologies upfront as this is extremely basic I need to design a tracking database - to track the various stages of startup of a study. The main form (based... ( 1 2)	June 10th, 2005 08:55 PM by Brian	11	179
many to many relationship by SWM How do i set up forms to input information in a many to many relationship. I have created two tables and a junction table with two id fields and made them both... ( 1 2)	July 1st, 2005 06:50 AM by John Vinson	11	195
Still Stuck on Alpha Numerics by HOT FLASH I need to sort a numbering system comprised by multiple alpha characters and numerics, and I need it to sort this list numerically, and not using a... ( 1 2)	April 10th, 2005 01:29 PM by HOT FLASH	11	221
Show a Table? by Bob -- After searching Google.groups.com and finding no answer, Bob Vance asked: I have a made a command button to print a table how do I go about getting... ( 1 2)	December 30th, 2004 07:49 PM by John Vinson	11	197
choosing which subform based on option button by beejsnyder I have a single database to cover inventory where there are 3 types of inventory and different detail questions to be asked for each, depending on what the... ( 1 2)	August 4th, 2004 06:32 AM by tina	11	506
Validate information by Joseph I have a table with 3 fields licence number = 6 characters / name of license holder & address off licence holder. The second table are individuals who may... ( 1 2)	August 10th, 2004 05:38 AM by Duane Hookom	11	328
Check constraints by Aaron Abdis Hello, I have a table called Company_Locations. There is a field named Is_Main. For any given COMPANYID, i want that only one Location can have the... ( 1 2)	August 14th, 2004 04:19 AM by TC	11	248
How to ID a record by Ray Hi, I am wondering about proper or accepted practise for ID'ing records in a relational database. My question is this... If I have a table with a unique... ( 1 2)	August 30th, 2004 06:35 PM by Tim Ferguson	11	386
Create Local Table by Bryan Hughes Hello, I have a table with a fe for users and be that holds just my tables I have code that will create tables, but it creates them in the be and links them,... ( 1 2)	September 11th, 2004 04:12 AM by Allen Browne	11	293
Fixing up structure with primary, natural, surrogate, etc. by Fred Boer Ok, well, I've been reading a few threads about Primary Keys, and the use of natural vs. surrogate keys. Sadly, a little learning is a dangerous thing, and... ( 1 2)	September 17th, 2004 05:53 PM by Tim Ferguson	11	639
Copy table in a split database by DQ Hi, First of all I do not have much experience with split DB's. I have a DB (Access 2002) that is split. In the DB I have tables for each year eg.... ( 1 2)	September 23rd, 2004 05:57 PM by Lynn Trapp	11	757
table size by rudwan hi how i could know teh size of my tables ? also my forms ( 1 2)	November 10th, 2004 07:58 AM by rudwan	11	180
Add new tables to database by LMB Hi, I have a database with a table of employees. tblEmployees numEmployeeID (autonumber) PK strEmpLastName We need to keep track of total hours worked in 5... ( 1 2)	June 28th, 2004 02:11 PM by LMB	11	215

Page 23 of 581

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 07:15 AM.