
Jan 06, 2015
Databases can get big. Very big. This can be because they contain a large amount of data, but it can also be because of wasted space taken up by deleted data. When records are deleted, the space they occupied is not reclaimed. The remaining data can become fragmented and even corrupted. Microsoft Access has a utility that can compact and repair the database to fix these issues. It is found on the Database Tools tab on the Ribbon as well as under the File tab. It is a good idea to use this feature to make the database as lean and efficient as possible. Before using the tool, a backup copy of the database should be made. Once this is done, the procedure is simple:- Get anyone who has the database open to close it.
- Go to the ‘Database Tools’ tab on the Ribbon.
- Click the ‘Compact and Repair Database’ button.
- Go to the ‘File’ tab and choose ‘Options.’
- Click the ‘Current Database’ category on the left.
- Tick the ‘Compact on Close’ check box.
How do your Excel skills stack up?
Test NowNext up:
- The five stages of competence
- Designing business continuity management strategies in SharePoint 2013
- Setting up Outlook 2013 to suit your personal needs
- Normalising your database: Second Normal Form (2NF) – Part 2
- Using Outlook flags and categories to manage emails
- Rich dad’s antidote for distractions
- Are you using the right colour?
- Using cross-domain library with SharePoint 2013 apps
- Reduce your PDF file size in Acrobat XI
- Monitoring user connections to Office 365
Previously
- Say goodbye to an old friend – and other end of life facts
- So long 2014, hello 2015!
- Beguile for a while with a smile
- Use the Eyedropper tool in PowerPoint 2013
- Happy Holidays from New Horizons!
- Implementing external content types in SharePoint 2013
- Our interpersonal rights and responsibilities in the workplace
- Excel formulas are not just for numbers
- Two ways to put a sticky note on your desktop
- The changing face of the Office 365 plans