
So, let’s start to build first the data sheets. Just follow the steps. But be sure to follow first my last post of Start Your Data Access 2007
Data Access 2007, or just click this,
Data Access 2007, or just click this,
- In the data sheets table after in your screen, it have a value, field, or column called ID and add new field. Just right click on the add new field to add another field for you data sheets table.
- Then click rename inside of it
- Then type the field name
- Press enter key
- Repeat only the procedure above to add another field name
- HOW TO CREATE DATA SHEETS FORM BASE OF THE DATA SHEETS TABLE YOU CREATED
- Click create menu
- Click split form button under the forms bar.Note: you can select any of the form formats if you want too
- It will create a separate page after you click the split form button, same as the image shown above
- HOW TO APPLY DATA SHEETS FORM BACKGROUD USING THE AUTO FORMAT
- Click format menu at the top of the screen
- Click the more button or the drop down bar of auto format bar of the format menu
- Then click the auto format wizard, so that you can select a more format design of the template with name describe in the left portion of the screen.
- Then select your background as your template design. For my design of this example corp., I like to select the windows vista template
- It will automatically applied to your data sheets form
- HOW TO ADJUST THE FONT SIZE AND CHANGE THE FONT STYLE
- Just click the title on the top
- Then click the home menu
- Then under of the font bar, click the drop down bar of the current font size, example 20 change it to your desired size of your data sheets form title
- Then change the font style of your data sheets form title if you want.Click the drop down bar beside the default font style, example calibre
- Then select your font style under the list, example bauhaus 93
- Just apply bold, Italics, and underline if your want to apply it
- HOW TO INSERT LOGO OF THE DATA SHEETS FORM TITLE
- Click the logo icon on the top of your screen beside the title
- Then click format menu
- Then click logo button under the controls bar
- A pop up window will appear, if your logo stored in drive d: just click the drop down of look in then click the drive
- Then select the logo their
- Then click ok button
- Just click the new logo and drag your mouse using the outline if you want to adjust the size of your logo
- HOW TO APPLY BACKGROUND COLOR OF THE DATA SHEETS FORM TITLE
- Click the data sheets title
- Then click home menu
- Then click the fill/back color button drop down bar of the font bar under of the home menu
- Then select and click your desired color
- If the font is hidden by the background color just change the font color of your title, example from white to black
- HOW TO FORMAT THE DATA SHEETS FORM BAR OR THE TEXT BOX USING THE PROPERTY SHEETS OR ANY CONTROL BUTTONS OF THE DATA SHEETS FORM
- Click home menu
- Then click the down arrow bar of the views button of the home menu
- Then click design view
- Then click the first text box
- Click the plus box situated top left of your text boxes
- Then right click on the center
- Click property sheets
- A property sheets task pane will display right side of your screen
- Under of the all tab menu, click the border width
- Click the down arrow bar under the hairline
- Then select a size or a point (pt), example 5
- Then click the special effects under of it
- Click the down arrow bar under the flat
- Then select and click raised
- Then close the task pane
- Click the views button under of the home menu
- Then click form view
- Now observe what happen to the text boxes
- Now if you want to put color of the text boxes label names, just click home menu again
- Click views button
- Click layout view
- Then click the text box label name
- Click the fill/back color down arrow bar
- Then select and click the color you want
- Then apply a new color of the font if the color hidden by the color of your back color
- Apply bold of the text if very needed
- Repeat the procedure to rest of the text boxes
0 comments:
Post a Comment
Note: We have Zero Tolerance to Spam. Avoid Promotions with 'Links' considered as spam will be deleted immediately upon our review.