Access Databases are composed of tables, inquiries, structures, and reports. Together, these items enable you to enter, store, break down, and aggregate information anyway you need.
By this point, you should as of now comprehend that a database is an accumulation of information sorted out into numerous associated records. In Access, all information is put away in tables, which puts tables at the core of any Access Databases.
Access Databases contains lines and sections as records and fields. A field is something other than a segment; it’s a method for sorting out data by the kind of information it is. Each snippet of data inside a field is of a similar sort. For instance, each section in a field called First Name would be a name, and each passage in field called Street Address would be an address.
Similarly, a record is something other than a column; it’s a unit of data. Each cell in a given column is a piece of that line’s record.
Notice how each record traverses a few fields. See the number at the left of each column? It’s the ID number that recognizes each record. The ID number for a record alludes to each snippet of data contained on that column.
Tables are useful for putting away firmly related data. Suppose you possess a pastry shop and have a database that incorporates a table with your clients’ names and data, similar to their telephone numbers, personal residences, and email addresses. Since these snippets of data are on the whole points of interest on your clients, you’d incorporate them all in a similar table. On the off chance that you chose to include any more data—say, a client’s birthday—you would essentially make another field inside a similar table.
Blogs : www.office.com/setup