office系列教程之2013最新更新 (11)

[Your company name] presents: Microsoft ®Office Access ®2007 TrainingBuild a database II:Create tables for a newAccess databaseCourse contents •Overview: Build tables, and the data will come•Lesson: Create your tables保险超市•The lesson includes a list of suggested tasks and a set of test questions.Overview: Build tables, and thedata bill come•You’re creating a databasebecause the spreadsheet you’vebeen using is too big to manage.This course explains how to buildthe tables for your new database.•Why tables? They’re the centralcomponent of your database.Without them, you can’t storedata.•If you’re feeling intimidated,relax. We assume you’re abeginner.Course goals•Create a table in Datasheet view.•Set data types for the fields in the table.•Create a table by using a table template.•Create a table in Design view, and set the primary key for the table.•Create a lookup field —a field that provides a list of choices.•Use Design view to change the values in an existing lookup field.Lesson Create your tables•In a relationaldatabase, tablesstore your data.•Your data doesn’t “live” anywhere else,and that makes tables the centralcomponent of your database.•If you don’t have tables, you don’t havea database.•Access gives you several ways tocreate tables, andthis course showsyou how to usethree of them.1 2In Datasheet view, you build a table by entering fieldnames and setting data types manually. All you have todo is click and type.Table templates are pre-made tables that meet severalcommon business needs.•They areDatasheet view,table templates,and Design view.•Access gives you several ways to create tables, and this course shows you how to use three of them. 3Design view lets you control every field and property inthe table. In this course, you’ll learn how to create atable and to change the values in a lookup field —a fieldthat contains a list of choices.•They are Datasheet view, table templates, and Design view.•Datasheet viewprovides a visualway to create atable.•The picture shows the process.1 2You start by creating a new, blank database or by adding a new table to an existing database.The new table opens automatically in Datasheet view. Notice how the new table contains a field called ID. That’s your primary key, so you don’t need to create one.•Datasheet viewprovides a visualway to create atable.•The picture showsthe process.3To add your fields, double-click the first field header andenter the name for the field. When you finish, press ENTER.4Go to the next blank field and enter a name in thatheader. Repeat the process until you’ve entered namesfor all your fields, but with a couple exceptions: don’t addany lookup fields, and don’t add foreign key fields.Create a table in Datasheet view•Datasheet viewprovides a visualway to create atable.•The picture showsthe process.5When you’ve finished, go to the Quick Access Toolbarand click Save. In the Save As dialog box, enter a namefor the table and click OK .•After you enter field names,you’ll need toset the data typefor each field.•Data typescontrol what youcan enter into afield.12 3Select the field that needs a data type. Just click the field header.If it isn’t already selected, click the Datasheet tab.In the Data Type & Formatting group, open the Data Type list and select an option.•After you enterfield names,you’ll need toset the data typefor each field.•Data typescontrol what youcan enter into afield.•If you’re unsure about which data type tochoose, look at your field names.•If you’re unsure about which type to select,stay with the Text data type because it’sthe most flexible.Create a table using a table template•Table templatesare a fast way tobuild a new table.The templatescapture data forcommon businessneeds, and all thefields and datatypes are set upfor you.1 2Click the Create tab.In the Tables group, click Table Templates, and then click the template you want to use.•Design viewallows you tobuild a table fromscratch and set orchange everyavailable propertyfor each field.1 2On the Create tab, in the Tables group, click Table Design.In the Field Name column of the designer, enter the names of your table fields. As a rule, the first field you create should be your primary key field.•Design viewallows you tobuild a table fromscratch and set orchange everyavailable propertyfor each field.3In the Data Type column, use the list next to a fieldname to choose a data type for that field.4Optionally, use the Field Properties pane to setproperties for individual fields.•The first course inthis seriesmentioned thatyou cansometimes use alookup fieldinstead of a table.•Lookup fields can store a list of optionsinternally, or they can look up data fromfields in other tables.•These stepsexplain how tocreate a lookupfield that storesoptions internally,in what Accesscalls a value list.1 2Switch your table to Datasheet view. You can do that by right-clicking the tab for the table and clicking Datasheet view.Click the Datasheet tab, and in the Fields & Columns group, click Lookup Column to start the Lookup Wizard.•These stepsexplain how tocreate a lookupfield that storesoptions internally,in what Accesscalls a value list.3On the first page of the wizard, click I will type in thevalues that I want and click Next.4On the next page of the wizard, make sure the Numberof columns box contains a 1and then enter youroptions in the grid, one option per row.•These stepsexplain how tocreate a lookupfield that storesoptions internally,in what Accesscalls a value list. 5On the third page of the wizard, enter a name for thenew field and click Finish .Suggestions for practice1.Create a table in Datasheet view.2.Create a table using a template.3.Create a table using Design view.4.Create and then alter a lookup field in Datasheet view. •Online practice(requires Access 2007)Test question 1•When you create a new table in Datasheet view, you must define a primary key field. (Pick one answer.)1.True.2.False.Test question 1: Answer •False.•The “ID” field in the new table acts as the primary key. You can change the field name, or replace the field with another primary key, but a new datasheet always contains a primary key.Test question 2•You can’t use the Lookup Wizard to alter an existing value list. (Pick one answer.)1.True.2.False.Test question 2: Answer •True.•You use Design view to alter a value list.Test question 3•When you use a template to create a table, you must set data types for the fields in the new table. (Pick one answer.)1.True.2.False.Test question 3: Answer •False.•You can change the data types if you need to, but they’re set for you.Quick Reference Card •For a summary of the tasks covered in this course, view the Quick Reference Card.•。