Microsoft Access Tips, Tricks and Shortcuts
Microsoft Access Blog | Avantix Learning
You can highlight values in fields or records in Microsoft Access reports using conditional formatting. Certain conditions must be met in order for the formatting to be applied …
You can create calculated fields in select queries in Microsoft Access in the QBE (Query by Example) grid. You’ll need to learn a few syntax rules and then you can create simple to more complex calculations.
Check out these great shortcuts for manipulating controls in Design View in both forms and reports in Microsoft Access.
In Microsoft Access, small green error markers may appear in Design View in forms and reports for a number of reasons. You can turn error checking off completely or set the rules you prefer.
In newer versions of Microsoft Access, you can create a new type of form called a navigation form which includes one or more navigation controls.
Microsoft Access includes an export wizard that can be used to export tables, queries, forms or reports easily to Excel. It’s common to have many users in an organization using Excel so data in Excel format can work well.
Check out these 25 keyboard shortcuts when you’re working in Access tables in Datasheet View.
There are many keyboard shortcuts that can be used in the Microsoft Access Navigation Pane. The four basic objects that appear in the Navigation Pane are tables, queries, forms and reports.
There are a number of ways of working efficiently in select queries to get the results you want and save some time. You can also use many of these tips in other types of queries.
In a Microsoft Access report, you can use Layout View to quickly filter data without having to create a new query to use as the source for the report. This can save you a lot of time.
Check out these 10 techniques when you’re designing forms in Microsoft Access. We use these strategies to save time and design consistent forms.
If you have Microsoft Access 2010 or a later version, you can easily convert your Access reports to PDF without using Adobe Acrobat Pro. Use the File tab or the External Data tab on the Ribbon or you can customize the Quick Access Toolbar.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | email@example.com