Database Reference
In-Depth Information
In Access web apps, relationships between tables are defined by using the Lookup
data type. Start by opening a table in Design view, and then do one of the following:
▪
To create a relationship, either add a new field or select an existing field, and then
set the data type to
Lookup
to start the
Lookup
wizard.
▪
To manage an existing relationship, select a field that has the
Lookup
data type,
and on the
Design
tool tab, click
Modify Lookups
to start the
Lookup
wizard.
2
The wizard guides you through the process of establishing the relationship. For in-
formation about using this wizard, see “Allowing only values in lists” in Chapter 6,
“Maintain data integrity.”
When you have created the structure for the web app in Access, you can preview it in
your web browser by clicking Launch App in the View group on the Home tab.
By default, you can view and edit the data in a table in either List view or Datasheet view.
To make the Access web app available to other users, simply share the web address
of the SharePoint site with them. When they launch the web app in their web browser,
they can view and manipulate its data by using the buttons on the Action bar (located
to the right of the Search box) to add, delete, edit, save, and cancel record edits. Their
changes are saved in the centrally stored SQL database.
TIP
If you need to make more extensive changes to the database, you can click the
Settings button in the upper-right corner of the web app and click Customize In
Access to open the database in Access 2013 on your local computer.