1 / 18

Lab 6 – Intro To MS Access

Lab 6 – Intro To MS Access. MBAC 611. Creating A New Database. Start Microsoft Access 2010. We want to create a new database. By default Access assumes you want to create a new database. Note that i s selected by default – if not, select it with the mouse.

molimo
Download Presentation

Lab 6 – Intro To MS Access

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lab 6 – Intro To MS Access MBAC 611

  2. Creating A New Database Start Microsoft Access 2010. We want to create a new database. By default Access assumes you want to create a new database. Note that is selected by default – if not, select it with the mouse.

  3. Verify that is selected.

  4. We want to make sure that your database is saved in your private network directory. Click on the icon and then select your private network folder. Enter Lab6 into the File Name textbox.

  5. Click on the icon that appears on the right-hand side of the screen. You should now see the following Access screen:

  6. Creating A Table When you create a new database Access creates a default table name Table1

  7. We are going to rename and redesign Table1. Right-Click on Table1. Select

  8. We will rename the table to Customer. Click .

  9. Table Description Every field has a name and data type. Note that field names should not contain a space or tab character. It is allowed in Access but may complicate SQL programming. However, the underscore character (_) is allowed – this is good to separate words.

  10. We will rename the first field to Cust_ID. We will change the Data Type to Number. Note that the AutoNumber data type is not the same as Number. AutoNumber produces sequential numbers – for this database we will want more flexibility.

  11. Complete the table description as described below. Note that Cust_ID has a key next to it – it is the primary key. If the key is not there you can right-click on the field and select it.

  12. We are done defining the table. Save the table by right-clicking on the Customer tab and select . Close the table description by right-clicking on Customer and selecting

  13. Purchase Table We need to create the Purchase Table. Click on the tab. Click on the icon. A new table – named Table1 should appear.

  14. Complete the table field information as follows: Before saving the table we should designate a primary key. This primary key is made up of three fields Cust_ID, Item_ID and Purchase_Date. Click on Cust_ID then hold down the shift_key and select the Item_ID field and then the Purchase_Date field. Now press the icon.

  15. Your table description should look like this: Right-Click on the Table1 tab and select When the Save As dialog-box appears enter the table name as Purchase.

  16. Close the Purchase table by right-clicking on the Purchase tab and select We now need to create the Item table.

  17. Item Table Create the Item Table. Below are the field descriptions. Make Item_ID the Primary Key. Save the table with the name Item. Close the table.

  18. Exit Access Verify that everything has been saved. This is indicated when the disk-icon in the upper left hand corner is dark gray in color . To Exit select the tab and then select . You don’t need to submit this lab.

More Related