Ms Access Tutorials

665 Words3 Pages
Specify the default form in Access Options This procedure assumes that you have already created the form that you want to display. 1. Click the Microsoft Office Button , and then click Access Options. 2. Click Current Database, and then in the Display Form list, select the form that you want to display when the database starts. 3. ------------------------------------------------- Click OK, and then close and reopen the database to display the startup form. 4. How to hide and unhide a MS Access object You can hide and unhide a MS Access object (Tables, Queries, Forms, Reports, Pages, Macros, Modules) in the query navigation pane. It's a similar feature like what you do in MS Excel to hide and unhide a spreadsheet.…show more content…
18. How to unhide a query in Access 97, 2000, XP, 2003 19. 1. Go to Tools -> Options on the menu bar. 20. 21. 2. Click the View tab and check Hidden objects in the Show section. 22. 23. 3. Click OK. 24. 4. Go to the Queries pane to view all the queries. The hidden query should now be displayed but its icon is grayed out. 25. 26. 5. If you need to show the query so that they can be displayed as normal (not grayed out), right click on the query name and uncheck the checkbox Hidden so effectively you change the option back to unhidden. 27. How to unhide a query in Access 2007 28. In Access 2007, the way of configuring things have been dramatically changed by Microsoft. To unhide a query (or any other Access objects), you need to use the Office Button. 29. 1. Click the Office Button at the top left corner of Access window. 30. 31. 2. Click Access Options button. 32. 33. 3. Click Current Database tab on the left hand side navigation menu. 34. 35. 4. On the Current Database tab, click Navigation Options button. 36. 37. 5. On the Navigation Options window, tick the checkbox Show Hidden Objects in the Display Options section. 38. 39. 6. Click OK to close all the windows. 40. 7. Go back to the navigation pane to view the queries. You should see the query name "Quarterly Orders by Product" is now grayed out but still viewable. 41. 42. 8. If

More about Ms Access Tutorials

Open Document