《数据库管理系统》教案-第三章.pptVIP

第三章 创建 Access 数据库和表Chapter 3 Creating database tables in AccessIn This ChapterCreating a database 创建数据库Creating a table 创建表 Entering field names and descriptions 定义字段名称 Selecting a field datatype 选择字段数据类型Entering field properties 定义字段属性Changing a table design 修改表设计Creating a primary key 创建主关键字Creating Relationships 创建关联 Building a New TableThere are several ways to add a new table to an Access 2003 database: You can use a wizard to help you with the design process, design the table from scratch, build the table from a datasheet (a spreadsheet-like format), import the table from another source, or link to an external table. This hour discusses the processes of building a table from a datasheet and designing a table from scratch; Hour 6, Using Wizards to Create a Database, covers the process of using a wizard to help with the design process, and Hour 18, Sharing Data with Other Applications, covers the processes of importing and linking. Regardless of which method you choose, you should start building a new table by selecting the Tables icon from the list of objects in the Database window. The icons that appear allow you to create a table in Design view, create a table using a wizard, and create a table by entering data (see Figure 3-15). Entering /Understanding Field Properties After you enter the field names, data types, and field descriptions, you may want to go back and further define each field. Every field has properties, and these are different for each data type. In the Products table, you must enter properties for several data types. Figure 3-27 shows the property area for the field named ProductID; five options are available. Figure 3-27 Property area for the AutoNumber field- named ProductID Here is a list