|
|
Shortcut Keys can save you lots of time when you're using Microsoft Access to add and update information, and when you're developing applications.
Here you'll find the shortcut keys that I use the most. I hope they're useful for you too.
Maria Barnes and I presented a free webinar for beginning Access developers, and any developer who wants to fill in gaps and offer insight. We shared the best of our tips and shortcuts, and others jumped in with valuable insight too. Here is the video for Part 1 on YouTube:
Part 2 was presented Feb 23.
download QAT customization file
video: Quick Access Toolbar (QAT) -- Customize and Share (Import/Export) (12:52)
Maria's Tips and Tricks for the beginning Access developer
Problem names and reserved words in Access, by Allen Browne
Access Basics, free 100-page book
When you're learning Access, it is good to have templates with data so that you can play around with Access and experiment without concern for messing anything up ;)
Northwind is a Microsoft template that is commonly used in demonstrations because anyone can get it. It is not as bad as some of the others, and has been around for a long time.
video: Get Northwind Database for Microsoft Access (5:01)
My general opinion of the Microsoft templates is that they're riddled with bad design -- but good for ideas.
MyContacts is a light version of my free contact management template. Like the fuller version, it has hundreds of sample records you can play around with while you're learning how it works. The main menu has an option to clear the sample data when you're ready to put in your own information
Contacts is free Contact Template for Access. It is split into FE (front-end) and BE (back-end) and has 2 videos to explain how to use it. Lots of sample data. You can swap the BE out for the blank one to put your own data in.
Shortcut Keys are fun to learn and use.
I drew all the keycaps you see with PowerPoint and then loaded them into Word as AutoText. That makes writing documentation and training materials faster too. I was going to draw the Windows key but couldn't decide if the windows should be straight or wavy -- so for now, Win means the key with the windows on it ~
I love to connect to others who are building applications and team-develop. You have business knowledge and I have skills to automate. Together, we build something better than either of us could do alone. Let's connect!
Email me anytime at training@msAccessGurus
I look forward to hearing from you
~ crystal