Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Database - Helpful Tips 1
- Thread starter April
- Start date
- Status
-
1
- #2
Start by deciding what information you want in your database. Write it all down, and decide on the size of fields and types. Next, split it all up into the tables that you want to create and decide on the common field that will link all of the databases. When you come to create the database in Access, ensure that you create the relationships that you have defined.<br>
<br>
As for creating forms and reports and the like, creating queries is really easy to do with the wizard, but if you cannot get what you need out of that, the help guide in Access will provide you with an idea of how to do it. Again, forms and reports are easy to do with the wizard for a start, but you can develop them more once you get to know your way around Access.<br>
<br>
Hope that gives you a start, but try to ensure that you get your field names and sizes right at the start, or it can be a bit of a pain!!
<br>
As for creating forms and reports and the like, creating queries is really easy to do with the wizard, but if you cannot get what you need out of that, the help guide in Access will provide you with an idea of how to do it. Again, forms and reports are easy to do with the wizard for a start, but you can develop them more once you get to know your way around Access.<br>
<br>
Hope that gives you a start, but try to ensure that you get your field names and sizes right at the start, or it can be a bit of a pain!!
- Status
Similar threads
- Locked
- Question