END TERM JURY ASSIGNMENT

SEWING PRODUCTS AND MACHINERY EQUIPMENTS – 1

DATABASE MANAGEMENT SYSTEM

FEED OFF THE ARM MACHINE

MS ACCESS

Submitted To: Submitted By:

Mr. Gangadhar Malik Nabajyoti Bhattacharyya BFT/18/376
Mr. Prabin Rout Rashi Saxena BFT/18/534
Vikas Kumar BFT/18/330

1|Page
 PREFACE
This document covers the end-term jury assignment of Database Management System and
Sewing Products and Machinery Equipments. The assignment consists of detailed use of MS
Access and explanation on Feed Off The Arm Machine.

2|Page
 ACKNOWLEDGEMENT

We would like to express our sincere gratitude to Mr Gangadhar Malik and Mr Pabin Rout for
providing us with an opportunity to present our assignment on Database Management System
and Sewing Products and Machinery Equipments.
We sincerely thank them for their guidance and encouragement in carrying out this project
work.

3|Page
 CONTENTS
Topic Page Number
Feed Off The Arm 5
Parts Of Machine 6
Working Principle 7
Types of Feed Mechanism 7
MS Access 10

4|Page
 FEED OFF THE ARM MACHINE
This machine is actually a chain stitch machine for chain stitch designs working with sew and
stitch.
• It contains loopers instead of bobbin.
• By this machine multithread chain stitch can be produced on garments and also stitch
can be produced on heavy fabrics like denim.
• This machine is largely used for attaching sleeves and for making complex circular
stitches while attaching different parts of the garments.
• Different sizes of needles can be used in this machine depending on the thickness of
fabrics.

• The machine which practices stitches by the loop of one group of thread links with the
loop of other group of thread by the process of interloping is called the industrial feed of
the arm machine.
• There are two types of thread one is called “needle thread” and another one is called
“looper thread”.
• It has opportunity of stitching by folding the fabrics. Different sizes of needle can be
used in this machine depending on thickness of fabrics.

5|Page
 PARTS OF MACHINE

PARTS NAME
1. Machine pulley
2. Front cover
3. Presser foot
4. Needle bar
5. Upper thread guide
6. Lapper

SAFETY DEVICE
7. Thread take up cover
8. Finger guard
9. Pulley cover

6|Page
 WORKING PRINCIPLE
• For the formation of multithread chain stitch, two threads that means one needle
reaches to its lowest bottom designation entering into the fabric with “needle thread”.
• As a result a loop of needle thread is formed.
• Sometimes the thread take-up lever also continuous to go downwards resulting the
decreasing of the tension of the needle thread and it helps in formation of the loop of
the needle thread.
• After the formation of the needle thread loop, the looper from behind the needle enters
into the just produced needle thread loop with looper thread.
• Then, the needle goes upward with needle thread, the fabric also goes forward a step
with the help of feed dog and the looper comes in front of the needle.
• The movement of the looper is controlled by avoiding motion.
• The tension of looper thread is controlled by changing the passage of thread.

TYPES OF FEED MECHANISMS USED IN FEED OFF THE ARM MACHINE

 DROP FEED:
• The drop feed mechanism uses a feed dog below the throat plate that raises up through
the plate, grips the fabric counter to the presser foot to transport the fabric by one
stitch, and then drops below the plate to come back to its original position.
• This mechanism is commonly found in domestic sewing machines and a majority of
industrial sewing machines.
• Also known as Regular Feed Mechanism.

7|Page
PULLER FEED:
• In this kind of feed mechanism, feeding is normally carried out by feed rolls.
• The fabric passes between an upper roller and a sewing bed, or a lower roller and a
presser foot.
• These feed rollers provide a dragging motion on the fabric behind the foot.
• The top roller is normally driven by the machine and the lower roller moves due to the
pressure of the top roller.
• The surface speed of the puller roller is slightly higher than the speed of the feed dog to
presser ply shifting.
• It is useful in multi-needle machines particularly for attaching the waist band.

 TOP FEED:
In a top feed mechanism, the presser foot is made in two different sections.
• One section of the presser foot holds the fabric panel during the stitch formation by the
needle.

8|Page
 • Another presser foot has length on the lower side and wakes in a manner that the top
ply is moved along positively when the needle is in and out of action on the fabric.

Vibrating Presser Foot:

In the case of a vibrating presser foot, the forward and backward motions of the presser foot
are not driven; however, they are spring loaded as shown in Figure-5. The presser foot has
teeth that aids in the movement of fabric along with the feed dog. It has a vibrating motion
forward with the feeding process and backward with the return stroke. Generally it is
constructed with a lifting motion during its return stroke to enable the presser foot to clear the
fabric and to lower comparatively straight down onto an uneven section of the fabric without
interference. It is commonly known as a walking foot or top feed.

Alternating Presser Foot:

It has a couple of presser feet that alternately press against the fabric (Figure-6). When one foot
is aiding in moving the fabric along, the other foot is raised to clear the fabric. These actions will
take place alternatively. Out of two presser feet, one is normally a vibrating presser foot
whereas another presser foot is a rising and descending one. The vibrating foot will facilitate in
fabric feeding and the rising and descending foot will grip the fabric down between feeding
motions.

Walking Foot

9|Page
 MS ACCESS
Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the
relational Microsoft Jet Database Engine with a graphical user interface and software
development tools. It is a member of the Microsoft Office suite of applications, included in the
professional and higher editions.
 Microsoft Access is just one part of Microsoft’s overall data management product
strategy.
 It stores data in its own format based on the Access Jet Database Engine.
 Like relational databases, Microsoft Access also allows you to link related information
easily. For example, customer and order data. However, Access 2013 also complements
other database products because it has several powerful connectivity features.
 It can also import or link directly to data stored in other applications and databases.
 As its name implies, Access can work directly with data from other sources, including
many popular PC database programs, with many SQL (Structured Query Language)
databases on the desktop, on servers, on minicomputers, or on mainframes, and with
data stored on Internet or intranet web servers.
 Access can also understand and use a wide variety of other data formats, including
many other database file structures.
 You can export data to and import data from word processing files, spreadsheets, or
database files directly.
 Access can work with most popular databases that support the Open Database
Connectivity (ODBC) standard, including SQL Server, Oracle, and DB2.
 Software developers can use Microsoft Access to develop application software.

Important Terms and Basic Objects

Database File:

It is a file which stores the entire database. The database file is saved to your hard drive or
other storage devices.

Data Types:

Data types are the properties of each field. Every field has one data type like text,
number, date, etc.

10 | P a g e
Type of Data Description Size

Short Text Text, including numbers which does not Up to 255 characters.
need calculation. (e.g., Mobile numbers).

Long Text This data type is used for lengthy text or Maximum 63, 999 characters.
alphanumeric data.

Number Numeric data type used for storing 1, 2, 4, 8, and 16 bytes.

mathematical calculations.

Date/Time Store Date/time for the years 100 8 bytes.

through 9999.

Currency It allows you to store currency values 8 bytes.

and numeric data with one to four
decimal places.

Auto Number Assign a unique number or assigned by Four bytes (16 bytes if it is set
Microsoft Access when any new record is as a Replication ID).
created. Usually used as the primary key

Yes/No It only stores logical values Yes and No. 1 bit

Hyperlink Text or combinations of text and Each part of a Hyperlink data

numbers stored. That text is used as type allows you to store a
hyperlink address. maximum 2048 characters.

Calculated Helps you to create an expression that You can create an expression
uses data from one or more fields. which uses data from one or
more fields.

11 | P a g e
How to Create a Database

Before we create Database, lets quickly understand the holistic picture of what Database is,
with particular reference to MS ACCESS.

Let's, start with a few examples in real life:

 We have Bookcase where Books resides,

 We have i-pods where we have a collection of music & cases are countless.

Similarly, we have MS Access Database is a kind of home for all your tables, queries, Forms,
Reports, etc. in MS-ACCESS which are interlinked.

Technically, Database store the data in a well-organized manner for easy access and retrieval.

There are two ways to create Database in SQL ACCESS:

1. Create Database from Template

2. Create a Blank Database

Table

A Table is an object which stores data in Row & Column format to store data.

 A Table is usually related to other tables in the database file.

 Each column must have Unique name
 We can also define Primary Key in a table.

Creating Table

The first step to store data in the database is to create a Table where data will reside. Post
creation of the table, we can keep inserting the rows in the table.

There are two ways to create Database in MS ACCESS

1. Create a Table from Design View

Displays the view, which allows you to enter fields, data types, and descriptions into
your database table.

2. Create a Table from Datasheet View.

12 | P a g e
Query

 Queries answer a question by selecting and sorting and filtering data based on search
criteria.
 Queries show a selection of data based on criteria (limitations) you provide.
 Queries can pull from one or more related Tables and other Queries.
 Types of Query can be SELECT, INSERT, UPDATE, DELETE.

13 | P a g e
Form

 A form is a database object that you can use to create a user interface for a database
application.
 It mainly used to ease the process of data entry or editing.
 Data in a form can be selected from one or more tables.
 Forms can also be used to control access to data, like which fields or rows of data are
visible to which users.
 Forms have a Form View.
 Help you to display live data with easy creation of new data .

How to Create a form

There are four primary ways to create the form as mentioned below:

 Form Wizard
 Form
 Multiple Item
 Split Form

Create using Form Wizard

This option allows the user to create the form with the wizard and select the column from the
available list of column form in legacy Select window format .

Create using Form

It is the simplest way to create the form which will:

 By default, populate all the column from the selected table in 'form view,'
 The user can delete non-required column manually

 Create form by Multiple Item

It is another type wherein all the records already created will be displayed in Form with an
option to add new record.

Create form by Split from

It is a mix of simple form and split form in a way that this form provides the view of Form and
datasheet in a split window. Whatever the user enters in Form is visible directly in Datasheet
view immediately and vice versa.

14 | P a g e
Edit the existing record via Form.

 One of the features of forms is that we can edit the values and data directly from the
form.
 It is more user-friendly because as compared to row format in the table, forms have
better visibility of selected fields and the user can do the direct updates.
 These values updated from forms will also be reflected in original tables immediately

Add a record to a Form.

 Forms also give the flexibility to Add records.

 Again, this is a user-friendly and appealing way of adding records as compared to adding
records in a row form.

Design View

15 | P a g e
 Form View

Report

 A report is an object in MS Access that is designed for formatting, calculating and

printing selected data in an organized way.
 It contains information from tables and also information that are there in the report
design.
 Reports are helpful as they allow you to present all information of your database in an
easy-to-read format.

16 | P a g e
Design View

Report View

17 | P a g e
Advantages of MS ACCESS

Here, are the pros/benefits for using MS Access application:

 Access offers a fully functional, relational database management system in minutes.

 Easy to import data from multiple sources into Access
 You can easily customize Access according to personal and company needs
 Access works well with many of the development languages that work on Windows OS
 It is robust and flexible, and it can perform any challenging office or industrial database
tasks.
 MS-Access allows you to link to data in its existing location and use it for viewing,
updating, querying, and reporting.
 Allows you to create tables, queries, forms, and reports, and connect with the help of
Macros
 Macros in Access is a simple programming construct with which you can use to add
functionality to your database.
 It can perform heterogeneous joins between various data sets stored across different
platforms.

Disadvantages of MS-ACCESS

Here, are the cons for using MS Access

 Microsoft Access is useful for small-to-medium business sectors. However, it is not

useful for large-sized organizations
 Lacks robustness compared to DBMS systems like MS SQL Server or Oracle
 All the information from your database is saved into one file. This can slow down
reports, queries, and forms
 Technical limit is 255 concurrent users. However, the real-world limit is only 10 to 80
(depending on the type of application which we are using).

18 | P a g e
 REFERENCE
 textilescommittee.nic.in
 textilestudycenter.com
 www.iigm.in
 www.tutorialspoint.com

19 | P a g e