Access 2010 offers many new features and improvements. The improved integration with SharePoint Server 2010 via Access Services allows for Access 2010 databases to be published to SharePoint, which enables multiple users to interact with the database application from any standards-compliant Web browser. This Visual How To shows how to create an Access 2010 Web database and publish it to Access Services on SharePoint Server 2010. This Visual How To shows how to create an Access 2010 Web database, publish the database to SharePoint Server 2010, and use the new Web interface to work with the database solution via the Web browser. Creating an Access 2010 Web Database This Visual How To shows Web database publishing and usage instead of showing how to create a complex solution that uses all the new features in Access 2010. The following procedure describes how to create an Access 2010 Web database. To create an Access 2010 Web database. Field Name Field Type Supplier Name Text • Save the changes to the table and set its name to Suppliers when you are prompted. • Add a Web form to the database that will allow for data to be entered into the Suppliers table one row at a time. Select the Create tab on the ribbon and then click Form in the Forms ribbon group. Access will create the new Web form for the Suppliers table. Using Microsoft Access with Web Database. In this article we had an overview of the 5 web database templates in SharePoint 2010. • Save the changes to the database. Access will prompt you for the new form name. Accept the default name 'Suppliers'. • Create a new table. Select the Create tab on the ribbon and then click the Table button in the Tables ribbon group. Add the following fields to the new table. Field Name Field Type Part Name Text Supplier Lookup & Relationship • When the Lookup & Relationship field type is specified, Access starts the Lookup Wizard to configure the field. ![]() ![]() ![]() In the first page of the Lookup Wizard, specify that the new field gets its values from another table and then click Next. • On the second page of the Lookup Wizard, select the Suppliers table as the source table for lookup values and then click Next. • On the third page of the Lookup Wizard, select the Supplier Name field as the source field for lookup values and then click Next. • On the fourth page of the Lookup Wizard, sort the lookup values displayed in the list in ascending order by Supplier Name and then click Next. • On the fifth page of the Lookup Wizard, click Name the New Field Supplier and then click Finish. Access will prompt you for the new table name. Name the new table Parts and then click OK. • Add a Web form to the database that will allow for data to be entered into the Parts table one row at a time. Select the Create tab on the ribbon and then click Form in the Forms ribbon group. Access creates the new Web form for the Parts table. Save the changes to the database and accept the default name of 'Parts' for the new Web form. • Add a form to the database that uses the Navigation control to enable navigation between forms. Select the Create tab on the ribbon and then click Navigation in the Forms ribbon group. Select the Horizontal Tabs item from the drop-down menu. Access creates a new navigation form with the Navigation control. Save the changes to the database. When prompted, accept the default name for the navigation form. • Add tabs to the Navigation control on the navigation form. Drag the Parts and Suppliers Web forms to the Navigation control on the navigation form. Save the changes to the database. • Configure the Navigation Form as the default Web form so that it will be displayed the first time that a user opens the Web database on Access Services. • Select the File tab on the ribbon and then Options in the left navigation pane. Access displays the Access Options form. Select the Current Database category and change the Web Display Form setting to the Navigation Form. Click OK to save the changes. The following procedure describes how to publish a database to SharePoint Server 2010. To publish a database to SharePoint Server 2010. The Backstage View • Click Publish to Access Services. The Access Services Overview pane will be displayed, offering options to check the database for Web compatibility and publish it to Access Services. The compatibility checker allows the database to be tested to verify that it has no items or settings that would make it incompatible with Access Services. In this case, because the sample database is based on the Web Database template and the solution is designed to be simple, skip this step. • In the Publish to Access Services section, specify the URL of the SharePoint site to publish the database to. Specify PartsAndSuppliers for the site name and then click Publish to Access Services. Publishing to Access Services • SharePoint prompts for connection credentials. Enter the name and password of a user who has permission to create new sites on the SharePoint Server and then click OK. Access processes the objects in the database and publishes it to SharePoint, synchronizing the local copy of the database that has the data stored on the server. When the database is published, Access displays a Publish Succeeded message that has a link to the new Web database application. • Click the link to the new site to open the Web application in the Web browser. Access Services displays the navigation form. Applies To: Access 2016 Access 2013 If you want to organize and manage your data with Access but just don't want to spend time creating a database from scratch, try using a desktop database template. To create an Access database for the web with a template, see. What is an Access template? An Access template is a file that, when opened, creates a complete database application. The database is ready to use, and contains all the tables, forms, reports, queries, macros, and relationships that you need to start working. Because the templates are designed to be complete end-to-end database solutions, they save you time and effort and enable you to start using your database right away. After creating a database by using a template, you can customize the database to better suit your needs, just as if you had built the database from scratch. Select a template Each template is designed to meet specific data management needs and you can either use one of the templates included with Access or find one online. Start with a template from your computer • On the Access startup screen, click Suggested searches: Access databases. Tip: Click a Category in the Filter by pane to templates filtered by specific categories. • Click an icon to select a template and enter a File Name. • To change the default database file location, click the folder icon next to the File Name > Create. Start with an online template If you are connected to the Internet, you can search for online templates: • On the Access startup screen, enter the type of template you want in the Search box. • Access shows you the available online templates. • Click the icon to select a template and add a File Name. • To change the default database file location, click the folder icon next to the File Name > Create. Before you start using some templates Depending on the template that you use, if you see any of the following messages, here’s what you do: If you see Do this SECURITY WARNING message in the message bar If you trust the source of the template, click Enable Content. Login dialog with an empty list of users • Click New User and fill in the User Details form. • Click Save & Close. • Select the user name you just entered, and click Login. Getting Started page Click links on that page to learn more about the database, or click other buttons and tabs to explore the database. Next steps • If you don't find a template that meets your needs, click New > Blank desktop database to create a new database from scratch. • Manage your database with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |