Is it possible to use an existing database to create a new database

[Charlie]

I have a database that other areas would like to use. How
ever the info in the tables would be different for them.
Can I create a copy of a database leaving out info I had
data entried?

 

[Roger Carlson]

Certainly. Create a copy of the database file, open it, then delete all the
data from all appropriate tables. If you have relationships without Cascade
Deletes set up, you will have to delete the values from the "Many" side
tables first.