Microsoft Access Tips & Tricks

WindowsIf you have programs (e.g. Internet Explorer, Word, Excel) pinned to your TaskBar, hold the Windows Logo key and press 1 to start the first program, Windows Logo + 2 for the second and so on.ExcelStruggling to understand a complex formula? Select the cell containing the formula and click "Evaluate Formula" on the Formulas tab. This will show you the steps Excel follows to arrive at the final result.WordDo you need a non-numbered paragraph in the middle of a numbered list? Type the whole n....

MS Office 2016 doesn’t have a long list of awesome new features. The new additions made to Office 2016 are few and they aren’t for everyone. Moreover not all new features are functional in nature. MS Office 2016 has made an effort to make the UI better looking. It comes with a dark and light theme now, and it’s added a background design to the title bar. The design by default shows clouds but you can change it or remove it altogether if you like. Here’s how.   T....

Don’t spend ages re-sizing and aligning fields with the mouse on Forms or Reports; select multiple fields and use the Size/Space and Align buttons on the Form Design Tools/Arrange Tab.

Use “Compact and Repair Database” on the Database Tools Tab to reduce the database size and improve performance. For a small database used frequently, consider turning on the “Compact on Close” option (in File/Options/Current Database) to save having to remember to do it manually

Access 2010 allows you to create a calculated field in a Table, rather than having to run a query or a report to carry out calculations. Where the calculated field refers to the values held in fields, those fields must be from the same table. The expression for the calculation is created in the Expression Builder. • To create a calculated field in a table, switch to the Table Design View; • On the Create Tab, select the Table Design button in the Tables group; • Create the other f....