啊哦 (3)
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
• An easy way to do this is in Layout View.
Animation: Right-click, and click Play.
• In Layout View, you can drag a field from the Field List pane to your form. You can also move the new field to where you want it by clicking and dragging the field name.
• Click the Microsoft Office Button, and then click Save. • Now you’re ready to add that same field to a form.
Add a field to a form
• Once you have created a new field, you add the new field to a form.
View.
2
1
Tell Access where you want the new field by clicking a field heading to select it. Access will insert the new field to the left of the field you’ve selected.
Modify your database
• You’ve created a database from a template to track customers at a stationery store.
• The store owner is happy with it, but wants a few changes.
Add a field to a form
• Once you have created a new field, you add the new field to a form.
• An easy way to do this is in Layout View.
• In Layout View, you can drag a field from the Field List pane to your form, as shown in the picture. • You can also move the new field to where you want it by clicking and dragging the field name.
Back up your data
• Click the Microsoft Office Button , and then point to Manage to open the Manage this database submenu. From there, click Back Up Database.
• Change a column name in a database.
Course goals
• Add a column to a database table.
• Add new column to a form and change its title.
Lesson
Modify your database
• For the copy, Access adds the date to the existing database name, but you can change it • to any name. Likewise, Access stores the backup in the same
location where the original database is stored, but you can change it to any location.
Let Access do some of the work Access • Your
database is made up of tables, forms, reports and other parts that rely on each other.
• In this course, you’ll see how to make common modifications:
• Changing a field name
• Adding a field, and then including the new field in a form • Changing the title of a form
• If you make a change to a field name in a table, the other database parts that call on that field might not work as they did. • Access provides Name AutoCorrect options that help keep your database parts in sync.
Rename a field
• For the stationery store, you want to rename a field name from “Mobile Phone” to “Wireless Phone”.
• Changing a field name is a common modification you can make to any database table.
[Your company name] presents:
Microsoft Office ® Access 2007 Training
Easy Access with Templates II: Modify a database
®
• Overview: Change is at hand
• Lesson: Modify your database
• What do you do?
• It’s easy — you can make modifications to the database that you created from a template. This course walks you through a few common modifications.
Back up yoLeabharlann Baidur data
• Access makes it easy for you to modify a database. • But what if you make a change and then decide it’s not what you want?
• Although you can use the Undo command to reverse some changes, certain actions cannot be reversed. • That’s why it’s a good idea to back up the database.
Rename a field
• But right now, you have the “Contact List” form open.
• Once you’ve made the change, you know that Access has made changes to the reports and forms that use this field because you know that the Name AutoCorrect Options are on. • Now we’re ready to add an entire new field to a table.
Add a field to a table
• Now, you’re ready to add a new field for Mr., Ms., Mrs., and other honorifics.
• You’ll begin at the Contacts table, which is already open. On the Home tab, click View, and then click Datasheet
Rename a field
• But right now, you have the “Contact List” form open.
• Before you rename your field name, you must open the Contacts table by using the Navigation Pane. • Then you must close all the other forms and reports that may be open. Finally, you select the field name and type in the new name.
• When you back up a database, Access saves the database and then saves a copy of the database file.
Back up your data
• Click the Microsoft Office Button , and then point to Manage to open the Manage this database submenu. From there, click Back Up Database.
3 4
Click the Datasheet tab.
Click Insert, then type the field name by double-clicking the field name and typing “Title”.
Add a field to a table
• Because you changed an underlying structure of a table, you need to save this change.
Add a field to a table
• Now, you’re ready to add a new field for Mr., Ms., Mrs., and other honorifics.
• You’ll begin at the Contacts table, which is already open.
Course contents
保险超市 www.zhongmin.cn
•The lesson includes a list of suggested tasks and a set of test questions.
Overview: Change is at hand
• You’ve just created a new database using a template, but you’ve decided that the database needs a few modifications.
Let Access do some of the work of the time • Most
these options are already checked, but it’s a good idea to confirm it by checking that the Name AutoCorrect Options are on. • Click the Microsoft Office Button, and then click Access Options. • In the options for Current Database, scroll down to the Name AutoCorrect Options and make sure that there are checkmarks next to Track name AutoCorrect info and Perform name AutoCorrect.
Animation: Right-click, and click Play.
• In Layout View, you can drag a field from the Field List pane to your form. You can also move the new field to where you want it by clicking and dragging the field name.
• Click the Microsoft Office Button, and then click Save. • Now you’re ready to add that same field to a form.
Add a field to a form
• Once you have created a new field, you add the new field to a form.
View.
2
1
Tell Access where you want the new field by clicking a field heading to select it. Access will insert the new field to the left of the field you’ve selected.
Modify your database
• You’ve created a database from a template to track customers at a stationery store.
• The store owner is happy with it, but wants a few changes.
Add a field to a form
• Once you have created a new field, you add the new field to a form.
• An easy way to do this is in Layout View.
• In Layout View, you can drag a field from the Field List pane to your form, as shown in the picture. • You can also move the new field to where you want it by clicking and dragging the field name.
Back up your data
• Click the Microsoft Office Button , and then point to Manage to open the Manage this database submenu. From there, click Back Up Database.
• Change a column name in a database.
Course goals
• Add a column to a database table.
• Add new column to a form and change its title.
Lesson
Modify your database
• For the copy, Access adds the date to the existing database name, but you can change it • to any name. Likewise, Access stores the backup in the same
location where the original database is stored, but you can change it to any location.
Let Access do some of the work Access • Your
database is made up of tables, forms, reports and other parts that rely on each other.
• In this course, you’ll see how to make common modifications:
• Changing a field name
• Adding a field, and then including the new field in a form • Changing the title of a form
• If you make a change to a field name in a table, the other database parts that call on that field might not work as they did. • Access provides Name AutoCorrect options that help keep your database parts in sync.
Rename a field
• For the stationery store, you want to rename a field name from “Mobile Phone” to “Wireless Phone”.
• Changing a field name is a common modification you can make to any database table.
[Your company name] presents:
Microsoft Office ® Access 2007 Training
Easy Access with Templates II: Modify a database
®
• Overview: Change is at hand
• Lesson: Modify your database
• What do you do?
• It’s easy — you can make modifications to the database that you created from a template. This course walks you through a few common modifications.
Back up yoLeabharlann Baidur data
• Access makes it easy for you to modify a database. • But what if you make a change and then decide it’s not what you want?
• Although you can use the Undo command to reverse some changes, certain actions cannot be reversed. • That’s why it’s a good idea to back up the database.
Rename a field
• But right now, you have the “Contact List” form open.
• Once you’ve made the change, you know that Access has made changes to the reports and forms that use this field because you know that the Name AutoCorrect Options are on. • Now we’re ready to add an entire new field to a table.
Add a field to a table
• Now, you’re ready to add a new field for Mr., Ms., Mrs., and other honorifics.
• You’ll begin at the Contacts table, which is already open. On the Home tab, click View, and then click Datasheet
Rename a field
• But right now, you have the “Contact List” form open.
• Before you rename your field name, you must open the Contacts table by using the Navigation Pane. • Then you must close all the other forms and reports that may be open. Finally, you select the field name and type in the new name.
• When you back up a database, Access saves the database and then saves a copy of the database file.
Back up your data
• Click the Microsoft Office Button , and then point to Manage to open the Manage this database submenu. From there, click Back Up Database.
3 4
Click the Datasheet tab.
Click Insert, then type the field name by double-clicking the field name and typing “Title”.
Add a field to a table
• Because you changed an underlying structure of a table, you need to save this change.
Add a field to a table
• Now, you’re ready to add a new field for Mr., Ms., Mrs., and other honorifics.
• You’ll begin at the Contacts table, which is already open.
Course contents
保险超市 www.zhongmin.cn
•The lesson includes a list of suggested tasks and a set of test questions.
Overview: Change is at hand
• You’ve just created a new database using a template, but you’ve decided that the database needs a few modifications.
Let Access do some of the work of the time • Most
these options are already checked, but it’s a good idea to confirm it by checking that the Name AutoCorrect Options are on. • Click the Microsoft Office Button, and then click Access Options. • In the options for Current Database, scroll down to the Name AutoCorrect Options and make sure that there are checkmarks next to Track name AutoCorrect info and Perform name AutoCorrect.