Your 5 Keys to Easy Microsoft Access Database Editing
Microsoft Access has advanced massively over the last 20 years. It is now a rich application that provides excellent out-of-the-box functionality. It is now compatible with other applications and can be used to create a productive and functional solution that can meet all your business needs. Often, people that are looking to work with Access don’t fully understand the functionality that Access has to offer. So to help counter that, here are my top 5 tips to help you with Microsoft Access.
Entering information into tables and forms is, of course, very simple… and Microsoft Access makes it intuitive. On top of this Microsoft Access includes keyboard shortcuts to enhance the usability through better navigation and editing processes. CTRL + adds a new record. CTRL ‘ takes the value from a previous record and replicates it in the corresponding field in the current record. Using the F2 key provides the opportunity to edit a record. There are so many ways to improve the usability of Microsoft Access. Make sure you check out the help file in the program by looking for “keyboard shortcuts”.
The Object Properties Dialog Box
Items in the navigation pane and database window have properties that are hidden in which you can add narratives and also remove the object from the screen. There is a keyboard shortcut available in the form of ALT + Enter or you can “right-click” -> Properties. Once you have hidden an object, it will be gone from view until you select the option “Show Hidden Objects”. Utilizing this function is primarily adopted for sensitive items such as Action Queries and can be very useful.
It is possible to open a form on your welcoming screen instead of the navigation pane or database window. This can help make it a richer front-end. You can also stop the startup by pressing and holding “shift” during the database file launch.
Reporting In Access - Combine with Excel?
Reports are numerous in Microsoft Access database. It includes pivot tables. However, most people will be more comfortable with Excel’s pivot tables. It is possible to take data from Excel and link it to the Access database. The two applications, both being Microsoft, are great for integration and Excel also provides the added benefit of having a file that can be sent by email.
Updating Bulk Data
If you have a big update to do and it involves a pattern, then there is a function called “Update Query”, which enables you to dictate the criteria and also include calculations. A typical example of this is with an online store: A price increase of 5% across the board could be done through a formula update query. Updating each price manually could be a time consuming nightmare, but running an update query is fast and simple. There are so many different options available in Microsoft Access. It’s a far more powerful tool than most of us give it credit for. Get your head into the system and understand how it can help improve your business and you really will benefit from an efficient, productive, and profit-increasing piece of software.
© 2013 Phoenix Consultants Group, Inc.