<div>
There is a new question if you interested<br />
<a href="https://www.experts-exchange.com/questions/28225339/Structure-Access-please.html" rel="ugc">https://www.experts-exchange.com/questions/28225339/Structure-Access-please.html</a>
</div>


There is a new question if you interested
https://www.experts-exchange.com/questions/28225339/Structure-Access-please.html [https://www.experts-exchange.com/questions/28225339/Structure-Access-please.html]

<div>
<div class="content wysiwyg-content">
Hello<br />
I designed a access DB 5 years back. Forgot everything. What are the things I need to keep in mind when I design a single table in a Access. I am dealing with zillion pieces of data filed that needs to be converted into a model in access. But I am totally lost. Someone please guide me and tell me what are some basics to understanding the pieces of data and make sure I am creating the individual tables with the correct field in them and no redundancy. I am confused<br />
thank you
</div>
</div>


Hello
I designed a access DB 5 years back. Forgot everything. What are the things I need to keep in mind when I design a single table in a Access. I am dealing with zillion pieces of data filed that needs to be converted into a model in access. But I am totally lost. Someone please guide me and tell me what are some basics to understanding the pieces of data and make sure I am creating the individual tables with the correct field in them and no redundancy. I am confused
thank you

Access SOS  - in danger, please help!!

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.