Microsoft Office Tutorials and References
In Depth Information
Designing Custom Web Apps
Just like its desktop counterpart, a Custom Web App stores data in tables.
These tables are stored in SQL Server or SQL Azure via the connection made
with SharePoint 2013. Creating tables in an app is similar to creating tables
in an .accdb file.
For more information on designing tables, using the various field types and
properties, and editing data, see Book II.
Adding a table from a template
The easiest way to add a table to your app is to create one by using a
template. Access offers a few templates for various types of information. You
can add tables to store information for people, orders, vendors, issues, and
many other items.
To add a table from an existing template, follow these steps:
1. Click the Table button in the Create group on the Home tab of the
The Add Tables tab appears, listing the name of the app as the tab’s title
(refer to Figure 3-9, earlier in this chapter).
2. In the search box, enter the type of information you’d like to track.
Access displays a list of templates that match the information you’re
3. Select the template that you want to add to your app.
Access adds the table to your app, along with associated views (forms).
These objects appear in the Navigation Pane. Access also adds a pane to
the Add Tables tab that shows the table’s name with a star to the left.
4. On the Add Tables tab, click the table name to display the different
views (see Figure 3-10).
In the example shown in Figure 3-10, Access created the Contacts table,
along with Contacts List view, Contacts Datasheet view, and By Group
view. Click the view buttons to see the different views.
When you’re working with apps, Access displays a lot of information onscreen.
You may have to show or hide the Navigation Pane and use the scroll bars to
see all the available options — or buy yourself a gigantic monitor.