Microsoft Access 2013 Tutorial 5: Case Problem 2

In this tutorial, we will explore some advanced features of Microsoft Access 2013, including troubleshooting common issues with your database and managing files in a new location.

Before we begin, make sure you have chosen the correct version of Office to match your target installation. For example, if you are using a 32-bit version of Windows, choose the x86 version of Access 2013. To compact and repair your database, open it in Access and click 'Compact and Repair' from the 'Database Tools' tab.

If you encounter any issues with your database, try holding down the Windows key and pressing R to open the Run dialog box. Type 'services.msc' and press Enter to open the Services window. Stop and restart the Microsoft Office Service by right-clicking on it and selecting 'Stop', then 'Start'.

To change the location where Access stores your database files, click the folder icon next to the 'Database name' field in the 'Create a new database' dialog box. Select a location of your choice, such as an external hard drive or cloud storage service.

When running queries in Access, it's often useful to add a WHERE clause to filter results. For example, if you run a query without the WHERE clause, you may get all records from the table instead of just the ones you're interested in.

In this case problem, we will use Microsoft Excel Scenario Manager to create a decision support case. Download the file 'Excel5 Case1.xlsx' and open it in Excel. Then, save the workbook as 'My Workbook.xlsx' to your computer.

Finally, if you encounter any issues with your database, try opening the 'Troubleshoot case problem' worksheet in Access 2013. This will walk you through a series of troubleshooting steps to help resolve common problems.

In conclusion, this tutorial has covered some advanced features of Microsoft Access 2013, including troubleshooting and file management. By following these tips, you should be able to create a robust and efficient database solution using Access 2013.

Microsoft access 2013 tutorial 5 case problem 2