473,467 Members | 1,300 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How to create a primary key in access

3 New Member
Hi, Very new to access and database building. I have been asked to build a database and am struggling for advice. I was given two excel sheets: an updated and an older inventory list. The updated version has new added rows, changed rows, and deleted rows from the old one. I was asked to figure out which rows were changed, added, or deleted. The problem i came up with is that I have not been able to make a primary key and would need to make a primary key of more than one field because for every one PC (for example) there is a column that has either update, deleted, added. In theory I should be able to make a primary key based on the PC column and the update/delete/add column so that there is one pc name to either an update/delete/add column. Any advice on how to proceed?
Jan 21 '13 #1
2 1390
zmbd
5,501 Recognized Expert Moderator Expert
Two links to start with:
A Tutorial for Access

Database Normalization and Table Structures.

These will help you sort things out.
As for actual table design, you've given next to nothing to work with... no column headers, no example data and as such, this general answer is more than likely an example of the solutions you'll receive.
Jan 21 '13 #2
NeoPa
32,556 Recognized Expert Moderator MVP
Primary Keys (PKs) can be set up with multiple fields. Unfortunately, as you give little to no information on the question you want to ask, it is very much harder to answer your question more helpfully than that.
Jan 21 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: desc | last post by:
I am trying to create an access db using ADOX in C# and I am finding difficulties to find documentation on this in msdn library. Does anyone have any documentation or samples of creating an access...
7
by: sea | last post by:
Is it a good idea to programatically create a primary key? For example in a table called names, I have the following fields, (1) firstname (2)lastname (3) ID - will it be ok to create a primary...
0
by: Ol!v!é | last post by:
Is it possible to create an Access frontend project(ADP) that is splitted up in several modules? So a user can choose the modules he needs at the installation?
3
by: The Genie | last post by:
Can anyone please tell me how I can create an Access Database in a specific directory (not memory), presumably by using oledb. Regards Ian
2
by: Wayne Wengert | last post by:
I am trying to create an Access 2000 database using VB.NET. I found the code below via a google search but when I run it I always get an error. I do have a reference to Microsoft ADO Ext. 2.7 for...
3
by: James Wong | last post by:
Dear all, I have an old VB6 application which can create and access Excel object. The basic definition statements are as follows: Dim appExcel As Object Dim wkb1 As Excel.Workbook Dim wks1...
0
by: ricoiii | last post by:
Hello, i have created a service in vb.net 2005 and want to create an access-database at runtime. The code is: Dim cat As ADOX.Catalog cat = CreateObject("ADOX.Catalog") If...
1
by: ATSPSoft | last post by:
Hi, I'm newest in c#.. i need to create an Access MDB file... Supose that my MDB file is "mymdb" and my table is "mytableA" with 2 fields like "field1" as integer and "field2" as string How...
0
by: veer | last post by:
Hi i create database of ms-access using vb.net code but it create the msaccess database of format 95 is there any way how to create ms-access database of format 2003 because my system has ms-office...
2
by: mateymoo | last post by:
I am trying to create an access database for employees. Each employee has a list of qualifications that I want to include but am not sure how to have multiple entries for each employee. The...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.