access database

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » ACCESS DATABASE

ACCESS DATABASE

resolvedResolved · Urgent Priority · Version 2003

Felice has attended:
Excel Introduction course
Word Advanced course

ACCESS DATABASE

I have a database. In the database I have a lot of tables. I shall like to send one of the tables as an attachment in an email to somebody. I cannot seem to do it unless I copy the whole database and I do not want them to have the other tables. Can you please help me asap.

RE: ACCESS DATABASE

Hi Felice

Thank you for your question.

You will need to export the table into a new database that just contains that table.

Create the new database, and give it a meaningful name. You may also need to add in an empty table before Access will let you save the database. This done close the database.

Next, go to the database that contains the table, and select the table in the database window. (Do not open the table).

Click on File_Export and then select the new database you have created, and click Export. The table will then be copied over.

You can then email your new database as an attachment

Hope this helps

Regards

Stephen

Tue 16 Mar 2010: Automatically marked as resolved.


 

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips


Server loaded in 0.1 secs.