Supersizing Your Databases Via Microsoft Access

As you begin storing important information in regardAs well as learning how to upload attachments to
to the workings of your business it is helpful to berelevant fields in your databases, you may also find it
able to save all the data in one location. Microsoftuseful to see how you can keep data contained in
Access gives you the option of creating vastthe files up-to-date. For example, if you are storing
databases that contain an array of files andemployee details, such as addresses, via attachments
attachments. For example, if you are trying to locateat some point you may have to alter information as
address details of a supplier on a table you no longerworkers' circumstances change.
need to look elsewhere for this information, as it canMS Access allows you to open the Attachment's
be attached to records within databases.dialogue box, which will enable you to make changes
The innovative software means that banks ofto some uploaded files. Up-dates are made to
information that you create can hold a lot more datadocuments in the files they were first created in, so
than just figures. As well as additional writtenif your attachment features an employee's address in
information attached to databases, you can link filesa Word document, you will be required to make
containing images, photos and spreadsheets to them.changes in this format.
This has the advantage that it can save you timeThe software makes sure that files you have
that you may have spent searching for extra details,uploaded to complement other data, such as that
while also modernising your virtual filing system.found in spreadsheets, are easy to manage. As well
When you create a database in MS Access you canas up-dating attachments it is possible to save them
design a medley of documents that show importantin other locations if necessary. This involves you using
data, such as mailing lists, customer addresses andthe Attachment's dialogue box to choose where you
your tax returns. Data can be displayed in tables,would like the file placed, meaning it can be sent to
graphs and spreadsheets, all of which can beor shared with other web users.
summarised with the help of reports.You are also free to delete these attachments if
In order to learn how to correctly link databases tothey are no longer necessary, for example if you
attachments you may like to embark on a traininghave attached information concerning a supplier's
course designed to show you the great benefits thatproducts that are no longer available you can delete
MS Access can bring to the running of your company.this option from the file. Files sizes for uploaded
For instance, on a spreadsheet you may have theattachments can measure up to 256 megabytes
name of a customer and the total of their orderseach in order for them to be successfully linked to
placed with your business. By creating a new fieldyour tables and reports. However, MS Access helps
you will be able to add an array of extra informationyou to save space via its automatic compression of
regarding your customer, such as details of their lastcontent so you can enrich your databases with as
orders and shipping details.much information as possible.