Access 2003 Database structure

  • Thread starter Thread starter BR
  • Start date Start date
B

BR

Hi all,

I have to make a database for my employer and it should contain:

- employees information (personalia, contract, etc.)
- employees' office possesions (car, clothing, blackberry, gsm, keys)
- distributors of these possesions

Somehow I have to link these three tables. I know it is a simple newbie
question, but I can't figure out how the basic structure should be...

I have to be able to:
- add new employees
- link several office possesions to these employees
- link distributors to these office possesions

Can someone please give me a simple structure do accomplish this??

Thanks a lot!
 
Hi BR,

read this:

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

Pay close attention to the Normalization and Relationships sections --
and, the 'Employees' table looks like more than one table to me...

we could help you with structure, but then you'd have questions about
setting up relationships, then forms, ... everything. You need to be
able to arm yourself with a bit of knowledge so you can understand the
help that we give you <smile>



Warm Regards,
Crystal
remote programming and training

Video Tutorials on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal


*
(: have an awesome day :)
*
 
Ok thanks,

I have a pretty good structure right now...

A difficult thing I need to do know is make a personell form with a filter.
I want to select one employee out of a list of employees with the result of a
new form with all personalia of this particular employee.

Any advice?
 
BR said:
Ok thanks,

I have a pretty good structure right now...

A difficult thing I need to do know is make a personell form with a filter.
I want to select one employee out of a list of employees with the result of a
new form with all personalia of this particular employee.

Any advice?
Click to expand...

The most helpful comment I can make is this: you're asking the sort of
questions that the (non-technical) boss would ask the computer-guy, not
the sort of questions that the computer-guy would ask a more experienced
colleague. That's ok - we all started out knowing very little and most
of us have a way to go yet. However, it sounds to me that you haven't
enough insight yet to break this problem down in the way you'll need to.
As Crystal suggests, you need to do some study before you tackle this
- it'll give you intellectual tools to tackle this task. So, work your
way through Crystal's tutorials, and/or an introductory book, or the
video lessons on lynda.com, and come back here when you need help with
specifics. When you do, start by describing your tables in good detail
- if you don't get those right, at the start, your project is simply doomed.

Access is a steep and long climb, but the views at the top are great...

Phil, London
 
Instead of opening a second form why not just navigate to the employee's
record in the current form? Add an unbound combo box to a form bound to the
Employees table, setting up the combo box like this:

RowSource: SELECT EmployeeID, FirstName & " " & LastName FROM
tblEmployees ORDER BY LastName, FirstName;

BoundColum: 1
ColumnCount: 2
ColumnWidths: 0cm;8cm

If your units of measurement are imperial rather than metric Access will
automatically convert the last one. The important thing is that the first
dimension is zero to hide the first column and that the second is at least as
wide as the combo box.

In the combo box's AfterUpdate event procedure put:

Dim rst As Object
Dim ctrl As Control

Set rst = Me.Recordset.Clone
Set ctrl = Me.ActiveControl

With rst
.FindFirst "EmployeeID = " & ctrl
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With

Ken Sheridan
Stafford, England
 
A difficult thing I need to do know is make a personell form with a filter.
I want to select one employee out of a list of employees with the result of a
new form with all personalia of this particular employee.
Click to expand...

A simple thing, actually!

Create a Form based on the personnel table. Put a Combo Box on it, using the
toolbox combo wizard, to create a combo box "use this combo to find a record".

Put a Subform on the form based on the posessions table, using the employee ID
as the master/child link field.

This assumes that your tables are correctly structured and related... you
haven't said.
 
You will need a table for employees, possessions and distributors.

One employee can have many possessions so you have a one to many
relationship there.

You need a primary key in your employee table and a foreign key in
your possession table to link the two together.
I am not sure of the distributor or what exactly it is.


For FREE Access ebook and videos click here
http://access-databases.com/ebook
 
Back
Top