Database Design and Development solutions utilising Microsoft Access
and Implementing Excel, Outlook, Word and SQL Server
This is an online portfolio of my work within the Microsoft Office range of applications
On the following pages I have tried to best illustrate what Access can be capable of as well as what my own skills set can offer.
Utilise Access
Input Forms
Enter your data in an easy and convenient way that can verify your data as you go.
Customer Database
Select customers based on age, gender, location or any other criteia you may wish.
Process Orders
Whether it is for products or services, they can all be matched up to their database customers and can be as simple or complex as you like.
Track Payments
Have your customers been paying their invoices? Access can keep track of them all to remind you.
Enter your data in an easy and convenient way that can verify your data as you go.
Customer Database
Select customers based on age, gender, location or any other criteia you may wish.
Process Orders
Whether it is for products or services, they can all be matched up to their database customers and can be as simple or complex as you like.
Track Payments
Have your customers been paying their invoices? Access can keep track of them all to remind you.
Generate Reports
Want to see how your business has been doing? Produce reports based on multiple time periods using all or a subset of your data.
Produce Pivot Charts
Drag and drop fields and filter the results, Pivot charts offer a great way of interacting with your data.
Incorporate Outlook
Bespoke Invoices
Generate and send multiple individualised invoices at the click of a button.
Send Statements
Customers often want a statement of their transaction payments, again it just takes a click of a button.
Send Flyers
Got a new product, service or great offer? Tell all about it or just a selection of your customers.
Incorporate Excel
Produce Charts
Export data from an Access report into Excel to show data in a highly versatile graphical format, also use a live Excel data connection to live data in Access to produce a variety of Pivot Charts.
Consolidate Data
Having your data spread across multiple spreadsheets can make analysis very difficult. Instead it is better to have users input data using Access and then bring it back into Excel to manipulate. An example below shows a Running Sheet of tasks linked to Access, refreshing the spreadsheet will display new and updated data. By using Excel in this way you can make good use of column summations and colour formatting that will help show data more clearly.
Export data from an Access report into Excel to show data in a highly versatile graphical format, also use a live Excel data connection to live data in Access to produce a variety of Pivot Charts.
Consolidate Data
Having your data spread across multiple spreadsheets can make analysis very difficult. Instead it is better to have users input data using Access and then bring it back into Excel to manipulate. An example below shows a Running Sheet of tasks linked to Access, refreshing the spreadsheet will display new and updated data. By using Excel in this way you can make good use of column summations and colour formatting that will help show data more clearly.
Incorporate Word
E-Mail Merge
Use a customer database to link to a Word mail merge document which can automatically email individual merged documents to all needed recipients, these documents can also be merged in pdf format so they cannot be manipulated.
Use a customer database to link to a Word mail merge document which can automatically email individual merged documents to all needed recipients, these documents can also be merged in pdf format so they cannot be manipulated.