輝念了崔遍匈 >> 屓雰仇 >>

歪朕嗔繁嬖 (13)


汽似緩侃園辞銚井炎籾劔塀
[Your company name] presents:

Microsoft ?

Office Access 2007 Training

?

? Datasheets III: Make data easier to read by formatting columns and rows

? Overview: Data clarity

Course contents

弊浄峠岬 www.shijue518.com

? Lesson: Make your data easier to read

?The lesson includes a list of suggested tasks and a set of test questions.

Overview: Data clarity

? A datasheet is a grid of rows and columns that displays the information in your database tables. ? Access 2007 makes it easy and fast to organize and format your datasheets. You can move and hide columns, and change the look and feel of your data with just a few mouse clicks. ? Organizing and formatting data makes it easier to read and understand and can help the people who use your database get more done.

? Organize your data by moving, hiding, and resizing the columns in a datasheet.
? Make your data easier to read by formatting it ! changing the gridline style and background color, changing the format of the text, and resizing the rows in a datasheet.

Course goals

汽似緩侃園辞銚井炎籾劔塀

Lesson
? Make your data easier to read

Make your data easier to read

? Your coworkers like the database you¨ve created, but they have a complaint ! the data seems a bit disorganized.

? You learn that they don¨t need to see all the columns of data, and they¨d like some of those columns to be in a different order. What¨s more, they¨d like

Move columns
? You can move the columns in a datasheet whenever you need to organize your data.

? For instance, you may want to move a column to the left side of your datasheet so that it¨s always visible and easy to find.

Move columns
? You move one or more columns by dragging them; the picture shows the process.

1

To move a single column, just click the column header, then click the header again and drag the column to its new location. A vertical black line tells you where the column will go when you drop it.

Move columns
? You move one or more columns by dragging them; the picture shows the process.

2

To move several columns, click a column header, press SHIFT, click the headers of the other columns, and then drag the selected columns to their new location. Keep in mind that the columns must be next to each other.

Hide or show columns
? Now you need to hide the columns that users don¨t need to see. ? Hiding doesn¨t remove any data from your table, and you can restore hidden columns at any time.

1

To hide a column, click the column header and click Hide Columns. Or....

Hide or show columns
? Now you need to hide the columns that users don¨t need to see. ? Hiding doesn¨t remove any data from your table, and you can restore hidden columns at any time.

2

You can hide multiple columns, as long as they¨re next to each other. Click a column header, press SHIFT, select the other column headers you want to hide, then rightclick any of the selected headers and click Hide Columns.

Hide or show columns
? Now you need to hide the columns that users don¨t need to see. ? Hiding doesn¨t remove any data from your table, and you can restore hidden columns at any time.

3

To show hidden columns, right-click any column header and click Unhide Columns. That opens the Unhide Columns dialog box, where you...

4

Select the check box next to each column that you want to show, and then click Close.

Resize one or more columns
? If some of the fields in your datasheet contain a lot of text, some of that text may be cut off so that you can¨t see it all.

? When that happens, you can resize the column to make it more readable. ? You can resize one or more columns manually or

Resize one or more columns
? The figure shows the process.

1

To resize a single column, position the mouse pointer at the right edge of the column header until the pointer changes to a double-headed arrow , then drag the header.

Resize one or more columns
? The figure shows the process.

2

To resize more than one column, click a column header, press SHIFT, select the other column headers, and then drag any one of the selected headers.

3

When you use this technique, all the selected columns become the same width.

Change the text format
? Your coworkers like what you¨ve done, but remind you that the company uses a standard font and font size.

? No problem.

1

On the Home tab, in the Font group, click the arrow next to the font list and select a font. To change the font size, click the arrow next to the Font Size list and select a value. You can also enter a value manually.

2

Change the text format
? Your coworkers like what you¨ve done, but remind you that the company uses a standard font and font size.

? No problem.

3

To change the font style, click any combination of Bold, Italic, or Underline.

4

To change the font color, click the arrow next to the Font Color button, and then select a color from the palette.

Change row height
? After you change the font, you realize it¨s taller than the original type face. ? You can make the text easier to read by making the rows in your datasheets taller.
1

Point at the top or bottom edge of a record selector ! the box at the left edge of your datasheet ! until the pointer becomes a double-headed arrow . Then drag the record selector up or down.

Change row height
? After you change the font, you realize it¨s taller than the original type face. ? You can make the text easier to read by making the rows in your datasheets taller.
2

To restore the rows to their default height, right-click a record selector and click Row Height, and then...
In the Row Height dialog box, select Standard Height and click OK.

3

Hide gridlines, change the color of alternate rows
? The last thing your coworkers ask for is to make the data easier to scan. ? They suggest hiding vertical gridlines and changing the color of alternate rows.
1

To hide the gridlines, go to the Home tab, and in the Font group click the arrow next to the Gridlines button, and then click the style that you want to use.

Hide gridlines, change the color of alternate rows
? The last thing your coworkers ask for is to make the data easier to scan. ? They suggest hiding vertical gridlines and changing the color of alternate rows.
2

It¨s just as easy to set the background color for alternate rows. On the Home tab, in the Font group, click the arrow next to the Alternate Fill/Back Color button. Then select a color.

Hide gridlines, change the color of alternate rows
? The last thing your coworkers ask for is to make the data easier to scan. ? They suggest hiding vertical gridlines and changing the color of alternate rows.
3

You can see your results right away. Feel free to experiment with these settings. You can always undo them, and changing them won¨t hurt your data.

1.Move a column. 2.Hide columns.

Suggestions for practice

3.Show hidden columns. 4.Resize a column manually; resize multiple columns manually. 5.Format text. (requires Access 2007) ?Online practice

6.Change row height manually; set a specific row

? Automatic resizing changes the column width to show all the data in each field. (Pick one answer.)

Test question 1

1. True. 2. False.

? True.

Test question 1: Answer

? Automatic resizing shows the largest record in the column.

? How do you move a column? (Pick one answer.)

Test question 2

1. Click anywhere in the column and drag the column to its new location. 2. Click the column header, then click again and drag to the new location. 3. Click the left or right edge of the column and drag it to its new location.

? Click the column header, then click again and drag to the new location.

Test question 2: Answer

? You can only move a column by dragging and dropping the header.

? How do you hide a column? (Pick one answer.)

Test question 3

1. Select and right-click a cell, then click Hide Columns. 2. Click the column header, and on the Datasheet tab, in the Fields & Columns group, click Hide. 3. Right-click the column header and click Hide Columns.

? Right-click the column header and click Hide Columns.

Test question 3: Answer

? You can select one or more columns, as long as they¨re all next to each other.

? For a summary of the tasks covered in this course, view the Quick Reference Card. ?

Quick Reference Card


犢慘蔦:
歪朕嗔繁嬖(邪兆廣咄)!!及膨指 扮嚏と富溺
歪朕嗔繁嬖(邪兆廣咄)!!及膨指 扮嚏と富溺_晩囂僥楼_翌囂僥楼_縮圄廨曝。しぐれ しょうじょ 04 r嚏と 富溺 かっぱ 歪朕:弌さいから、r?´ 采湧:邦...
媼恙触(歪朕嗔繁嬖)_夕猟好待_畠宥購好待_互蛍好待_為業好待
媼恙触(歪朕嗔繁嬖) 装覚圃 10繁箝誓 2015-03-18 訟烏 和匯鐙 犢惺ヂ塒銅 , 互竣盾畜 ゞ彌劑嗔繁嬖〃屈肝圷茅隈 1680繁 , 歪晩嗔繁嬖劑講奕担幅雫...
歪朕嗔繁嬖-歪櫓腎(峺起)
歪朕嗔繁嬖-歪櫓腎(峺起)_咄赤_伏試俚椀 壙涙得勺|0繁堋響|0肝和墮|訟烏猟亀歪朕嗔繁嬖-歪櫓腎(峺起)_咄赤_伏試俚椀。歪朕嗔繁嬖-歪櫓腎(峺起),耳麿惇。...
強只悳潤及匯湿
13 鹿 ゞ隆栖晩芝〃 ゞ隆栖晩芝 REDIAL〃 X ゞ亟寔溺嗔〃 強鮫崙恬:MADHOUSE 鹿 ゞ歪朕嗔繁嬖〃 ゞ歪朕嗔繁嬖 及屈湿〃(嗽兆偬歪朕嗔繁嬖)歪朕嗔繁嬖 及...
何蛍晩云強只
恷嶮汚匂泳溺(She.The Ultimate Weapon) 13 鹿¥¥¥℃ 12.寔埖矛埖磁(Shin...(埋傍嗤曾何,徽音心嗤泣雛) 歪朕嗔繁嬖 紆薩議雑灼 科堝忽麗囂(讐議頁嶄忽...
20何除叱定栖峙誼匯心議強只_夕猟
4.恰弗 戻阻歪朕嗔繁嬖議三,祥匯協詭痃始続翳φ瞎参秦,匆頁載芦床議匯何...13.妾卯嗄老 嗽頁圧菜狼双議匯何?讐峰阻匯蛤瓜慧幟議繁宥狛寔糞議卯姆嗄老,...
強只賠汽
歪朕嗔繁嬖(13+13+13鹿厮頼潤) 得勺吉雫 A) 歪朕嗔繁嬖( 鹿厮頼潤) (得勺吉雫 ) 歪朕嗔繁嬖 鹿厮頼潤 ( 53.IS(12鹿厮頼潤) 得勺吉雫 S) ( 鹿厮頼潤...
2010~2014仟桑悳燕
歪朕嗔繁嬖 OVA 2014 定 2 埖 26 晩蒸註裡嘲富溺 Amazing Twins 2014 定 2 埖 13 晩勸措舞 OAD 2014 定 3 埖 12 晩眉才 OVA 2014 定 4 埖富溺嚥...
2011定畠定仟桑強鮫双燕_夕猟
歪朕嗔繁嬖 及眉湿‐畠 13 三/ 2011 定 7 埖 4 晩 酔義爺聞 Twin Angels ‐畠 12 三/ 2011 定 7 埖 4 晩 辧匏為栽 ‐畠 12 三/ 2011 定 7 ...
強只容呪(蛍吉雫)
(慌 13 鹿)A+ 101、奉來揖挫氏(慌 12 鹿)A+ 102、歪朕嗔繁嬖 1、2、3、4 湿(慌 52 鹿)S 103、雑蝕麗囂 HOME SWEET HOMEA 104、pretty rhythm 及...
厚謹犢惘蠻: