[Athen] Creating Relationships in Microsoft Access 2016 with Jaws

[Russell Solowoniuk]

Hi Timothy,

If you open the relationship window, tab to a table that has a relationship,  and arrow through the various fields, Jaws will say "Such and such field references such and such table, or such and such field is referenced by such and such table. This tells you which fields in a given table are related to which fields in which table.

Good luck.

Russell


>>> Timothy Breitenfeldt <timothyjb310 at gmail.com> 2017-01-23 10:00 AM >>>

This was incredibly helpful, thank you. Do you know how to view the
relationship with Jaws in the table itself? My teacher sent me a
database with a relationship in it, but I couldn't tell there was a
relationship at all. For example, isn't there supposed to be a way to
view the records that are related to another record in a one to many
relationship?

Thanks,

TJ Breitenfeldt
On 1/23/17, Russell Solowoniuk <SolowoniukR at macewan.ca> wrote:

> Hi Timothy,

>

> Okay, when you're in the relationship window with your tables showing, tab

> to the first table that you wish to create a relationship with. Arrow to the

> field you want to relate... actually, at this point, I don't think it

> matters which field you choose. Press the applications key, and from the

> contex menu, choose, "Show Direct". This will open the "Edit Relationship"

> window. Tab till you get to the "Create New" button and enter on this. You

> will be placed in the "left table name" combobox. Press Alt + Down Arrow to

> open the combobox and select the table you want. Tab to the "Right table

> name" and do the same. Tab again and you will be in the "Left Column Name"

> combobox. Choose the field you want to relate. Tab again to the "Right

> column name" combobox and choose the field you want. Tab to OK and press

> enter. You will be on the Enforce Referential Integrity checkbox. If memory

> serves, in most cases, you don't need to check this. Tab to "Create" and

> press enter. That should do!

>   the trick.

>

> If you ever wish to delete a relationship, just bring up the "Edit

> Relationship" window while in one of the related tables by pressing the

> applications key on one of the fields and choosing "Show Direct" from the

> context menu. Tab through this window and make sure that both tables in the

> relationship are shown in the left and right table name comboboxes. If no

> tables are shown, press alt + down arrow and choose the table in both the

> left and right side. Only one field is shown, so make sure it is one that is

> part of the relationship you want to delete. Tab to OK, and press enter. You

> will be back in the relationship window with the relationship line

> highlighted. Before pressing any other key, press the delete key. You will

> be asked if you are sure you want to delete the relationship. Confirm and

> the relationship is gone.

>

> Hope this helps.

>

> Russell

>

>

> Russell Solowoniuk

> AT Educational Assistant, Services to Students with Disabilities

> MacEwan University

> 7-198 D4, 10700-104 Ave.

> Edmonton, AB  T5J 4S2

> E: solowoniukr at macewan.ca 

> T:  780-497-5826

> F:  780-497-4018

> macewan.ca

> This communication is intended for the use of the recipient to whom it is

> addressed and may contain confidential, personal, and/or privileged

> information.  Please contact me immediately if you are not the intended

> recipient of this communication, and do not copy, distribute, or take action

> relying on it.  Any communication received in error, or subsequent reply,

> should be deleted or destroyed.

> Please consider the environment before printing this email.

>>>> Timothy Breitenfeldt <timothyjb310 at gmail.com> 2017-01-22 7:01 PM >>>

> Hi, I am taking a course this quarter on Microsoft Access and Excel,

> and I am having problems creating relationships with Jaws in Access. I

> have had pretty good success using Access up to this point with Jaws,

> but I can't figure out how to create the relationship between tables

> with the keyboard.

>

> I am able to create the tables, click on the relationship tab, add the

> tables, and even view the table's fields in the relationship viewer. I

> can see the fields I want to relate, but I am unable to relate them

> with the keyboard. everyone just says to drag and drop the fields.

> Does anyone know how to do this with Jaws?

>

> Thanks,

>

> TJ Breitenfeldt

> _______________________________________________

> athen-list mailing list

> athen-list at mailman13.u.washington.edu 

> http://mailman13.u.washington.edu/mailman/listinfo/athen-list 

>

> _______________________________________________

> athen-list mailing list

> athen-list at mailman13.u.washington.edu 

> http://mailman13.u.washington.edu/mailman/listinfo/athen-list 

>

_______________________________________________
athen-list mailing list
athen-list at mailman13.u.washington.edu 
http://mailman13.u.washington.edu/mailman/listinfo/athen-list