implementation report

Authors Avatar
Implementation report For Forms

Main menu Form

For me to design a main menu page I need to open Microsoft access first and then after I have opened Microsoft access I need to open my database, after this I clicked on create form in design view.

Appendix 1

Appendix 1 shows the form in design view; you can manually design your form by going on create form in design view.

Appendix 2

Appendix 2 shows that I am going to auto format my form so that the style looks different and it looks more professional

Appendix 3

Appendix 3 shows the auto format wizard of the form this lets me decide what format and style I want the form to be like this will make the form look more attractive and therefore would be more appealing to the user

Appendix 4

This is how my form looked in design view when I finished the auto format.

Appendix 5

Appendix 5 shows that I added a title by first adding a textbox and then writing in the appropriate title, and then I changed the font and the style of writing.

Appendix 6

Appendix 6 shows that I inserted the pictures either side of my title to make the form stand out and look more colourful.

Appendix 7

Appendix 7 shows how I created a command button to link to my loans form, I first need to open the command button wizard, this wizard is shown in appendix 7, and I then clicked on open form

Appendix 8

Appendix 8 shows that I chose the loans table open up as a form when I click on the command button.

Appendix 9

Appendix 9 shows that I renamed my command button as loans so that it would be recognisable that the loans form would be opened.

Appendix 10

Appendix 10 shows that when the command button wizard was finished a button appeared as loans which would then link to the loans page.

I then did the same for the members' page and the videos page so at the end my main menu page looked like this:

Appendix 11

Appendix 11 shows that I even added an exit button on my main menu to make my system exit safely and save any changes. I also resized the command buttons so that the display of the main menu would look attractive and professional.

Loans Form

To make the loans form I firstly had to open Microsoft access where my database was saved and click on the forms tab and then click on 'create form by wizard'

Appendix 12

Appendix 12 shows that when I clicked on the tab 'create form by using wizard' the following wizard appeared asking me to choose the table I want the form to contain , so I clicked on loans, because I wanted to make the loans form.

Appendix 13

Appendix 13 shows that the wizard then asked me what layout I wanted the form to be, so I clicked on columnar as this would make the form easier to understand for the user

Appendix 14

Appendix 14 shows that when I clicked next the wizard asked me to choose what style I would like the report to be, I chose the same style as the main page as this would make the database look more professional and appealing.

Appendix 15

Appendix 15 asked me to name the form so that it would make it easier for me to refer back to it

Appendix 16

Appendix 16 shows how my form looked after I clicked on modify the forms design

Appendix 17

Appendix 17 shows the form after I made a few changes.

Appendix 19

Appendix 19 shows that I added the same title and format of the writing as the main page so that the system would look professional; I also added the same pictures as the main page to make it look even more professional

Now that the layout of the form had been created I had to add command buttons to do specific jobs to make the job easier for Mr Patel, as the whole system would be put on these forms

Appendix 20

Appendix 20 shows that I needed to create a command button to add new loans so I opened the button command wizard and clicked on add new record, as I wanted to add new loans

Appendix 21

Appendix 21 shows that the wizard asked me if I wanted to name the command button or I wanted to use a picture for the command button. I decided to use text instead of picture as this would be easier for the user to understand, if I used the picture the user might think that it would be something else.

Appendix 22

Appendix 22 shows that the command button was added I resized the command button to an appropriate size so that it would look appealing to the user

I then worked through the wizard and did the same for the 'save loan' and delete loan command buttons, it would be the same procedure but selecting different things, which would be appropriate for the appropriate command button.

Appendix 23

Appendix 23 shows how my loans form looked after I inserted the other command buttons.

Appendix 24

Appendix 24 shows the wizard for creating a command button which allows you to preview reports, as Mr Patel wanted to know the overdue videos and this would pick out for him which members have overdue videos.

Appendix 25

Appendix 25 shows that I chose the overdue videos report, because I am creating a command button for this.

Appendix 26

Appendix 26 shows that I renamed the command button Overdue Loans as this would make the user aware what this command button would do.

Appendix 27

Appendix 27 shows that when the wizard for creating the command button had finished the command button was inputted on the form, as you can see.

Appendix 28

Appendix 28 shows that when I clicked on the command button a parameter query question came up on the screen asking me for today's date.

Appendix 29

Appendix 29 shows the report of overdue records that came up when I entered today's date.

I did the same for the other two reports which were 'unpaid loans' and 'videos out on loan'

Appendix 30

Appendix 30 shows the video's form when I finished inserting the 2 reports in the database.

Appendix 31

Appendix 31 shows the finished loans system, I added a few more buttons which would make my system work at ease for the user, I added a 'back' button which would take me back to the main page, this feature can be very useful at times.

Members Form

To make the form for the membership information on Microsoft access, I had to open up my database, and then click on the forms tab and then double-click on 'create form by using wizard'.

Appendix 32

Appendix 32 shows that When I double clicked on 'create form by using wizard' a form wizard came up asking me to choose what table/query I want the form to be so I clicked on the lookup/dropdown menu, and I selected the members table, and a list of fields came up under 'available fields' so I selected all of the fields, when all of the fields were selected I pressed the next button..

Appendix 33

Appendix 33 shows that the wizard asked me what layout I would like the form to be, so I selected the columnar layout as this would be easy to understand for the user and also it would look a lot more professional. Then I pressed next

Appendix 34

Appendix 34 shows that when I pressed next, the wizard asked me what style I would like the form to be. I chose expedition as I thought this looked attractive and also looked very professional.

Appendix 35

Appendix 35 shows that the wizard asked me what I wanted the formed to be called, I simply called it members, so that the user would understand what the form is about, and the wizard also asked me if I wanted to modify the forms design, so I clicked on that tab, because I wanted to modify the forms design.
Join now!


Appendix 36

Appendix 36 shows the design of my form at first when the wizard was completed, at the moment the form doesn't look appealing, so I am going to change the design of the form, add command buttons etc.

Appendix 35

Appendix 35 shows the button command wizard for adding a new member; this command button would be very useful, as this would save Mr Patel the time and effort of going back to the members table and adding a new member manually. I then clicked on record operations, and then highlighted 'add new ...

This is a preview of the whole essay