Microsoft Access Tutorial: How to Modify Datasheet Layout Options
1. Open Microsoft Access
To change the colors and fonts of a datasheet, first open Microsoft Access (no database needed).
2. Click Tools -> Options
This will open the Options dialog window.
3. Go to Datasheet Tab
The next step to modify colors and fonts of an Access datasheet is to click on the tab called "Datasheet" in this "Options" dialog window.
4. Make Changes
There will be four sections of options called "Default colors", "Default font", "Default gridlines showing", and "Default cell effect". Additionally there are two check boxes called "Show animations" and "Show smart tags on datasheets".
The "Default colors" section is where you tell Access what colors you want to use for the background, the text, and the gridlines.
The "Default font" section is used to specify the font to use for the text in the cells of the datasheet.
The "Default gridlines showing" section can be used to adjust which gridlines should be displayed on the datasheet. You can select horizontal, vertical, both, or neither.
The "Default cell effect" controls how the cells in the datasheet look. You can select between flat, raised, and sunken.
Finally, the two check boxes are options that can speed up the speed Microsoft Access works with the datasheet (uncheck the check boxes). The check box options are additional animation effect related controls.
Once you've made your selections click on OK.
When you try to open an Access database table you will see the colors and fonts and all the settings of the layout have changed just like you specified.
Something to keep in mind when setting the options is that the text should be readable. For example you would not want to have dark text on a dark background. Also, I would suggest keeping both vertical and horizontal gridlines so it is easy to distinguish the different cells in the datasheet for your Microsoft Access table.
Also if you want to increase the performance of the Access database table you can uncheck "show animations" and this will increase the performance of the GUI interface but not the actual commands that Microsoft Access executes.
Keep in mind that these changes will apply to all the files that you open in Microsoft Access. These changes will be universal among all Microsoft Access documents and will be maintained regardless of which file you have opened/closed.
Published by Kantus
I love writing short stories and humor articles, but tend to stick with topics that are discoverable by search engines and capable of spreading virally. View profile
- Microsoft Access Tutorial - 4 Steps to Creating a DatabaseA step by step guide to creating your first Microsoft Access database.
- Microsoft Access Tutorial - 5 Steps to Creating a Database TableA Step-by-Step guide to creating your first Microsoft Access database table.
- Microsoft Access - 4 Steps to Adding Data to a Database TableStep by Step guide to adding actual data into a Microsoft Access database table.
- Microsoft Access Tutorial: How to Query an Access TableThis tutorial shows you how to make one of the simplest queries against a table.
Microsoft Access Tutorial: Executing a SELECT StatementA brief overview of how to use simple SELECT statements with an Access database table.
- How to Rid Your Computer of Microsoft Products: Get a Mac
- How to Import Microsoft Excel Data Into Microsoft Access
- OpenOffice.org To Replace Microsoft Office?
- Comparison of Microsoft Office and OpenOffice
- Working with Access VBA
- How to Create a Database Using Microsoft Access
- Three Simple Access Database Administration Tips