Front end & Back end

Front End (design user interface):
Back End  (binary files, Database):

SQL  -> structured query language

Desktop applications:
   Front end and back end are on the same system

Distributed Applications (Client-server application):
   Front end and back end are on the different system

software developer
database administrator
network administrator
hardware engineers
.....
....

Microsoft Access:
            complete RDMBS

Northwind sample database project:

Main Components of Microsoft Access Database:
- Tables
- Queries
- Forms
- Reports
- Macros
- Modules  
        (VBA  -> visual basic application)
- Pages (data access pages)

Tables: provide basic Structure to store data, all data is stored in rows and columns, each column is a Field, each row is a record

Creating tables in Microsoft Access:
- Select Tables from database object list
      - Create table by using wizard
      - Create table by Entering Data
      - Create table in Design View
          - table designer window

Table designer window: to create/modify table structure

Table structure: style of storage of data
- Field name (column name)
- Data Type
- Field Properties
- Field Description