LINKS

1. Written instructions on how to create your database (updated on a regular basis)
2. Data Testing and Integrity Procedures Checklist

VIDEOS

1. Access - Primary key, lookup option and formatting tables

2. Access - Trouble shooting errors, formatting the table

3. Access - Formatting the table

4. Access - Creating Input Masks for Telephone Number

5. Access - Creating the Fees table (with Jan, Feb, Mar.....) AND Access - Creating the Fees table (modified)

6. Access - Continuing with creating the members tbl

7. Access - Populating the members table and troubleshooting the Telephone Input Mask

8. Access - Adding the fees column into a total

9. Access - Results query

10. Access - Biography query

11. Access - DON'T FORGET to add Transaction ID as the PRIMARY KEY for your fees table

12. Access - Changes to Database i.e. Deleting Second Fees Table

13. Access - Subtracting Fields for Amount Owing in Fees tbl

14. Access - Invitation Query for Letter 1, criteria for fields

15. Access - Fees for Mar and April Query (QUERY with a RELATIONSHIP)

AFTER-NOTE: It is not shown in the above video, but go back and add to your query "Address, City, and Postcode - then run it. It is explained further in this video below.

16. Access - Invite Letter 1 - Inserting Access Query fields into a Word Document. DO NOT DO

17. Creating a form

18. Creating Macros: Print and Email.

19. HOW TO DESIGN YOUR FORM OR REPORT: Logo and Letterhead Colours

20. Tutorial 9 - DESIGNING YOUR FORM/REPORT: Image in background.... FANCY styling

EXEMPLAR

This is a marginal Merit. Marginal merit because 1/ the word document failed to link data from the access database. 2/ The logo was not original 3/ The brief

Click here for the folder to view