Unsure if 2002 Access Key Strokes will help, very similar to word processing commands, but I pasted below:
Read the Active Field Again: Insert-Tab Obtain an Overview of the Active Database: Ctrl-Shift-D Obtain an Overview of the Active Table: Ctrl-Shift-T Obtain an Overview of the Active Form: Insert-B Read Current Cell or Field: Insert-Tab Read the Status Bar: Insert-Delete ACCESS KEYBOARD SHORTCUTS Obtain Help: F1 Entering Data Activate Insert New Record Command: Ctrl-Equal Sign Complete Entry: Enter Cancel Entry: Esc Delete Character to Left or Selection: Backspace Delete Character to Right or Selection: Delete Complete Entry and Move Right: Tab Complete Entry and Move Left: Shift-Tab Insert a Line Break in a Field (Tables or Forms): Ctrl-Enter Insert the Current Date: Ctrl-Semi-colon Insert the Current Time: Ctrl-Colon Insert the Default Field Value: Ctrl-Alt-Spacebar Insert the Value from Previous Record: Ctrl-Apostrophe Edit Data Select Current Record: Shift-Spacebar Select Current Column: Ctrl-Spacebar Select Form: Ctrl-R Activate Edit Mode: F2 Copy Selection: Ctrl-C Paste Selection: Ctrl-V Cut Selection: Ctrl-X Clear Contents of Selected Field: Delete Undo Last Action: Ctrl-Z Delete Active Record (Tables or Forms): Ctrl -Minus Navigate in a Table Move One Field in any Direction: Arrow keys Move to First Field of First Record: Ctrl-Home Move to Last Field of Last Record: Ctrl-End Move to First Field on the Active Record: Home Move to Last Field on the Active Record: End Move to the Next Field (Table or Form): Tab Move to the Previous Field (Table or Form): Shift-Tab Move Down One Screen: Page Down Move Up One Screen: Page Up Move Right One Screen: CtrI-Page Down Move Left One Screen: Ctrl-Page Up Move to Specific Record: F5 Keystrokes for Menus Open the Shortcut Menu (right click menu): Shift-F10 Activate Menu Bar: Alt or F10 Activate Application Control Menu: Alt-Spacebar Activate Document Control Menu: Alt-Hyphen Select Command on a Menu: Up or Down Arrow----- Original Message ----- From: "Shane W" <shane-jfw@xxxxxx>
To: "Rod" <Rod@xxxxxxxxxxxx> Cc: <jfw@xxxxxxxxxxxxx> Sent: Thursday, November 11, 2010 2:25 AM Subject: Re: Access 2007 queries
Hey Rod, Hand-coding SQL is an excellent suggestion and one I didn't consider. I come from a PostGreSQL/MySQL background so that shouldn't be difficult. But how is input obtained from the user? For example, part of my assignment says query when given the broker's first and last name returns all clients managed by that broker. So a simple join occurs but does the query editor have a placeholder that says hey when you encounter this, go out and query the user? Also, how do you find designing forms as that's a big part of what I need to do? Best, Shane On Wed, Nov 10, 2010 at 03:39:14PM -0600, Rod wrote:Hi Shane,Yes, Jaws does not work well with access. I think it's got worse instead of better.Play with the tab & f6 keys to navigate around.I've been doing queries, by coding the SQL in notepad, then in access, switch to the sql view, and paste the SQL from notepad into it. If there are no errors, it will save, and you can run it. If there are errors, you'll have to fix the query. It's not easy, or fun, but can be accomplished. My hopes are that Jaws will eventually catch up and work better with Access.By the way, I use Vista Home, Office 2007, and Jaws Version 12. Good luck. Rod -----Original Message-----From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf Of Shane WSent: Wednesday, November 10, 2010 2:06 PM To: jfw@xxxxxxxxxxxxx Subject: Access 2007 queries Hello all, I am taking a course which requires the use of Access 2007 but am really confused about the JFW support here. I expect this is a common enough application though so wondering what others do. My current issue is the design of queries. I have tried using the query wizard and the query designer but Jaws isn't reading when a table is selected and the resultant fields, query types and values etc. So just wondering how people are using access... Best, Shane -- JFW related links: JFW homepage: http://www.freedomscientific.com/Scripting mailing list: http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.comJFW List instructions: To post a message to the list, send it to jfw@xxxxxxxxxxxxxTo unsubscribe from this mailing list, send a message to jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.Archives located at: //www.freelists.org/archives/jfwAlternative archives located at: http://n2.nabble.com/JAWS-for-Windows-f2145279.htmlIf you have any concerns about the list, post received from the list, or the way the list is being run, do not post them to the list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx-- JFW related links: JFW homepage: http://www.freedomscientific.com/Scripting mailing list: http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.comJFW List instructions: To post a message to the list, send it to jfw@xxxxxxxxxxxxxTo unsubscribe from this mailing list, send a message to jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.Archives located at: //www.freelists.org/archives/jfwAlternative archives located at: http://n2.nabble.com/JAWS-for-Windows-f2145279.htmlIf you have any concerns about the list, post received from the list, or the way the list is being run, do not post them to the list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx-- JFW related links: JFW homepage: http://www.freedomscientific.com/Scripting mailing list: http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.comJFW List instructions: To post a message to the list, send it to jfw@xxxxxxxxxxxxxTo unsubscribe from this mailing list, send a message to jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.Archives located at: //www.freelists.org/archives/jfwAlternative archives located at: http://n2.nabble.com/JAWS-for-Windows-f2145279.htmlIf you have any concerns about the list, post received from the list, or the way the list is being run, do not post them to the list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx
-- JFW related links: JFW homepage: http://www.freedomscientific.com/ Scripting mailing list: http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com JFW List instructions: To post a message to the list, send it to jfw@xxxxxxxxxxxxx To unsubscribe from this mailing list, send a message to jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line. Archives located at: //www.freelists.org/archives/jfw Alternative archives located at: http://n2.nabble.com/JAWS-for-Windows-f2145279.html If you have any concerns about the list, post received from the list, or the way the list is being run, do not post them to the list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx