Datasheet

612
9. Choose whether your new site will inherit permissions:
• Use same permissions as parent site: Choose this option if you want
the new site to inherit the permission structure from its parent site.
• Use unique permissions: Choose this option if you want to specify per-
missions for the new site.
After the site is created, you can not only manage the site permissions
through the browser interface, but also add and remove users and
groups to suit your needs.
10. From the Navigation Inheritance section, accept the default setting of
No so the new site won’t inherit the top link bar from the parent site.
Regardless of whether you select Yes or No for this setting, the top
link bar from the parent site doesn’t appear onscreen. Excluding the
top link bar from the Web database application pages reduces possible
user confusion because it helps give navigation a close resemblance
to the familiar navigational structure of the client application. (We’re
convinced that this behavior must be “a feature, not a bug!” It’s just too
convenient.) You can still use the Options➪Navigate Up command to get
back to the parent site.
11. Click Create.
Access Services creates the new Access Web database site ready
for use.
After your Web database is created, you’re free to start using the site as
desired. If you want to customize the site or give it additional functionality,
you can open it in the Access 2010 client locally. For example, you can add
forms and reports, rename tables and fields, and change the navigational
structure. When you’ve made your changes, simply save them and click the
Synchronize button to apply them to your SharePoint site. (For more about
the publishing and synchronization process, flip to the “Publishing to Access
Services” section of this chapter.)
Access Web Database Objects
When you’re creating a Web database application using the Access client, it
helps to familiarize yourself with the various objects and tools at your dis-
posal before you just start slinging electrons around. The creation of a typi-
cal Web database application includes one or more of the components we
present in the following sections.
Tables and Fields
When you create your Access Web database, you’re initially presented with
the Table Designer from which you can design the first table in your Web
database application.
Designing SharePoint-Compatible Access Databases
31_587164-bk04ch01.indd 61231_587164-bk04ch01.indd 612 9/30/10 8:09 PM9/30/10 8:09 PM