Solved

Creating simple data entry page in SharePoint

Posted on 2013-06-12
16
706 Views
Last Modified: 2013-06-17
Hi, can anyone please guide me and clarify if my understanding regarding SharePoint technology is correct in creating simple Task request form:

Creating the form lay out: using MS InfoPath
Create and use SharePoint Site (WSS 3.0) to govern who can access the page to create new request using the form above
Create the database using MS Access 2007 to collect and store all the data from the form above. The reason I chose MS Access is that the auto numbering feature.

is that possible or do I need to download SharePoint Designer freeware to do some ASP.Net programming ?
0
Comment
  • 6
  • 5
  • 4
  • +1
16 Comments
 
LVL 8

Assisted Solution

by:vaderj
vaderj earned 250 total points
ID: 39243252
If this is just something to collect data, you can create your form in InfoPath, attach each field to a custom list you create in SharePoint and if you want something to happen after the firm had been filled out you can create a work flow in the SharePoint GUI, in SharePoint designer, or in visual studio depending on your requirements.  What are your requirements btw?
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 200 total points
ID: 39243274
You can so everything you need out of the box without the need for access. A task list is a list and the entered data lives in SQL server along with the other data. The list will already have the sequential ID which can choose to show by alerting the list view. Although than access all your assumptions are correct
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 200 total points
ID: 39243277
If the out of the box task list does not suit then create a custom list and add your own columns to suit. Every list created in SP gets an automatically created add/view/edit form that you can leave as is or edit in infopath.
Once people add requests you can then use workflows to do "stuff"
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39243283
VaderJ: no I do not need a work flow, I just need a simple form to fill in the RFC so that everytime authorized users go to the Share Point site and then click on the new button, a new XML form is generated with autonumbering and the data is saved into MS Access Database.
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39243286
QPR: the reason that I need to save it into MS Access is that just for reporting purpose only, as I'm not sure how to generate the report later on down the track if the data is not saved to MS Access DB.

my understanding is that when the data from the list is typed in to the form correctly, once the user submit it, the data will reside in the MS access DB, and then at the end of the month I can export the data into Excel spreadsheet to generate graph from it for statistic reporting.
0
 
LVL 8

Assisted Solution

by:vaderj
vaderj earned 250 total points
ID: 39243287
Does it need to save to an access database? It might be easier to save it to a SharePoint list and then have your access database reference that SharePoint list. If you really need to use an access database, have you considered using an access web database?
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39243288
access web database ? is that feature comes as built in WSS 3.0 or Access 2007 ?
0
 
LVL 8

Assisted Solution

by:vaderj
vaderj earned 250 total points
ID: 39243291
Oh - no, probably not. I think you need office '10 and probably SharePoint Server as the access part is a service application. I have to ask: dear god, why access?
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39243297
well the reason that I need to have MS Access as the databse is for creating the report later on and easy export to Excel.

so is there any reason to not use MS Access in my case here ?
0
 
LVL 8

Assisted Solution

by:vaderj
vaderj earned 250 total points
ID: 39243305
Well, it all depends on how important reporting is to your company vs hope much the company has to spend.  My opinion is biased being that I have worked as a SharePoint support engineer for MS, a SharePoint consultant independently and for a couple consultancies, and now a SharePoint administrator for a large governmental organization - if your organization has the means, try to get to SharePoint server and your office software upgraded to 2010 - combined with SQL 08R2, the reporting features are SO much better once you get your infrastructure built. Not to mention, management becomes so much easier - WSS/MOSS is a pain.
But for your current situation, I think if you really need the form on SharePoint, InfoPath pointing to a list, with access referencing that list as needed is your best bet.  Alternatively, you can have your access db on a shared drive and create a new access form and table to collect the same info, cutting SharePoint out of the mix entirely - however access is slow and becomes unstable when your tables become large enough to start doing real analysis
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39243320
Wow, many thanks for the quick reply VaderJ: may I know what do you mean by " InfoPath pointing to a list, with access referencing that list as needed is your best bet"

Does that means I need to create DSN / ODBC connection to the MS Access from the Site page ?
0
 
LVL 8

Assisted Solution

by:vaderj
vaderj earned 250 total points
ID: 39243321
That's one way. Another way could be via SOAP/RPC, or, at least with 2010, you can call the SharePoint client object model directly, though I'm not sure if access 07 can do that
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 200 total points
ID: 39243361
You could promote infopath fields out to the library and then use views and export to excel. If you plan to export to excel then I'm guessing you care more about totals etc than prettiness. So really everything you need is already there. No coding, odbcs, access
0
 
LVL 29

Accepted Solution

by:
QPR earned 200 total points
ID: 39243368
As a test - to see if it meets your needs...
Open Infopath designer.
Create a very simple form with a few fileds.
During the publishing wizard, specify that you want to promote some of these fields as columns.
Point the newly created form to a new forms library.
Create a couple of items.
See how the fileds you promoted end up as columns in the library
Click the "library" tab.
Select export to excel from the ribbon.

By using views in the library you can select which columns/sort/group etc you want the columns to show. Then when this is in excel you can create your graphs.

If the above is missing anything, report back and maybe we can find a way to do what you need without the extra work that your initial thoughts would surely bring
0
 
LVL 28

Assisted Solution

by:clayfox
clayfox earned 50 total points
ID: 39244142
Just to pile on but Access is not designed for an enterprise or multiple users.  sharePoint is running on SQL and SQL reporting services is really the best reporting vehicle.  I understand that it would take some additional work on your part but be the right solution in the end for the users and the company.
you may also want to look at www.qdabra.com, they already have a packaged task list / project management solution for SP and SQL using InfoPath forms which is very nice.
0
 
LVL 7

Author Closing Comment

by:Senior IT System Engineer
ID: 39255208
Thanks !
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now