Move to the queries section and begin building the queries that will make your accounting database more useful. When you type into the data entry form, the information is automatically transferred to the underlying Access table. You can then use that data entry form to add information to the table. Use the form wizard to create a simple data entry form based on the fields in your table. Go to the forms section of the Access window and choose the form wizard option. Type a name for the table and click "OK." Step 6. Step 5.Ĭlick the "Save" button to save your table. It is easier to build all the fields you need from the start than to go back and add fields to a database that already contains hundreds or thousands of records. Review the list of fields in your database and add any others you think you will need. You can also use date and time fields for things like due dates. You can format your fields as currency, numeric and text as need be. Click the drop-down box next to "Data Type" for each field in your database.
0 Comments
Leave a Reply. |