converting website visitors
Microsoft Office Tip & Tricks Menu
Tip & Tricks Menu

Microsoft Access Tips & Tricks

Wednesday January 3, 2018 at 8:44am
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....
Monday October 31, 2016 at 11:39am
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....
Friday September 9, 2016 at 5:01pm
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.
Thursday July 24, 2014 at 3:02pm
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
Tuesday July 12, 2011 at 6:26pm
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....
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411
Website Design by ZARR Ltd