|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
|
Move Up Down By Richard Rost 
5 years ago
QuickTip Shortcut Keys Move Up/Down with Ctrl-PgUp/Dn Learn how to navigate through records in your forms with the Ctrl-PgUp and Ctrl-PgDn keys. Learn the difference between continuous forms and single forms. Other Shortcut KeysLinksHere's that TechHelp video: https://599cd.com/TechHelpMoveKeys
IntroIn this video, we will talk about using the Control Page Up and Control Page Down keyboard shortcuts to move between records in Microsoft Access forms. You will see how these shortcuts work in both continuous forms and single forms, and how they differ from other navigation options like arrow keys and regular Page Up/Page Down. I will also mention how you can add your own navigation buttons for Next and Previous to further customize your Access database.TranscriptWelcome to another TechHelp Quick Tip video brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.I have been trying to do one of these shortcut keys quick tips at least once a week, but I have fallen behind. I have not done one in a couple of weeks. In today's video, I am going to show you how to use Control Page Up and Control Page Down to move between records. Here I am in my blank customer template. You can download a copy of this for free from my website, by the way. If you open up a continuous form like this customer list form, you can use Control Page Down to move up and down the records. Right Tab goes to the right. You can use the left and right arrow keys, but the up and down arrow keys do the same thing as the left and right. You have to use Control Page Up and Page Down if you want to move between the records there. These keys also work in a regular single form - Control Page Down and Control Page Up to cycle between the different records. Now, it is a little different because Page Up and Page Down also go between records in a single form, but if you use a continuous form and you press Page Down, it goes down a whole page of records. That can be confusing. Page Down and then Page Up, Page Up. So use Control Page Up or Page Down; that is the one that I am used to. I have to admit, I did a TechHelp video earlier today to move up and down with the keys, and that prompted me and reminded me I should do a shortcut video because I have not done one in a while. In the TechHelp video, I mentioned the Control Page Up and Page Down keys, but I also show you how to make your own buttons. You can make a button that says Next and Previous, and then you can use Alt N for Next or Alt P for Previous. In the Extended Cut for the members, I show you how to actually capture the keyboard events, so you can just use the arrow keys and move around in your continuous form just like it was an Excel spreadsheet. That is the Extended Cut for members. That is your shortcut key quick tip for today. Remember, only try to learn one of these a week. Do not try to learn too many of them. Add it to your routine and increase your productivity slowly. For more tips like this, visit my YouTube channel or my website, AccessLearningZone.com. QuizQ1. What is the primary shortcut introduced in this video for moving between records in Access forms?A. Control Page Up and Control Page Down B. Alt F4 C. Shift Tab D. Control Enter Q2. In a continuous form, what does pressing Control Page Down do? A. Moves down an entire page of records B. Moves to the next record C. Moves to the previous record D. Moves to the next form Q3. What is the difference between using the arrow keys and Control Page Up/Page Down in a continuous form? A. Arrow keys change records, Control Page Up/Page Down moves the selection field B. Arrow keys move fields, Control Page Up/Page Down changes records C. Arrow keys do the same as Control Page Up/Page Down D. Arrow keys only work for moving left and right, not up and down between records Q4. In a single form, what does pressing Page Up or Page Down do? A. Scrolls the field left and right B. Switches between tabs C. Goes between records D. Filters the current record Q5. In the Extended Cut for members, what additional feature is demonstrated? A. How to print records B. How to export data C. How to capture keyboard events to use arrow keys for record navigation D. How to format forms Q6. What is the suggested pace for learning new shortcut keys according to the video? A. Learn them all at once B. One per week C. One per day D. Never learn shortcut keys Q7. How can users navigate to the next and previous records using custom buttons? A. By clicking a 'Print' button B. By using Alt N for Next and Alt P for Previous C. By pressing F1 D. By double-clicking the record Answers: 1-A; 2-B; 3-D; 4-C; 5-C; 6-B; 7-B DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from the Access Learning Zone covers another helpful shortcut key tip. I am Richard Rost, your instructor.I have been aiming to share at least one shortcut key quick tip each week, although I have fallen a bit behind recently. In this lesson, I want to explain how you can use the Control Page Up and Control Page Down keys to move between records in Microsoft Access. Using my blank customer template, which you can download for free from my website, I demonstrate this with a continuous form, such as the customer list form. When you are in a continuous form, pressing Control Page Down moves you forward to the next record, while Control Page Up takes you back to the previous one. Although you can use the Tab key and the arrow keys to navigate fields within a record, these do not let you move between records in the way Control Page Up and Control Page Down do. The Up and Down arrow keys in this context act like the Left and Right arrows, which may seem unintuitive. Therefore, to jump from one record to the next or previous, you should use the Control Page Up and Page Down keys. These shortcuts are also available when working with a regular single form. You can cycle through different records using Control Page Down and Control Page Up. However, on a single form, Page Up and Page Down alone will also move you between records, while on a continuous form, Page Down advances a whole page of records at a time. This can sometimes cause confusion if you expect it to only move one record. That is why I recommend sticking with Control Page Up and Control Page Down for clear, record-by-record navigation. Earlier today, I made a TechHelp video about using the keyboard to navigate records, and it reminded me that I should follow up with this shortcut tip since it has been a while. In that other video, I also mentioned how you can add your own navigation buttons, like Next and Previous, to your forms. You can assign shortcut keys to them, such as Alt N for Next and Alt P for Previous, to make moving through records even easier. Members have access to the Extended Cut, where I go even further and explain how to capture keyboard events so you can use the arrow keys to move around a continuous form as if you were working in Excel. This provides a more familiar, spreadsheet-like experience in Access, and is exclusive content for site members. To sum up, this is your shortcut key tip for the week. Remember, it is best to pick up just one new shortcut at a time and practice it regularly, rather than trying to memorize too many at once. Gradually building these into your workflow will steadily increase your productivity. If you want more useful tips like this, check out my YouTube channel or visit AccessLearningZone.com. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends. Topic ListUsing Control Page Up and Control Page Down to move between recordsNavigating continuous forms with shortcut keys Differences between navigation in single and continuous forms Using Page Up and Page Down keys in single vs continuous forms Creating navigation buttons for Next and Previous record |
||||
|
| |||
| Keywords: TechHelp Access shortcutkeys keyboard shortcuts, move up down records, ctrl pgup, ctrl pgdn PermaLink Shortcut Keys Move Up Down in Microsoft Access |
