Microsoft Access

Introduction To Objects in Microsoft Access Databases 2016

Access Databases


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.

Rows and columns in an Access table

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.

Fields and field names

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.

A 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.

Record ID numbers

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 :

Leave a Reply

Your email address will not be published. Required fields are marked *