Access Tables. Creating a Table. Design View Define each field and its properties Data Sheet View Essentially spreadsheet Enter fields You must go to design view to set field properties the way you want them Templates(2k7 and earlier) Create table using predefined templates
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Enter Description for documentation purposes
Define additional Properties for each Field
In design view, Highlight field you want to be primary key and select Primary key symbol
Key symbol indicates that Field One and Field Twoare Primary keys
Enter name you want to Give your table here and click on OK
Sales Rep Table
Select database Tools tab and then select relationships
you will see a box similar to one on right. Select each table and click on add.
First, Click on SalespersonID