Question about Microsoft Office Standard for PC

1 Answer

How many primary keys in MS.Access

Can there be two primary keys for a table?

Posted by on

  • Anonymous Mar 09, 2009




1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

No, there cannot be two primary keys in one table. You can specify more than one value to make up the primary key. For example, instead of just the last name column - you can have the last name and employee ID fields make up the primary key. If you don't specify a primary key, MS Access will usually ask you if you would like them to create it for you. You may be thinking about foreign keys. A table can have two or more primary keys in them but they would serve as foreign keys. For example - lets say you have table A with primary key "A" and table B with primary key "B". You can create table C and have both primary keys from tables A & B in it, however, they would be foreign keys in table C and not primary keys (they are only primary keys in their respective tables).

Posted on Oct 03, 2007


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

4 Answers

How to fix error in database: microsoft office access has detected corruption in this file

System restore will not restore any data files, only system files.
Databases normally need periodic sorting as their indexes get corrupted. I don't use any microripoffsoft stuff, only Open Office and iMac. Try reindexing your file with Open Office

Nov 01, 2015 | Microsoft Office 2003 Basic Edition...

7 Answers

Database corrupted

You can use Recovery Toolbox for Access is used for recovering data from corrupted Microsoft Access database files with *.mdb, *.accdb extensions.

For more:

Oct 29, 2015 | Microsoft Office Computers & Internet

1 Answer

Having troube with my FOREIGN KEYs on two tables.

I suggest you visit this website you will get the solution, I tried and it worked.

Nov 25, 2013 | Computers & Internet

1 Answer

Can u plz mail me tha easiest way to use Ms Access, like Creating relationship, with the table, creating form, query etc.

In general you initiate this process by pressing the "Relationships" button on the MS Access toolbar. It is the button with three small boxes arranged in a triangle shape.

When it first comes up it will give you the option to add tables. You can add any set of tables including the possibility of adding one table more than once (you would do this if you wanted to create a relationship between fields in the same table).

Once you see the tables you're interested in, you simply drag the field from one table over a field in another table. The fields should be those that will define the relationship. Once done, you should see an Edit Relationships window. You can get back to the Edit Relationships window later by double clicking the line in the relationships window.

MS Access does a good job of figuring out the relationship type. For example, if you match a field in one table, that is not a key, with a primary key in another table, Access will make this a Many-to-One relationship.

This can become a very deep subject. Hope this at least gets you in the right direction.

Dec 18, 2010 | Microsoft Computers & Internet

7 Answers

How can i repair a damaged access database

There are some reasons which may damage your MS access database such as virus infection, software crash, accidental shutdown of system, unrecognized format of database, corruption of storage media etc. These issues are easy to overcome by using third party software of access database can try Kernel Access Database Recovery Software one of the best software in Data Recovery

For information you can visit here ...

Aug 23, 2010 | Microsoft Computers & Internet

7 Answers

Undelete records from access table

ou can try to use third party Access recovery utility to restore your lost and damaged data from .mdb files. For more details about this software:-
Access File Recovery

Apr 17, 2009 | Microsoft Access 2000 (077-01277) for PC

1 Answer

Application and example of relationship in access


After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

Having met the criteria above, follow these steps for creating relationships between tables.
  1. In the database window view, at the top, click on Tools ---> Relationships
  2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
  3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
  4. Select Enforce Referential Integrity
    • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
    • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
  5. Click Create and Save the Relationship

Apr 09, 2009 | Microsoft Computers & Internet

1 Answer

How to export table in ms access to excel

yes you can export your access data into excel, follow steps on how to export.

1. open your access database
2. open the table data you to export
3. under table data view click tools menu
4. select analyze
5. select ms excel
6. this will open your seleted access table in excel

hope this will help you..

Dec 13, 2008 | Microsoft Access 2002 for PC

1 Answer

MS access 2003 problem

I do not know the pogramme in MS access I know the simple course of MS Access.Please kindly send me full verson of MS Access programme course in my mail Id

Jun 20, 2008 | Microsoft Office Access 2003 (077-02871)...

3 Answers

Ms access

before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.

Nov 14, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

438 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18420 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides