A small part that I would like to elaborate on in this post from this past week on databases is the design view of the database. The view button may be so small and not the biggest deal ever, but with the amount I have already been working with Access, it has proven to be very important.
When creating a table it is important to start off in the design view. To get to design view, simply go to the top left of the ribbon, click on view, and then click on design view. The foundation really starts off in the design view. That is where the field titles are chosen, the data types are chosen, and descriptions are filled in. Then when it comes to forms, the design view gives you the most power to edit all aspects of a form’s design. Then for the report, the design view helps dictate all the details of how your report is going to look once printed. Thus, it is easily seen that the design view is very important. At first I was unsure of what this “view” thing meant, considering I had never encountered such a drastic change in view on Excel before, but now I am already comfortable changing between datasheet view and design view. The design view really gives the user a large amount of control and has to do with what makes databases so unique.