Home > Sample chapters

Extend Microsoft Access Applications to the Cloud: Creating a Blank Web App and Using Templates

Summary

In Chapter 3, I focused on dealing with converting an existing desktop data. In this chapter, I described the alternative scenario, where you need to create new table structures or alter the design of imported table structures.

You started by creating a blank database and then adding tables using the built-in table templates. You used this great new feature to add individual tables or sets of tables to either a new or existing web app.

This chapter also demonstrated the essential skills you need to do the following:

  • Create a blank new table.
  • Edit the design of an existing table.
  • Create lookups and relationships.
  • Add indexing to improve performance.
  • Add validation rules.
  • Define calculated fields.

Now that you understand both how to manage the importing of data from existing databases and the creation of new database structures, you can move forward in Chapter 5, “Displaying data with views.” In that chapter, you develop an understanding of how to customize the basic UI interface displayed when new tables are created or imported into a web app.