Ideas on how to determin a specific value with varied parameters

Laurence Nixon

Hello all.
I am seeking ideas on how to determin a specific value with varied
parameters.

This will be for students who have taken modules in a course for
pre-certification. So it will be like this:

StudentA
ModuleA + ModuleC + ModuleD + ModuleE = (Completetion of this COURSE1)

StudentB
ModuleA + ModuleE + ModuleB + ModuleF = (Completetion of COURSE1)

If these values (Module??) were static then it really wouldnt be an
issue I dont think, but the model is based on electives chosen by the
student so a varying module sets should produce the completion of a
specified course.

How would I go about doing this within Access 2000, or is this more of
a VBA or VBS type problem.

Thanks all for there help in advance.

Nov 12 '05 #1

Subscribe Reply

1359

DFS

Laurence,

Your problem is going to be solved by application of whatever tool best
suits the issue. You can do most of it using Access/Jet database tables and
queries. You might need a few user interfaces.

You'll first need to build a database structure to capture the data.
Something like:
Students
------------
* StudentID
StudentName
Courses
--------------
* CourseID
CourseName
Modules
------------------
* ModuleID
ModuleName
CourseModules (modules valid for the course)
------------------------
* CourseID
* ModuleID
StudentCourseMo dule (modules chosen by the student in fulfillment of the
course requirements)
------------------------------------
* StudentID
* CourseID
* ModuleID
ModuleCompleted Date
ModuleGrade
etc.
* = primary key. And of course enforce appropriate indexes and required
fields and referential integrity so only valid data can be input.

The student would use the CouseModules table when choosing the Modules for
the Courses they're interested in. (likely done from a screen using
drop-down lists)

You would use the StudentCourseMo dule table to determine when the student
has fulfilled the course requirements. (a query to determine that each
Module for the Student has a CompletedDate).

That should get you started.

"Laurence Nixon" <ln****@ldncons ulting.com> wrote in message
news:3F******** *******@printnp lay.com...

Hello all.
I am seeking ideas on how to determin a specific value with varied
parameters.

This will be for students who have taken modules in a course for
pre-certification. So it will be like this:

StudentA
ModuleA + ModuleC + ModuleD + ModuleE = (Completetion of this COURSE1)

StudentB
ModuleA + ModuleE + ModuleB + ModuleF = (Completetion of COURSE1)

If these values (Module??) were static then it really wouldnt be an
issue I dont think, but the model is based on electives chosen by the
student so a varying module sets should produce the completion of a
specified course.

How would I go about doing this within Access 2000, or is this more of
a VBA or VBS type problem.

Thanks all for there help in advance.

Nov 12 '05 #2

Similar topics

2610

To experienced OO people: please give some ideas/URLs for a course on object-orientation

by: Az Tech | last post by:

Hi people, (Sorry for the somewhat long post). I request some of the people on this group who have good experience using object-orientation in the field, to please give some good ideas for topics to include in a course on object-orientation that I'm going to conduct. (I will later summarize all the replies and discussion, for the

C / C++

8752

Automated testing | How to "force" GETDATE() function to return specific value?

by: Konstantin Zakharenko | last post by:

Hello, Our QA team have running a lot of test scripts (for automated regression testing), they run them on the different databases (Oracle/MS SQL). Several of those tests are dependent on the current date/time. In order to be able to use them efficiently, we changed the current date/time on the QA database server to a specific date/time before starting the scripts, so we are sure the test scripts always run in the same environment.

Microsoft SQL Server

1346

seeking ideas on how to determin a specific value with varied

by: Magnabyte | last post by:

Microsoft Access / VBA

2607

rules engine ideas? Trying to prevent tons of conditional branches in a logic filter.

by: hazz | last post by:

before I start filling up the first page of perhaps many pages of code with if/then or switch:case buckets, I wanted to step back and see if there is a better way... I will have a table with up to 300 rules in it. Maybe more... In each Score table there is a column which will refer to a domain specific table and another table column that contains the property of that domain specific object. IceCream is a domain and scoops is a property I...

C# / C Sharp

1220

Determin user's intention when onunload fires

by: feng | last post by:

I want to use onunload to capture user's action when he clicks on the "x" button, the close window button on the upper-right corner of the brower window, to close the browser. Here is how I capture the event: <SCRIPT FOR="window" EVENT="onunload"> myScript(); </SCRIPT> While myScript() does get called when "x" gets clicked, it is also get called when the user leaves the current page

ASP.NET

2775

Dynamic cast string value to a specific data type for stored procedure

by: tedqn | last post by:

Problem: - Stored procedure input parameters data type specific (SqlDbType.Int, SqlDbType.VarChar,etc). - Form submitted value in TextBox, DropDownList, etc are all string type (I guess). Some maybe empty. I need a function that would grab the string value and dynamically convert to the corresponding data type specific sql parameter OR DBNull.Value. The problem is that I have to specifically specify what data type the function will...

C# / C Sharp

5957

determin if a object is a textbox

by: moondaddy | last post by:

in a wpf c# windows app, how do I determin if a control is a texbox? void Test(object sender) { if(sender==Texbox) { // do something. } }

.NET Framework

1810

Need ideas on how to approach this.

by: Anders B | last post by:

I want to make a program that reads the content of a LUA array save file.. More precicely a save file from a World of Warcraft plugin called CharacterProfiler, which dumps alot of information about your characters into that save file. Anyhow, I want to extract a couple of lines of it and save it into a database and I need help on figuring out a good way of reading the file. The problem is that the file can look pretty different depending...

Visual Basic .NET

1571

Determin How WebService method was invoked

by: Nick | last post by:

Hi there, Is it possible to tell how a WebMethod was invoked? For example I would like to determin if it was invoked via SOAP or HTTP Post. Other than creating 2 methods I am no sure if I can do this. Many thanks for your time. Nick.

Visual Basic .NET

9647

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9491

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10163

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8988

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7510

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6744

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5397

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3668

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2894

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General