You are Here: Articlelogy.com » Computers » Databases » Access 2007 Datasheets Can Be Fully Customized

Access 2007 Datasheets Can Be Fully Customized


Go to: Previous Article Next Article


In Microsoft Access, the datasheet provides a simple way of interacting with the data in your tables. Unlike forms, which you need to create for yourself, the datasheet is built into Access and you can enter datasheet view just by double clicking any of your tables. However, by default, the datasheet is a fairly unsophisticated interface for interacting with your data. To make the datasheet more useful, Access allows you to customize it in several ways. In this article, we will examine some of the ways in which you can customize the default datasheet.

Customization performed on the datasheet is not immediately saved; it is only when you close the datasheet or switch to another view that you will be prompted to save your changes. Naturally, however, you can manually save your changes at any time by clicking the Save button on the Quick Access Toolbar.

Changing the widths of your columns is one simple form of customization; this is done by dragging the dividing lines between the column headings on the first row of the datasheet. As in Microsoft Excel, double-clicking this dividing line will automatically resize the column so it is just wide enough to display the longest piece of data in that column.

You can also customize the order of columns and hide any columns that are not used for data entry or that you do not need to view. To move a column, click on the column header to highlight the entire column then drag the highlighted column to the left or right. A bold vertical line is displayed, as you drag, to indicate the new position of the column. To hide a column, highlight the column then right-click the highlighted column and choose Hide Columns from the Context menu which pops up.

If you are working on a table with a lot of columns, there will be time when you need to scroll to the left or right. As you do so, some of the columns will disappear. One useful way of getting round this problem is to rearrange the order of columns so that the most important one appear on the left and then to freeze these columns, so that key information is always visible. To freeze a column, simply highlight it then right-click and choose Freeze Columns.

Another useful feature is the ability to customize the format of the datasheet using the options in the Font section of the Home Tab of the Microsoft Access Ribbon. You can show and hide gridlines, set background colours and alternating background colours, change the font and font size. Any changes you make will always affect the entire datasheet. If your eyesight is not too good, one simple change you may find is to simply click on the Bold button.

The changes that you make to a datasheet will normally apply only to the active table. If you find useful ways of customizing the datasheet, you will naturally want to apply then to several sheets. This can be achieved by making the formatting changes using your Microsoft Access Options rather than the Ribbon. To do this, choose Access Options from the Office Button; click on the Datasheet category on the left of the dialog then set the font and cell background options you would like for all of your datasheets.
Article Source: Articlelogy.com
- Credit Cards A big selection of Cards in all flavors: Bad Credit Cards, Secured Cards, Prepaid Cards, Credit Cards for Canada, Low Interest Cards, etc -


Word Count: 565




Reduce Your Debts Without Bankruptcy. See How Much You Can Save. Free Debt Analysis



Read Previous Article ~ Read Next Article
 


Selected Articles

1: Public Car Insurance in Canada
2: Monthly Car Insurance
3: Why Compare Vehicle Insurance Quotes
4: Way to Get your Unique iPhone Apps Developed
5: Why Do I Need to Attend a Fitness Resort?
6: Contact Lenses Online: Convenient, Less Time Absorbing, Order On The Spot
7: Want Assist With Internet Marketing? Try These Suggestions
8: The Foam Filled Chairs Are Perfect Items of Furnishings
9: People clinging to their content sending dcma requests
10: The Enormous Bean Bag is low priced along with a top quality item of furniture
11: Tips on how to Handle Cholesterol Levels to be Healthful
12: A good solid Global One Ultimate Power Profits Paradigm Shift Platinum Superbly Inspection
13: Car Maintenance: Much better Than Auto Repair St. Louis Case
14: Choosing B&b Hartbeespoort Dam
15: Melaleuca- An Impartial Review- So is this a Melaleuca Scam or can you honestly generate income with this business?
16: Los Ciclos Grado Medio en Catalunya interesan a los estudiantes
17: Tips To Start Successfully Marketing On the web Today
18: Prescription Assistance Programs, Goal and Rewards
19: Way to Find an Efficient SEO Service Provider
20: Joomla Development for your Website
21: Website Design Graphics for Niche Businesses
22: Recycling Help in Keeping our Environment Thoroughly clean
23: Nashville Recycling Info for the Folks of Nashville
24: Personal computer Restoration - Suggestions for Locating a Dependable provider at Waukesha
25: Would like To order Tunes On-line?
26: Viviane Skincare- A Completely Independent Assessment By an Expert
27: Dallas Texas HCG Diet plan Protocol
28: HCG Diet Protocol, it genuinely Succeeds
29: The Functions for Charter Jets
30: Try Out the Well known Athlete's Alfredo with Homemade Alfredo Sauce recipe
31: The Broccoli Cheddar Spinach Soup Recipe Is easy To Actualize
32: Technology Consulting Overview
33: Join the opportunity Get Pre-launch Immediately And Tie down Your Place
34: Beneficial Suggestions For Achieving Article Marketing Results
35: Why should you opt for promotional pens?
36: Types of stress relievers to keep you hale and healthy
37: Mistakes to avoid while choosing novelty pens


Read Previous Article ~ Read Next Article

You are Here: Articlelogy.com » Computers » Databases » Access 2007 Datasheets Can Be Fully Customized