Microsoft Office Access 2003.


107 views
Uploaded on:
Description
Microsoft Office Access 2003. Instructional exercise 2 – Making And Keeping up A Database. Take in the rules for planning databases. At the point when planning a database, first attempt to think about every one of the fields of information that should be put away.
Transcripts
Slide 1

Microsoft Office Access 2003 Tutorial 2 – Creating And Maintaining A Database New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 2

Learn the rules for planning databases When outlining a database, first attempt to think about every one of the fields of information that should be put away. Next, gathering the fields into tables. Every table will contain a gathering of related fields. You have to choose a field in every table to turn into the essential key for that table. At the point when tables will be identified with each other, you have to incorporate a typical field in the two tables that will be utilized to frame the relationship. New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 3

Determining database fields New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 4

Group the fields into tables New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 5

Choose an essential key Choose a field or fields to serve as the essential key for the table. An essential key must remarkably distinguish every record in the table. Essential keys can comprise of more than one field. Essential keys with more than one field are called composite keys New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 6

Include a typical field When one table should be identified with another table, you must incorporate a typical field. The regular field will be the essential key in one table. The regular field is alluded to as an outside key in the related table. The remote key in a table can then be utilized as an essential key to get to the record in the related table. New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 7

Data excess squanders space and can prompt information slips New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 8

Setting field properties When doling out a name to any article in Access, deliberately select a name that will show what information is put away there. Field properties incorporate their information sort, field sizes, and a discretionary depiction of the field. At the point when selecting a field size, verify the size is sufficiently huge to hold the biggest bit of information that will be put away there. Try not to make the field bigger then fundamental on the grounds that this will bring about squandered circle space Make beyond any doubt the information sort you select for a field is proper for the sort of information to be put away in that field. New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 9

Access field sorts, slide 1 New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 10

Access field sorts, slide 2 New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 11

Create another database You can make another database by creating so as to utilize a Database Wizard or another, clear database. When you make another database, you should make every one of the tables, inquiries, structures, and reports for the database. This is the most adaptable methodology, since you will make all articles yourself New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 12

Create a database without utilizing the Database Wizard To make another, clear database without utilizing the Database Wizard: Start Access Click Blank Database in the undertaking sheet In the dialog box, explore to the area where you will spare your database\'s Enter the database name in the File name content box Click the Create catch New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 13

Create another table New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 14

Define fields, and determine a table\'s essential key When you make a table, you name the fields and characterize the properties for the fields. The table structure is set up and altered in Design View In Design View, you will characterize every field that will be incorporated in the table When every one of the fields have been characterized, you will then indicate which field(s) will be the essential key. The essential key is not compulsory, but rather it is a smart thought to allot one New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 15

The database Design View window New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 16

Choosing an essential key Click a line selector for the field you need to use as the essential key, and after that tap the Primary Key catch on the toolbar. Subsequent to tapping the Primary Key catch, a key image shows up in the line selector to demonstrate the key field. New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 17

Save the new table When the sum total of what fields have been characterized and properties have been set, you must spare the table structure: Click the Save catch on the Table Design toolbar Type the name you need to allot to the table into the Table Name content box of the Save As dialog box Click the OK catch to spare the table utilizing the predetermined name New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 18

Add records to a table utilizing Datasheet View Once the table has been made, you can then add records to the table utilizing Datasheet View. As you enter records, they will be submitted in the request in which you enter them. In any case, when you close the table and open it once more, the records will be requested by essential key request. The route bar at the base of the Datasheet perspective will demonstrate what number of records are in the table and what the present record is (i.e., the record on which your cursor as of now rests). You can travel through the fields in the table by squeezing the Tab key. Once your cursor is gotten off a record, that record is naturally saved money on your circle. New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 19

Datasheet View with 2 records included New Perspectives Microsoft Office Access 2003 Tutorial 2

Slide 20

Modify the structure of a table by erasing, moving, and including fields The structure of a table can be adjusted after it has been made. To erase a field, enter Design View, right-tap on the field, and after that snap Delete Rows on the drop down menu. To move a field, (you likewise do this in Design View) click on the field you need to move, keeping in mind holding your mouse traditional, move the field to the coveted area. To include a field in Design View, right-tap the field where you need to embed the new field and afterward snap Insert Rows on the dropdown menu. New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 21

Moving a field in Design View New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 22

Adding another field in Design View 2. Select Insert Rows from the easy route menu, and another, clear line will be embedded before the line you chose, as demonstrated as follows. 1. Right-tap the line selector for the field you need to embed the new field before - StartDate in this figure. 3. Enter the data for the new field. New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 23

Change field properties You can make extra adjustments to the structure of a table by changing the table\'s properties fields. For instance, on the off chance that you have a field that speaks to a money esteem yet you would prefer not to show dollar signs, you could change the arrangement to a standard organization In the Design View, you will discover a rundown of all configurations accessible to you. You can make a determination from the rundown of alternatives Each information sort has a different arrangement of choices accessible in the Field Properties bit of the Table Design Window Field properties are changed in the Design View window. New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 24

Changing field properties in Design View New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 25

Copy records from another Access database If the information you need in your database as of now exists in another Access database, you can duplicate the records from that database into your database. You can utilize slice and glue to do this: Open the database that contains the records you need to duplicate Select the records you need to duplicate and afterward press the Copy catch. This places the records onto the Windows clipboard Open the database to which you need to duplicate the records and open the wanted table to get the replicated records Place your cursor on the following accessible column in the table and press the Paste catch New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 26

Import a table from another Access database You can likewise import a whole table, including its structure, into another database. To import a database table: Click the File menu Point to Get External Data, and afterward Import Locate and select the database and the table you need to import This varies from the cut and glue system on the grounds that you really import the whole table, its structure, and its information. New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 27

The Import Objects dialog box New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 28

Copy and import contemplations If you decide to duplicate records starting with one table then onto the next, it is critical that you first confirm that the two tables have precisely the same structure. On the off chance that the two information structures contrast in any capacity, the duplicate will bring about a blunder When you import, you are importing a whole table, including its information and its structure. This is a decent approach to incorporate a table in your database that was already outlined in an alternate database New Perspectives on Microsoft Office Access 2003 Tutorial 2

Slide 29

Delete and change records Once records have been added to a table, they can be erased or adjusted: In Datasheet perspective, tap the column selector for the record(s) you need to erase and afterward tap the Delete Record catch on the toolbar To change or change a record: Place your cursor on the record and afterward on the field you need to change You can then alter the field\'s quality as you wish by writing in new information You can change from route mode to altering

Recommended
View more...