Find Jobs
Hire Freelancers

Build SharePoint database (Access web database)

$30-250 USD

Cerrado
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
I need to unite the following data in SharePoint (Access Services) by the end of July. Below are the required VIEWS and, after, the TABLES fields and field types: STUDENTS Add student/edit student details See student’s current classes See all student’s classes See all student’s test scores See all students (downloadable) CLASSES Add/edit class See all classes (downloadable) ENROLLMENTS Enroll a student in a current class Edit students’ attendance (“Att Wk n”), final grade (log current user to audit table) See all students in current classes sorted DESC by absences See current classes (group by class, show students, class name, teacher, room) (downloadable) See all classes (group by class, show students, class name, teacher, room) (downloadable) SCORES Add/edit test score (log current user to audit table) See all test scores (downloadable) COURSES Add/edit course See all courses (downloadable) TEACHERS Add teacher/edit teacher details See this teacher’s current classes See all of this teacher’s classes MATERIALS Add/edit course materials See all materials (downloadable) ROOMS Add/edit class rooms See all rooms (downloadable) STUDENTS Student ID KEY First Name Text Last Name Text Nickname Text Display Name Calculated First Name + Last Name + (Nickname) US Phone Text University Email Text Mailbox Text US Address 1 Text US Address 2 Text US City Text State/Province Text ZIP/Postal Code Text Home Phone Text Home Email Text Home Address 1 Text Home Address 2 Text Home City Text Home State-Region Text Home ZIP-Postal Text Home Country Text Citizenship Text Notes Long text Start ELI Date Date Finish ELI Date Date CLASSES Note: Classes are actual instances of courses ClassID KEY Class-Course Name Lookup “Course Name” Class Session Lookup “Session Name” Teacher Lookup “Display Name” Room Lookup “Room Name” ENROLLMENTS EnrollmentID KEY Enr-Class Lookup “ClassID” (show “Course Name”) Enr-Student Lookup “JSU Student ID” (show “JSU Student ID” and “Display Name”) Att Arrival Wk Number Att Wk 1 Number Att Wk 2 Number Att Wk 3 Number Att Wk 4 Number Att Wk 5 Number Att Wk 6 Number Att Wk 7 Number Att Wk 8 Number Absence Total Calculated Total number of absences from “Att Wk 1-8” Final Grade Number SCORES ScoreID KEY Scr-Student Text Test Lookup “Test” Scr-Date Date Score Number COURSES Note: Courses are templates for classes CourseID KEY Course Name Text Course Description Long text Core Y/N Retired Y/N TEACHERS EmployeeID KEY First Name Text Last Name Text Nickname Text T-Display Name Calculated First Name + Last Name + (Nickname) Email Text Work Phone Text Home Phone Text Mobile Phone Text Address 1 Text Address 2 Text City Text State/Province Text ZIP/Postal Code Text MATERIALS MaterialID KEY Serial Number Text Type Text Name Text Description Long text Cost Currency Supplier Text ROOMS RoomID KEY Room Name Text Room Type Text Room Capacity Text TESTS TestID KEY Test Name Text Test Abbrev Text Test Cost Currency AUDIT LOGS
ID del proyecto: 10947681

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
15 freelancers están ofertando un promedio de $362 USD por este trabajo
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$250 USD en 14 días
4,9 (137 comentarios)
7,1
7,1
Avatar del usuario
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$155 USD en 10 días
4,6 (54 comentarios)
6,1
6,1
Avatar del usuario
Hello, Greetings!!! I am Microsoft SharePoint Certified partner having over 8 years of work experience on a variety of SharePoint & Office 365 projects and I am confident, I can achieve the results that you are asking for and I can complete your project on time and within your budget. I have a solid Work experience in office 365, SharePoint Server 2013/2010, Nintex Asp .net, C#, Sql Server-2008/2005, Jquery, HTML5 Projects. worked for top notch IT and government agencies as a SharePoint Expert. Certified with SharePoint 70-576 & 70-573 & Asp .net 70-528 and Master in Computer Science from Pune University. Allow me to showcase my skills & expertise for this requirement. Please let me know your convenient time so that we can discuss and start work. Looking forward to hear from you earliest convenience. Thank You. Sajid Khan Skype: sajidkhan2484
$255 USD en 3 días
4,9 (9 comentarios)
4,5
4,5
Avatar del usuario
I've put in a relatively low-priced bid for your project in the hope of getting your attention. I am an Access developer of 10 years (in banking) but the one thing I have yet to do - and really want the opportunity to do - is put a database up on Sharepoint Access Services. I recently built an Access application for a Freelancer customer (see my profile - the data is similar to yours actually), and the next part of that project is to transfer it to Sharepoint, but we won't be doing that for another month or so. I am online if you would like to discuss it with me. Thanks.
$100 USD en 10 días
5,0 (5 comentarios)
4,2
4,2
Avatar del usuario
Hi, my name is Daniel, i am an Access expert, i have a good experience developing databases like this
$250 USD en 3 días
4,8 (12 comentarios)
3,9
3,9
Avatar del usuario
A proposal has not yet been provided
$155 USD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am ready to work under your budget and timings Hi I am sam though I am new to freelancer but have worked at upwork from 6 years. I have a team of developers who will deliver the task within your timings Plz give chance Thanks
$500 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, Greetings!! Thanks for share this requirement. I have gone through your requirement and here I am sharing my view. Approach: We will create access database will all the tables as you mention in your requirement. We will create different forms in access database from where user can insert data which will store in access tables. Using access services we will publish that database in SharePoint site. User who has access of the site can access that database and view it. For audit trail we have to write coding in Access as VB script. We will write code when any record added/updated/ deleted data will be inserted to another table. In such a way audit trail will be maintain. We will write script for all the tables. Quesion: 1) As you mention all 5 users can edit but with hideen audit log. Audit log is for log activity. So why user's can edit that records? Audit trail is for only view purpose. I am not clear on CMS and admin requirement point which you mention. 2) In some tables you mention downloadable. How you want as downloadable? Do we have to generate file in specific formate? 3) What is your sharepoint server version? Ball Park Estimation: 48 Hour Man Hour Regards, Vibhor Trimantra Software Solution LLP
$1.500 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I know your heart is set on MS Access, but consider this. My browser-based cloud database application service INCLUDES ALL SERVICES in a single plan: DESIGN, DEVELOPMENT, HOSTING, TRAINING, and SUPPORT --one low monthly fee to fully support your application needs. I can set up your CUSTOM School Management database application on a production Transaction Editor (TEd) cloud server within two weeks for just $495. * Spreadsheet ease-of-use * Forms processing * Custom reporting * Accountability of a database * Save SEARCHES and SORT on multiple columns * Recover from mistakes with CHANGE HISTORY LOG * Column and Row-defined MULTI-USER ACCESS * EMAIL PDF proposals/orders/bills/invoices/requisitions/reports * IMPORT/EXPORT multiple file formats * SCHEDULED and EVENT-based updates * Automated NOTIFICATIONS * Flexible WORKFLOW Management * Highly RELIABLE and SECURE * and so much more... Search for "Konduit Transaction Editor". Contact me for a demonstration.
$550 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
1. Connect the MS ACCESS database with Sharepoint Designer using BUSINESS CONNECTIVITY SERVICE. 2. Create the associations between the tables 3. Create the External lists 4. Create the lists using the extenal lists
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde jul 6, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.