| Creating a complex database that pulls in information | | | | may wish to add images to your customers' files or |
| from across the globe is possible with Microsoft | | | | further details featuring general facts about your |
| Access. | | | | clients, such as their address and company history. A |
| This well-used software is found in many homes and | | | | plus point of both MS Excel and Access is that they |
| offices throughout the world that wish to compile | | | | make a winning team in regard to building banks of |
| data from many sources. For instance, as a | | | | information that can be analysed and presented to |
| homeowner you may be seeking to organise your | | | | your colleagues and customers. |
| household outgoings so you can ensure you do not | | | | If you work in an international company you may find |
| exceed your monthly budgets. MS Access allows you | | | | it challenging to be tasked with creating databases |
| to create databases that you can use to calculate | | | | using figures from fellow employees who are located |
| your spending so you are aware of your finances. In | | | | outside your home country. However, in this instance |
| addition, the programme is a great addition in offices | | | | the two applications work together in harmony with |
| that need to store lots of different information that | | | | MS Outlook so you can get the data you need |
| can be sent from other users and shared within your | | | | without spending vast amounts of time waiting for |
| company. While, MS Access gives you the | | | | emails featuring the information to be returned. |
| opportunity to store data in a spreadsheet, like in MS | | | | All you need to do is send an email via Outlook that |
| Excel, it offers you a host of other features that | | | | features a data entry form bearing fields that detail |
| help you to analyse data. | | | | the data you need. So you may be wishing to have |
| This is the major advantage that the former | | | | details on the number of new customers acquired in |
| programme has over the latter, in that it is designed | | | | your employer's offices across the globe, which may |
| so you can see more relationships among the figures | | | | have boxes such as 'client name', 'length of contract' |
| that you have uploaded into MS Excess files. So if | | | | and other relevant sectors. This requires you to use |
| you need to create tables holding information about | | | | the Data Collection Wizard, which enables you to pull |
| your customers, such as their orders, but you would | | | | in the information you require. You can choose |
| also like to add dates of their orders to see the | | | | whether you would like the returned forms to be |
| impact of the time of year on sales for example, you | | | | immediately uploaded to your corresponding |
| are advised to use MS Access. The application can | | | | databases that are collating the necessary data. |
| form links between tables of information so you can | | | | This effectively means that you can send a simple |
| call up the data you need quickly, whereas MS Excel | | | | email in order to collect the information, which is sent |
| features spreadsheets that perform calculations on | | | | to your files and automatically uploaded. This feature |
| information that is not linked in this manner. | | | | helps organise teams that need to work together |
| As well as drawing together statistical information | | | | effectively and helps overcome geographical barriers |
| into one place, MS Access also enables you to add a | | | | that can hamper the running of businesses. |
| variety of other media from different locations. You | | | | |