Can you use Design view to change the forms and reports in a web database?
2. Forms Design Properties in MS AccessThe Forms Design view provides a way to alter all of the properties of form canvas and fields. While it is possible to create a form from scratch just by using the Design View, usually we can get a good start on a form by running through the Form Wizard. Then we can customize the form by playing around with the form properties in Design View. To get started, we will create a data entry for the Accounts table as discussed in the MS Access 2007/2010 Tutorial. Show
For this exercise, we will create a data entry form for the Accounts table.
The new form is shown in the figure below: 2.1 Table Design and Forms DesignOne quick item to call to your attention is the CustomerID and Account Type fields. In the Advanced Database Table Design in MS Access 2010 and 2013 tutorial we modified the Accounts table to make the CustomerID column display as a Combo Box. The Account Type field was then modified in the exercises to show a list of account types. The data entry form “inherits” these features and should have created the CustomerID fields as a Combo Box as shown in the above figure. If your form does not have combo box for CustomerID, you may wish to first go back to the Advanced Database Table Design in MS Access 2010 and 2013 tutorial and complete those steps. Other table features that are also inherited from table design include the size of the text boxes (related to the size of the columns), default values and column validation rules. 2.2 Form Themes in Microsoft Access 2010 and 2013Forms and reports can be customized with a wide range of themes. A Theme consists of a set of background and foreground colors and fonts that are applied to the forms. MS Access 2007 and earlier versions had a small selection of themes that could be selected during the Form Wizard. Access 2010 and later versions create the form first and then apply themes later on. To change the theme of the current form, click on the Home tab on the ribbon bar, then click on the View menu and finallyDesign View. This will change the display of the current form to the Design View as shown below: With the Forms Design View activated, the ribbon bar adds three new entries at the top under the heading Forms Design Tools:
The Design tab is shown below: To change the theme of the form, click on the Design tab on the ribbon bar and pull down the Theme menu. select a theme from the list that drops down. In a similar fashion the color scheme of the form can be changed using the Colors menu and the font used for the labels and text boxes can be set using the fonts menu. Pages: 1 2 3 4 5 6 7 8 9 10 How to Use Form Design View in Access
Don't let Design View scare you. It looks more complicated than it really is. Think of the form as your canvas and the control buttons as paintbrushes for adding fields, text boxes, and buttons to the form. Parts of Design View
Add a ControlAny graphic object that appears on forms and reports is called a control. A text box used to enter and display information, a text label, and a button you click to print a report would all be examples of controls. Let’s look at how to add controls in Design View.
See the table below for a list of some of the controls you can add and what they do.
FREE Quick ReferenceClick to Download Free to distribute with our compliments; we hope you will consider our paid training. What is the use of Design view in database?Design view Design view gives you a more detailed view of the structure of the form. You can see the Header, Detail, and Footer sections for the form. You cannot see the underlying data while you are making design changes; however, there are certain tasks you can perform more easily in Design view than in Layout view.
Can we edit data in Design view?Change data types in Design view
If you do not have the table open, in the Navigation Pane, right-click the table that you want to change, and then click Design View on the shortcut menu. Locate the field that you want to change, and select a new data type from the list in the Data Type column. Save your changes.
Which two views allow you to change the Design of a report?Access provides two views that you can use to make changes to your report: Layout view and Design view. Your choice of which view to use depends on what specific task you are trying to accomplish. You might end up using both views to make your changes.
Which view is used to make Design changes to a form while the form is displaying data?In Layout view, you can make design changes to the form while it is displaying data. When you use the Multiple Items tool, the form that Access creates resembles a datasheet. The data is arranged in rows and columns, and you see more than one record at a time.
|