Question

Use the Web to search for different ways to share an Access database, such as the one for Colonial Adventure Tours, with others using the Internet. Be sure to note any specific hardware and software resources needed. Prepare a report with your recommendations for sharing the database. If you use information from the Web, use reputable sites. Do not plagiarize or copy from the Web.

Answer 1

Check the explanation

Step-by-step explanation:

There are certainly many ways through which we can access and share database. The different ways to share an access database are as follows:

1. By using Sharepoint site: To utilize the SharePoint you should have windows SharePoint services server enabled on your system. Sharepoint assists in making database accessing very convenient by using methods like linking to list and publishing a database.

2. By using database server: This technique split a database that the tables are stored on the network in which each user has a copy of an access database file. The database file comprises of tables which contain queries, reports, forms, and other database objects.

3. By using split database: This technique is utilized when a database server product or a SharePoint site is unavailable. The tables then gains access into one access file and everything goes to other access files.

4. Network Folder: In this technique database file is stored on a shared network device and users can use the file simultaneously.

Below is the table for necessary hardware and software:

Sharepoint database split Network

site server database Folder

Need for database server software?No Yes No No

Need for windows server? Yes No No No