Extend Microsoft Access Applications to the Cloud: Creating a Blank Web App and Using Templates
- 2/9/2015
Editing the design of a table
When viewing the Table Selector, you can choose from one of two methods to quickly switch a table into design view to change the table structure. You can double-click on the table caption in the Table Selector. Or you can click once on the table caption, either right-click on the table or directly click on the Settings/Actions charm, and then choose Edit Table, as shown in Figure 4-8. You could also display the navigation pane and double-click or right-click on a table.
)
FIGURE 4-8 Opening a table in Design view.
WARNING
Don’t click on the large edit button in the center of the screen because that is for editing the view that is displayed in the design preview on the screen, and in this situation we want to change the design of the table and not alter a view layout.
Make the following name changes to the primary and foreign keys in the tables, and save your changes.
TABLE 4-1 Changes for the primary and foreign keys
Table Name |
Old Field Name |
New Field Name |
Orders |
ID |
OrderID |
Customer (Lookup) |
CustomerID |
|
Employee (Lookup) |
EmployeeID |
|
Customers |
ID |
CustomerID |
Employees |
ID |
EmployeeID |
Products |
ID |
ProductID |
Supplier (Lookup) |
SupplierID |
|
Category (Lookup) |
CategoryID |
|
Suppliers |
ID |
SupplierID |
Categories |
ID |
CategoryID |
Order Details |
ID |
OrderDetailsID |
Product (Lookup) |
ProductID |
|
Order (Lookup) |
OrderID |
As you are going through this, you can also change the captions on the foreign keys and primary keys—for example, change ProductID to Product. That has not been done for the example used in this chapter.
If you look at Figure 4-9, you will see how the web app has altered all views to reflect the changes you made to the field names—in this case, OrderID and ProductID in the Order Details table.
)
FIGURE 4-9 Automatic updates to the design of the quickly created views.
TIP
As long as you have not edited any of the quickly created views, any changes to elements in the table will be automatically reflected in the views (which have not been edited). This means that making any significant structural changes before starting to work on view design will save you design effort.