I rredesigned my database so that a individual can have multiple awards instead of entering a award in every single instance. Folowing are my datafields of the two tables. I have the relationship as a one to many relationship from soldier ID to Soldier ID. Here are the fields.
Soldier Id LNAME FNAME Rank Command Unit Position Title GradeType GradeLevel
Awards Given Fields
Award Id Soldier ID DateReceived DateApproved DatetoTag DatetoAcc TypeofAward Dollaraward Hours GradeStep FYAward StategicObjective Notes
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…