Create Data Sheets and Data Form using Microsoft Office Data Access 2007

I posted the other day about how to start using Microsoft Data Access 2007. Now we will start to create the Data Sheets so that we can create the data sheets form using the User Interface of the Microsoft Data Access 2007. It is needs only a skills how to design a form neatly or professional look using the different component of the program. Such as the use of the backgrounds that embedded and ready to use and the command expressions we will use.

This data sheets or the table serves as the writing sheets or a worksheets of excel and all the data will store here and calculated using the sections of the columns and the rows within the values of specified. The data form serves as the entry form for the input and output calculation we perform as we stored and calculate the data within the data sheets form.

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,

1. 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.
2. Then click rename inside of it
3. Then type the field name
4. Press enter key
5. Repeat only the procedure above to add another field name

• HOW TO CREATE DATA SHEETS FORM BASE OF THE DATA SHEETS TABLE YOU CREATED

1. Click create menu
2. Click split form button under the forms bar.Note: you can select any of the form formats if you want too
3. 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

1. Click format menu at the top of the screen
2. Click the more button or the drop down bar of auto format bar of the format menu
3. 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.
4. Then select your background as your template design. For my design of this example corp., I like to select the windows vista template
5. It will automatically applied to your data sheets form

• HOW TO ADJUST THE FONT SIZE AND CHANGE THE FONT STYLE

1. Just click the title on the top
2. Then click the home menu
3. 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
4. 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
5. Then select your font style under the list, example bauhaus 93
6. Just apply bold, Italics, and underline if your want to apply it

• HOW TO INSERT LOGO OF THE DATA SHEETS FORM TITLE

1. Click the logo icon on the top of your screen beside the title
2. Then click format menu
3. Then click logo button under the controls bar
4. 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
5. Then select the logo their
6. Then click ok button
7. 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

1. Click the data sheets title
2. Then click home menu
3. Then click the fill/back color button drop down bar of the font bar under of the home menu
4. Then select and click your desired color
5. 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

1. Click home menu
2. Then click the down arrow bar of the views button of the home menu
3. Then click design view
4. Then click the first text box
5. Click the plus box situated top left of your text boxes
6. Then right click on the center
7. Click property sheets
8. A property sheets task pane will display right side of your screen
9. Under of the all tab menu, click the border width
10. Click the down arrow bar under the hairline
11. Then select a size or a point (pt), example 5
12. Then click the special effects under of it
13. Click the down arrow bar under the flat
14. Then select and click raised
15. Then close the task pane
16. Click the views button under of the home menu
17. Then click form view
18. Now observe what happen to the text boxes
19. Now if you want to put color of the text boxes label names, just click home menu again
20. Click views button
21. Click layout view
22. Then click the text box label name
23. Click the fill/back color down arrow bar
24. Then select and click the color you want
25. Then apply a new color of the font if the color hidden by the color of your back color
26. Apply bold of the text if very needed
27. Repeat the procedure to rest of the text boxes

Now, your data sheets form template is look professional in design. If you can just explore the menu found at the top and apply the buttons found in it. I will post another update next time, such as how to insert the different controls of the data sheets form. And how to apply calculations and expressions using the property sheets of the form.  “End”