Access Lesson 2 Making a Database.

Access Lesson 2 Making a Database Microsoft Office 2007: Early on Targets Make a database. Outline, make, and spare a table in Datasheet view. Set a field's information sort in Datasheet view. Include, erase, rename, and move fields in Configuration view. Set field properties in Configuration view.

Creating a Database The initial phase in making a database is to make the document that will hold the database objects. You can utilize a layout that as of now has objects in it. You can likewise utilize a Blank Database format without any items in it. Microsoft Office 2007: Introductory

Slide 6

Creating a Database (proceeded) To make a database, begin Access. On the Getting Started with Microsoft Access page, double tap the layout you need to utilize. Indicate a document name and capacity area. Snap Create to make the new database and open it in Access. Microsoft Office 2007: Introductory

Slide 7

Creating and Saving a Table When you make a clear database, Access makes the first table and names it Table1 . You can change the name when you spare it. To spare, tap the Save catch on the Quick Access Toolbar. Fill in the name in the Save As dialog box. The new table name shows up on the tab for the table and as an article in the Navigation Pane. Microsoft Office 2007: Introductory

Slide 8

Designing a Table After making a table, you have to advise Access what fields to incorporate. Access makes one field named ID and sets it as the essential key. An essential key is the field that contains an one of a kind field esteem for every record. In a few tables, this field is called AutoNumber in light of the fact that it naturally includes an one of a kind number. Microsoft Office 2007: Introductory

Slide 9

Designing a Table (proceeded with) You can tell that Access made an AutoNumber for the ID field on account of the word New in the first recordâs field. Great contender for being an essential key are Employee numbers Social security numbers Student ID numbers The benefit of setting an essential key is that Access won\'t give you a chance to enter copy values for this field in distinctive records. Microsoft Office 2007: Introductory

Slide 10

Designing a Table (proceeded) To enter a field name in Datasheet perspective, double tap the âAdd New Fieldâ field selector. After you have made every one of the fields, you can enter the first record. Access doles out an information sort as you enter information (Text, Memo, Number, and so forth.). You can change the information sort for a field by tapping the Data Type bolt in the Data Type & Formatting gathering on the Table Tools Datasheet tab. Microsoft Office 2007: Introductory

Slide 11

Working in Design View In Design view you can include, erase, and roll out improvements to how fields store information. The field names and information sorts show up in the upper half in an outline matrix. The Field Properties sheet shows up beneath. A chose field turns orange. The essential key has a key image in it. Microsoft Office 2007: Introductory

Slide 12

Working in Design View (proceeded with) You can utilize the alternatives in the Tool bunch on the Table Tools Design tab to: Add and erase fields, embed a field Drag fields in the outline matrix to another area Rename a field, and change a fieldâs information sort The Description property in the configuration framework is discretionary, and you can utilize it to portray what to enter in the field. Any progressions made in Design perspective are naturally upgraded in Datasheet view when you spare the table. Microsoft Office 2007: Introductory

Slide 13

Changing Field Properties in Design View A field property portrays the fieldâs substance past the fieldâs fundamental information sort, for example, Indicating number of characters permitted Indicating admissible qualities Field properties will differ contingent upon the fieldâs information sort. The Field Size property sets the quantity of characters you can store in a Text, Number or AutoNumber field. There is a variety of Field Size property choices including the capacity to store decimals, positive numbers, negative numbers, or entire numbers. Microsoft Office 2007: Introductory

Slide 14

Changing Field Properties in Design View (proceeded with) Use the Format property to indicate how you need Access to show numbers, dates, times and content. For instance, in the event that you enter the date 10-28-10, Access will show it as October 28, 2010, if the Format property is set that way. The Default Value property enters the same field esteem in a field each time another record is added to a table. The Required property determines whether you must enter a field esteem in a record. Microsoft Office 2007: Introductory

Slide 15

Summary Creating a database makes a record that will store database objects. You can make a database utilizing a layout or a Blank Database format. You can make a table in Datasheet view by entering the field names, and after that entering the first record. Access allots the information sort as you enter information. Get to additionally makes an ID field to serve as the tableâs essential key. The essential key is the field that contains one of a kind field values for each record in a table. Microsoft Office 2007: Introductory

Slide 16

Summary (proceeded) To spare a table, tap the Save catch on the Quick Access Toolbar. A fieldâs information sort decides the kind of information that can be entered, including content, numbers, or a blend of both. The information sorts for Access are Text, Memo, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Attachment and Lookup Wizard. Microsoft Office 2007: Introductory

Slide 17

Summary (proceeded) In Design view you can include, erase and rename fields. A field property depicts a field past the information sort. The properties you can set rely on upon the information sort. Extra properties include: Description property portrays the Field Size property sets # of characters/numbers Format property sets organizing (i.e. date organization) Required property is utilized when a field must contain information Microsoft Office 2007: Introducto