啊哦 (3)

[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
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.3 4Click th 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.
• 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
• 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.
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.
• 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
Course contents
保险超市
•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.
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.
• 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.
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.
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.
• 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.
• 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.
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
• 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.
• 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.