[Athen] Creating Relationships in Microsoft Access 2016 with Jaws

[Timothy Breitenfeldt]

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

>