Microsoft Access Tutorial Advanced
Short Description
Microsoft Access Tutorial: Advanced. Part 1: Create Database … the Files of type drop down box, select Microsoft Excel (*.xls) in order to see the file. …
Website: library.med.utah.edu | Filesize: 378kb
Content
9/12/06 1
Microsoft Access Tutorial: Advanced
Part 1: Create Database
1. Start MS Access
From the Start menu click on
> Programs
> Microsoft Office
> Microsoft
Access 2003
2. Note the Getting Started task pane on
the right side of your screen.
3. Click on Create a new file.
4. The New File task pane will appear. Under New, click on Blank
Database.
5. Name the database contact_management and choose Desktop as the location. Click the
Create button.
A. Create Table in Design View
1. The contact_management : Database window
opens. Double click the Create table in design
view item. The Table1 : Table opens.
2. Begin entering field names starting with Call_ID.
Click in the Data Type box and from the pull down
menu select AutoNumber.
3. Click the Primary Key button on the Table Design toolbar. Each table MUST have a Primary
Key.
4. A Foreign Key field must be included to establish a relationship. A foreign key field is a
primary key taken from a foreign table (for example, the customer_ID field from the
Customers table would establish the relationship between the Customers table and the Calls
table). Give…
Get the file Download here
Related Searches: excel xls, microsoft access 2003, access tutorial, library med, blank database
Comments
Leave a Reply
