can i create database and have only certain fields goto backup?

[Guest]

i am creating a confidential file that has names and ss#. but i also have
fields that i need to create a report (i.e. statistics) i would like to
create from that main database a file for backup and transmission of only
certain fields. how can i do this?? contact me if you need further
clarification.

 

[Rick B]

The point of a backup file is to let you restore data if the file becomes
lost or damaged. If you only back up part of the file, what will you do
when you need to use the backup?

Not sure I understand why you'd want a partial backup.

 

[Guest]

yes i will want to backup the whole file but i aslo need only certain fields
to go to a separate backup because of federal government confidentiality
issues at my locations. cannot transfer via internet; names, ss#, etc. these
items will not be included in the separate backup to transmit.

 

[Rick B]

Then I would think you wouls need to create a query to pull the data you
want and export the query or make a table.

 

[Guest]

so are you saying that by creating the query i will be able to create a
database of that query separate from the main database?? i am after creating
a separate database with limited data...