Computers & Internet Logo

Related Topics:

Dee Gurung
Dee Gurung Posted on Dec 18, 2010
Answered

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

Answer This Question

1 Answer

Randy Rowell

Level 1:

An expert who has achieved level 1.
New Friend:

An expert that has 1 follower.
Corporal:

An expert that has over 10 points.
Problem Solver:

An expert who has answered 5 questions.

  • Contributor 5 Answers
  • Posted on Dec 18, 2010
Randy Rowell
Contributor
Level 1:

An expert who has achieved level 1.
New Friend:

An expert that has 1 follower.
Corporal:

An expert that has over 10 points.
Problem Solver:

An expert who has answered 5 questions.

Joined: Dec 18, 2010
Answers
5
Questions
1
Helped
526
Points
10

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.
can u plz mail me tha easiest way to use Ms - rowell_randy_0.jpg

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.
rowell_randy_1.jpg

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.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1helpful
8answers

MS Access database recovery
Have you tried creating a NEW MDB, and then IMPORTING the objects from the Crashed/Corrupted MDB?

This will SOMETIMES serve to rescue most if not all of the corrupted entities .

Or:
You can try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above. Having such a tool at hand immediately after a database file corruption incident may save you a great deal of time, nerve and, of course, an ample amount of money that would otherwise be paid to third-party recovery services. With eRepair Access, you don't need to depend on anyone and entrust your Access data (often quite sensitive) into somebody else's hands. You don't have to wait. You don't have to call it a day knowing that the damaged Access file will not be restored (if at all) until tomorrow. With eRepair Access, you can be back in the game within minutes!

For more information: http://access.erepairtools.com/

If doesn't help, look here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/933-ms-access-database-recovery
Read full answer
Feb 05, 2015 • Microsoft Office Professional 2007 Full...
0helpful
1answer

Application and example of relationship in access
Relationships

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.)
    relationshipdrag.jpg
  4. Select Enforce Referential Integrity
    refintegrity.jpg
    • 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
Read full answer
Apr 09, 2009 • Microsoft Computers & Internet
1helpful
1answer

Data From Table Auto Fill
You need to create 2 tables. Create one table with just the Center Number, County and Center fields, using the Center Number as the primary key, lets call this table Center. Then create the other table with all the other fields you need, lets just call it the Main table for now.
Then create a relationship between the Center table and the Main table using the Center Number for the relationship. The relationship should be a One-to-Many from the Main to teh Center table. When creating the form, you take the fields from both tables. When you input the Center Number, the County and Center should be automatically filled in.
Read full answer
Apr 08, 2009 • Microsoft Office Access 2003 (077-02871)...
18helpful
3answers

Connectivity between HTML page and Ms-Access
<HTML>
<BODY>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM Friends"
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<LI><%=RS("Name")%>: <A HREF="<%=RS("Link")%>">Homepage</A>
<%
RS.MoveNext
WEND
%>
</BODY>
</HTML>
Read full answer
Nov 11, 2008 • Microsoft Office Standard for PC
1helpful
2answers

Wizard unable to create form
i had this problem and it was because a computer class was installing multiple kinds of access on one computer. they wanted to teach all of them, but are now screwing them all up. ha.
Read full answer
Nov 10, 2008 • Microsoft Office Professional 2007 Full...
0helpful
1answer

Creating a table in Ms-Access
Have you tried to name the table Tiny_tots? it might make it work. Sometimes programs are funny about letting you have spaces in the name.
Read full answer
Oct 04, 2008 • Microsoft Office Standard for PC
0helpful
1answer

Access 2007 forms wizard
If you run a repair install of office 2003
Read full answer
Jun 04, 2008 • Microsoft Office Professional 2007 Full...
0helpful
3answers

Access 2000 database won't compact and repair.
mchampion,

You are in luck. I had the same problem a while back. Most of the time you will not be able to compact and repair a database that has reached capacity, however, you can import the database into a new one. The first thing you are going to have to do is find a very large table in your database and copy it into a new one. Then, delete that table from your old database. Now, open another new database. Go to the file menu and choose import. Now you must find your database in the directory and click it. Now choose one of the given options (tables, queries, etc.). Then, Press control + a to select all items. Now hit okay and it will import all of the items from your old database from that section into the new one. You must do this for each section (tables, queries, etc.). When everything is imported (should take less than an hour), compact and repar the new database. This will give you additional space to work with. Now you can bring in the table that you copied into a new database earlier the same way (import). This should put you back in business.
I suggest creating a 2nd database for any other data you may want to add later. You can always make link tables and such in your old database in order to get the additional data and prevent crashing your old database.
Let me know if you need any additional help.

ArthurB
Read full answer
Apr 24, 2008 • Computers & Internet
0helpful
3answers

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.
Read full answer
Nov 14, 2007 • Computers & Internet
0helpful
1answer

Ms access
Stored Procedures don't exist in MS Access. You do have the following options though. Queries, which are just select or action queries. VB Code, which you can write using Query Objects as if you were writing a Visual Basic application. These can be Functions or Subroutines. In these, you would use the standard programming techniques with while and for loops, etc.

You can create complex situations combining the two of these. A function in the VB code area can accept through parameters, the single values (line by line, record by record) in a query and act on them and manipulate the values.

For example: create a query that does a select phone from address. Create a function in vb called public function StripDashesInPhone(Phone as string) which then uses VB coding to strip dashes from each phone value passed in. To make it all work, in the query on one of the field columns put "NewPhone: StripDashesInPhone([Phone])" and for every record processed in the query, the function is called with the [Phone] field value passed in to the function and the action is processed and returned.

Other than writing a function that is activated by a form button click, which opens the current db and opens a table and process it, just like in VB, this is about as close to cursors and oracle procedures as you get.

I wish it was more, but ...
Read full answer
Oct 09, 2007 • Microsoft Office Standard for PC
Not finding what you are looking for?

View Most Popular

Computers & Internet

Related Question

MS Access database recovery

  • Microsoft Office Professional 2007 Full Version for PC

167 views

Ask a Question

Usually answered in minutes!

Popular Questions

How can open password protected microsoft word document.

Microsoft Word 2000 for PC

Get message that "Setup cannot find Office.en-us\OfficeMUI.msi"

Microsoft Office Professional 2007...

Hi i need micro soft visio 2010 product key

Microsoft Office Standard for PC

Microsoft Wireless Notebook Optical Mouse Model 1023

Microsoft Wireless Notebook Optical...

Dell Drivers XP drivers for vostro 1400 ..

Microsoft Windows XP Professional...

Check Out the Mobile Browsers Report
Check Out the Mobile Browsers Report

View all Fixya Reports

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

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

Answer questions

Manuals & User Guides

PDF Manual
Manual ZV1-00004.pdf....

Microsoft ZV1-00004...

PDF Manual
Tds_wirelessopticaldesktop700...

Microsoft Wireless...

PDF Manual
X12-39326-01_NA_EN_XC_FR_IT_PT_ES.pdf....

Microsoft Multimedia...

Loading...