473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Practice Projects in vb

Hi Everyone
I am new to vb. I have completed learning some part (almost full) of vb. I want to know the my level of proficiency in vb. So I request you to please give me dummy projects so that I can practice them.
Awaiting for your reply
Kishore
Dec 26 '06 #1
7 3159
sashi
1,754 Expert 1GB
Hi Everyone
I am new to vb. I have completed learning some part (almost full) of vb. I want to know the my level of proficiency in vb. So I request you to please give me dummy projects so that I can practice them.
Awaiting for your reply
Kishore
Hi there,

Lets get into the training ground, so, you need a dummy project? Very well, firstly you need to outline the areas that you have mastered in VB. Have you covered the database section? I have something in my mind, lets see if you can take it up.

I need you to design an application for video rental store, the specs are as follow,

Assignment I

1. Multiuser application
2. ACL (Access control list) must be implemented
a. manager - full access
b. head-of-department (hod) - limited access
c. user - limited access
3. Must include database backup / restore feature (FSO is useful in)
3. Printing features
4. Search features
5. Data handling - insert/update/delete

Start working on it, message me or any other experts when you are stuck at any point. Good luck & Take care.
Dec 26 '06 #2
Hi there,

Lets get into the training ground, so, you need a dummy project? Very well, firstly you need to outline the areas that you have mastered in VB. Have you covered the database section? I have something in my mind, lets see if you can take it up.

I need you to design an application for video rental store, the specs are as follow,

Assignment I

1. Multiuser application
2. ACL (Access control list) must be implemented
a. manager - full access
b. head-of-department (hod) - limited access
c. user - limited access
3. Must include database backup / restore feature (FSO is useful in)
3. Printing features
4. Search features
5. Data handling - insert/update/delete

Start working on it, message me or any other experts when you are stuck at any point. Good luck & Take care.
Thank you very mcuh. I shall work on this project, and I will definetly message you when I am in need.
Dec 26 '06 #3
sashi
1,754 Expert 1GB
Thank you very mcuh. I shall work on this project, and I will definetly message you when I am in need.
Hi there,

Good luck & Take care.
Dec 26 '06 #4
Hi there,

Good luck & Take care.
Hi Sashi
In this project, how to limit the access to various levels? Should I prepare a Login form for various levels?
Dec 26 '06 #5
sashi
1,754 Expert 1GB
Hi Sashi
In this project, how to limit the access to various levels? Should I prepare a Login form for various levels?
Hi there,

Yes, you need to have an interface for the operator to login, validation has to be done on the access level. ACL must be obtained from database back-end. Kindly refer to below table structure,

Table structure

sSecurityTBL
Expand|Select|Wrap|Line Numbers
  1.   nUser_ID - Autonumber (Primary Key)
  2.   sUsername - Text
  3.   sPassword - Text
  4.   nACL_ID - Number  (Foreign Key)
  5.   dtLastSeenDateTime - Date / TIme (useful for auditing purpose in real-time system)
  6.  
sAccessLevelTBL
Expand|Select|Wrap|Line Numbers
  1.   nACL_ID - Autonumber  (Primary Key)
  2.   sAccessLevel - Text
  3.  
Sample data

sAccessLevelTBL
Expand|Select|Wrap|Line Numbers
  1.   nACL_ID  sAccessLevel
  2.   1              Manager
  3.   2              Operator
  4.  
sSecurityTBL
Expand|Select|Wrap|Line Numbers
  1.   nUser_ID  sUsername  sPassword  nACL_ID  dtLastSeenDateTime
  2.   1              manager       manager     1              <some date>
  3.   2              operator        operator      2             <some date>
  4.   3              abc               operator      2             <some date>
  5.   4              xyz               operator      2             <some date> 
  6.  
Dec 26 '06 #6
Hi there,

Yes, you need to have an interface for the operator to login, validation has to be done on the access level. ACL must be obtained from database back-end. Kindly refer to below table structure,

Table structure

sSecurityTBL
Expand|Select|Wrap|Line Numbers
  1.   nUser_ID - Autonumber (Primary Key)
  2.   sUsername - Text
  3.   sPassword - Text
  4.   nACL_ID - Number  (Foreign Key)
  5.   dtLastSeenDateTime - Date / TIme (useful for auditing purpose in real-time system)
  6.  
sAccessLevelTBL
Expand|Select|Wrap|Line Numbers
  1.   nACL_ID - Autonumber  (Primary Key)
  2.   sAccessLevel - Text
  3.  
Sample data

sAccessLevelTBL
Expand|Select|Wrap|Line Numbers
  1.   nACL_ID  sAccessLevel
  2.   1              Manager
  3.   2              Operator
  4.  
sSecurityTBL
Expand|Select|Wrap|Line Numbers
  1.   nUser_ID  sUsername  sPassword  nACL_ID  dtLastSeenDateTime
  2.   1              manager       manager     1              <some date>
  3.   2              operator        operator      2             <some date>
  4.   3              abc               operator      2             <some date>
  5.   4              xyz               operator      2             <some date> 
  6.  
Ok. I finished designing the LogIn forms and now I am designing the database. Here I am using MS Access as database. Because I dont have any other database installed in my system.
Dec 26 '06 #7
sashi
1,754 Expert 1GB
Ok. I finished designing the LogIn forms and now I am designing the database. Here I am using MS Access as database. Because I dont have any other database installed in my system.
Great, MS-Access should be good enough, go on, continue working on it. Good luck & Take care.
Dec 26 '06 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Erik De Keyser | last post by:
Hi group, I have a couple of projects with up to 8 forms. On most projects I write the code on each form with no modules. The last project I use 1 module and minimal code on each form , in fact...
3
by: Ole Olsen | last post by:
Hi Any input on what is best practice: 1 ) Put an Interface definition (e.g. IMyInterface) into a separate Assembly 2 ) Put the Interface definirion into the same assembly that holds the...
2
by: Jon Smith via DotNetMonster.com | last post by:
Hi all, I've recently completed studying two C# books. I'm now looking to keep my knowledge of C# sharp (excuse the pun) by doing practice projects. Can anyone tell me where I might find C#...
6
by: Droopy | last post by:
Hi, I want to add unit tests in my application using NUnit. At first, I thought to add unit tests in the class that is tested, enclosed in a conditional attribute to remove these unit tests from...
3
by: Marc Gravell | last post by:
Kind of an open question on best-practice for smart-client design. I'd really appreciate anyones views (preferably with reasoning, but I'll take what I get...). Or if anybody has any useful links...
4
by: Guy Noir | last post by:
Hello. Is there a pattern or best practice for the following scenario? I have a list of items I would like to compare. The number of items are decided at runtime. ObjectA, ObjectB,...
11
by: Ray | last post by:
In our field, we don't always get to program in the language we'd like to program. So... how do you practice Python in this case? Say you're doing J2EE right now. How do you practice Python to keep...
0
by: lokesh4yuth | last post by:
H1B Sponsership Pragramme _ DW Practice We are looking for Committed IT Professional Consultants for an H1B Visa. About the company: DW Practice (www.dwpractice.com) is a consulting...
1
by: =?Utf-8?B?Y2hhcmxpc2E=?= | last post by:
We are developing a Web Application in which we would like to utilize the System.Web.Profile object. Unfortunately, .NET does not create the infrastructure for Profiles in a Web Application, only...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.