Creating a Design
Next, you’ll want to come up with a design. What are you trying to do within your application? What data is being tracked, how will data be entered into the application and how will data be viewed? You’ll need to answer each of these questions to fully develop your design (Figure 2).
What data are you going to track? Let’s say you want to track a list of contacts. What fields will be necessary? Start writing down the names of fields you will want to track such as “First Name", “Last Name" and “Email Address".
Next, for each of your fields, you will need to determine how the data will be stored. Are you going to use simple free-form text entry boxes, will you use lookup fields, date fields or other types of controls? So, for your list of fields, add a list of control types. This will make creating your table much easier in the next article.
Once you have your field names and types laid out you will want to consider how end users will input this data. What will the form look like? Do you want a simple tabular layout where each contact is stored, or do you want to show one contact at a time. It’s best to take a piece of paper and actually draw out what you want the form to look like.
Finally, how do you want users to be able to view the data? Reports are typically the answers but Microsoft wasn’t able to add in reporting functionality into Access 2013. Instead, you can create different forms that will let you view the data in differing ways. You can also connect Excel to your application’s database in order to create reports and charts.
After you’ve come up with your design you should be ready to start creating your web application. Continue on to the next article to get started!