已关闭

Build SharePoint database (Access web database)

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

技能: 微软Access, Sharepoint

查看更多: work from home teachers, work from home teacher, web templates 2016, web and mobile templates, types of audit, t mobile work from home, t-mobile work email from home, teacher work from home, teachers work from home, teacher f, microsoft web templates, microsoft access web database, database web templates, att work from home, access work email from home, access group, access database services, access 2010 end database sharepoint, using sharepoint database backend access frontend, access 2007 backend database sharepoint

关于此雇主:
( 0个评论 ) United States

项目ID: #10947681

17 威客就此工作平均出价 $349

Prashantskin

[login to view URL] I have gone through your project requirements regarding students in sharepoint. I will combine all the data in different views that you need I will do the job within 2-3 days only My ratings and revie 更多

$222 USD 在3天内
(477条评论)
7.2
paris2785

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 更多

$250 USD 在14天内
(86条评论)
6.5
workerbee1974

I have 16 years’ experience as an Office Manager/Administrative support. My passion is building Access Databases. I have built well of 250 in 16 years. Samples at [login to view URL] Acad 更多

$222 USD 在3天内
(31条评论)
6.1
zu02

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 Acc 更多

$155 USD 在10天内
(42条评论)
6.0
royalcalif

Hi Mr. Employer I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. [login to view URL] Pm me for more information and sa 更多

$150 USD 在6天内
(46条评论)
5.5
$250 USD 在25天内
(11条评论)
4.4
sajidkhan2484

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 ask 更多

$255 USD 在3天内
(8条评论)
4.5
TimHudspith

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 更多

$100 USD 在10天内
(5条评论)
4.2
y2klewis

Hi, my name is Daniel, i am an Access expert, i have a good experience developing databases like this

$250 USD 在3天内
(12条评论)
3.9
asinghrajesh

Hi There, I can help you to create different lists to manage student database including Students, Classes, Enrollments, Scours, Courses, Teachers, Materials and Rooms by using Out of the box features and also I can 更多

$250 USD 在3天内
(1条评论)
2.7
$300 USD 在10天内
(1条评论)
3.2
alekseysandakov

A proposal has not yet been provided

$155 USD 在4天内
(0条评论)
0.0
smaryum

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 更多

$500 USD 在3天内
(0条评论)
0.0
trimantraindia

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 req 更多

$1500 USD 在7天内
(0条评论)
0.0
davidrudd

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 month 更多

$550 USD 在10天内
(0条评论)
0.0
Bhanu08502

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 在3天内
(0条评论)
0.0
$666 USD 在10天内
(0条评论)
0.0