how to adjust a sample database to suit specific needs

[james7705]

Can anyone please, please help me.
I would like to make some changes to the Northwind sample database. it will work perfectly for me.
I need to have the Customers section completely removed as my company issues products to our own staff, not to external customers, so there is no Customers and shipping details needed.
I've tried to do it, but I'm having problems with the code. I don't know what to remove or add.
Please can someone advise or help?

[ranman256]

If you mean Customers DATA?
make a DELETE QUERY, and run it. All data will be removed.

(or just open the table, click the top left corner (like Excel) and press delete.)

[ssanfu]

You can remove all traces of customers and shipping address, but it will be a lot of work. But it can be done.
How experienced are you with Access?
You would have to delete tables and modify tables, queries, forms and reports.

[james7705]

You can remove all traces of customers and shipping address, but it will be a lot of work. But it can be done.
How experienced are you with Access?
You would have to delete tables and modify tables, queries, forms and reports.

I've tried that. there seems to be a lot of code attached to it which I have no clue about.
What I would like is the reference to customers changed to employees as some of my employees i.e. the technicians, remove products from our store which get used on tasks which they have to complete. If I can get Northwind Sample to do that it will work beautifully as I can then also keep track of the cost of the products they use on each task.
My biggest problem is to get around all the code. I can adjust all the forms and things to reflect my company. In other words, when a staff member does a sale, it must be to another employee, not to a customer as such.
How would I do this?

[ssanfu]

In other words, when a staff member does a sale, it must be to another employee

The easiest thing would be to enter the employee as a "customer". You don't have to enter a shipping address or you could enter the company address.
that way you would be able to tell which staff member "sold" the product and which employee "bought" the product.


Otherwise you would have to find someone near you (or in your company) that knows Access VBA programming. Just a matter of following the logic and tracing code.