sony products and sales
TRANSCRIPT
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 1/19
PROJECTOf
WIT
CHANDIGARH BUSINESS
SCHOOL Page 1
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 2/19
Submitted to-:submitted by-:mr.Vikrant jaswal gouravarora
MBA–2ND SEM{D}
Roll no :
105462251424
Microsoft Office AccessMicrosoft Office Access, previously known as Microsoft Access, is a
relational database management system 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 or
sold separately. In mid-May 2010, the current version of Microsoft Access
2010 was released by Microsoft in Office 2010; Microsoft Office Access
2007 was the prior version.
Access stores data in its own format based on the Access Jet DatabaseEngine. It can also import or link directly to data stored in other
applications and databases.
Software developers and data architects can use Microsoft Access to
develop application software, and "power users" can use it to build simple
applications. Like other Office applications, Access is supported by Visual
Basic for Applications, an object-oriented programming language that can
reference a variety of objects including DAO (Data Access Objects),
ActiveX Data Objects, and many other ActiveX components. Visualobjects used in forms and reports expose their methods and properties in
the VBA programming environment, and VBA code modules may declare
and call Windows operating-system functions.
CHANDIGARH BUSINESS
SCHOOL Page 2
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 3/19
Microsoft Access is used to make databases.
When reviewing Microsoft Access in the real world, it should be
understood how it is used with other products. An all-Access solution mayhave Microsoft Access Forms and Reports managing Microsoft Access
tables. However, Microsoft Access may be used only as the 'front-end',
using another product for the 'back-end' tables, such as Microsoft SQL
Server and non-Microsoft products such as Oracle and Sybase. Similarly,
some applications will only use the Microsoft Access tables and use another
product as a front-end, such as Visual Basic or ASP.NET. Microsoft Access
may be only part of the solution in more complex applications, where it
may be integrated with other technologies such as Microsoft Excel,
Microsoft Outlook or ActiveX Data Objects.
Access tables support a variety of standard field types, indices, and
referential integrity. Access also includes a query interface, forms to
display and enter data, and reports for printing. The underlying Jet
database, which contains these objects, is multiuser-aware and handles
record-locking and referential integrity including cascading, updates and
deletes.
Repetitive tasks can be automated through macros with point-and-click options. Microsoft Access is popular among non-programmers and
professional developers alike. Non-programmers can create visually
pleasing and relatively advanced solutions with very little or no code. It is
also easy to place a database on a network and have multiple users share
and update data without overwriting each other's work. Data is locked at
the record level which is significantly different from Excel which locks the
entire spreadsheet.
CHANDIGARH BUSINESS
SCHOOL Page 3
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 4/19
Microsoft offers a wide range of template databases within the program
and for download from their website. These options are available upon
starting Access and allow users to enhance a database with pre-defined
tables, queries, forms, reports, and macros. Popular templates include
tracking contacts, assets, issues, events, projects, and tasks. Templates do
not include VBA code.
Access 2010 allows databases to be published to SharePoint 2010 web sites
running Access Services. These web-based forms and reports run in any
modern web browser. The resulting web forms and reports, when accessed
via a web browser, don't require any add-ins or extensions (e.g. ActiveX,
Silverlight.
FeaturesUsers can create tables, queries, forms and reports, and connect them together with
macros. Advanced users can use VBA to write rich solutions with advanced data
manipulation and user control.
The original concept of Access was for end users to be able to "access" data from any
source. Other uses include: the import and export of data to many formats includingExcel, Outlook , ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc. It
also has the ability to link to data in its existing location and use it for viewing,
querying, editing, and reporting. This allows the existing data to change and the Access
platform to always use the latest data. It can perform heterogeneous joins between data
sets stored across different platforms. Access is often used by people downloading data
from enterprise level databases for manipulation, analysis, and reporting locally.
There is also the Jet Database format (MDB or ACCDB in Access 2007) which can
contain the application and data in one file. This makes it very convenient to distribute
the entire application to another user, who can run it in disconnected environments.
One of the benefits of Access from a programmer's perspective is its relative
compatibility with SQL (structured query language) — queries can be viewed
graphically or edited as SQL statements, and SQL statements can be used directly in
Macros and VBA Modules to manipulate Access tables. Users can mix and use both
VBA and "Macros" for programming forms and logic and offers object-oriented
possibilities. VBA can also be included in queries.
CHANDIGARH BUSINESS
SCHOOL Page 4
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 5/19
Microsoft Access offers parameterized queries. These queries and Access tables can be
referenced from other programs like VB6 and .NET through DAO or ADO. From
Microsoft Access, VBA can reference parameterized stored procedures via ADO.
The desktop editions of Microsoft SQL Server can be used with Access as an alternative
to the Jet Database Engine. This support started with MSDE (Microsoft SQL Server
Desktop Engine), a scaled down version of Microsoft SQL Server 2000, and continues
with the SQL Server Express versions of SQL Server 2005 and 2008.
Microsoft Access is a file server-based database. Unlike client–server relational
database management systems (RDBMS), Microsoft Access does not implement
database triggers, stored procedures, or transaction logging. Access 2010 includes
table-level triggers and stored procedures built into the ACE data engine. Thus a
Client-server database system is not a requirement for using stored procedures or tabletriggers with Access 2010. Tables, queries, Forms, reports and Macros can now be
developed specifically for web base application in Access 2010. Integration with
Microsoft SharePoint 2010 is also highly improved.
Advantages of MS AccessThe first advantage that comes to mind is how familiar the interface is to most users.
The Office 2007 interface style is familiar, so users who have other Office products will
not be lost when dealing with Access.
There are two ways to view the database, no matter whether you are creating a new one
or opening something existing. The data view and the design view make it easy to set up
Access and start using it. You can enforce discipline when entering data through the
data entry forms. All kinds of rules to make sure you enter the right kind of data can be
implemented.
Access has become an industry standard in desktop use and the database engine is quite
powerful. Integration with voice recognition features makes data entry and menu
navigation quite easy. There are a large number of templates, including the ones you
can download online, which makes creating new databases quite easy. The ability tocustomize them not only lets you get productive quickly, but you can also adjust things
to fit your specific needs. Connectivity options are a strong asset; Access databases can
connect to Excel tables, ODBC connectors, SQL Servers, and SharePoint Services sites
for live data. Tables created in these sources can be linked and used for generating
reports. These reports then give you a better view/analysis of your data. Data
harvesting from a large number of e-mail addresses is possible too.
CHANDIGARH BUSINESS
SCHOOL Page 5
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 6/19
Multiple reports can be created for the same set of data. You are able to use the
grouping, sorting and filtering options to get more perspectives on the same data. Real
time previews let you create the different versions of the report that you may need forvarious audiences.
DisadvantagesAccess has been designed for desktop use, more like a personal database. It can support
multiple users over a workgroup alright; the total number of users (usually around 50or so simultaneous) is small however. That means Access is more useful for individual
departments or the SMB (small and medium business sectors). Access also has
difficulty dealing with databases larger than 2GB in size, though just to be safe one
should limit usage to about 1GB.
As you scale up the size, performance becomes sluggish (almost to the point of
unresponsiveness). Use of multimedia data, even your digital camera photos can eat up
space very quickly. Until the 2007 version came along, even the way the images and
other attachments used to be stored in Access databases caused a bloat. Though the
attachment field in Access 2007 takes care of that, the overall 2 GB space could limityou very quickly. Many indicate that the SQL Server is a more real database, since it
competes with enterprise-level databases like Oracle.
Another difficulty pointed out by many is how publishing anything other than static
files is a problem with Access. It takes quite a bit of work to make data access
interactive. You could use Sharepoint but that represents a significantly large
investment. Many believe that the SQL in MS Access is not as robust as other
databases.
CHANDIGARH BUSINESS
SCHOOL Page 6
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 7/19
Components of Access:
1. Database Window: Here all objects of a database are stored in
single file having extension MDB. The objects are managed through
the database window.
2. Database and table: Database is a collection of information
retained in the form of table. Table consists of rows and columns.
Each table stores information about one entity such as student,
customer, product etc.
CHANDIGARH BUSINESS
SCHOOL Page 7
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 8/19
Applications of Access:
Access is used by small business, within departments of large
corporations, and hobby programmers to create ad hoc customized desktopsystem for handling the creation and manipulation of data. Access can also beused as the database for basic web based applications hosted on Microsoft’s
Internet Information Services and utilizing Microsoft Active server Pages ASP.More complex web applications may require tools like PHP/My SQL or ASP/Microsoft SQL server.Hardware and Software Requirements of Access:Access in Window 95 based program so Microsoft Window 95 or Window NTshould be installed on a target computer. A computer may have 80386, 80486or Pentium based processor with minimum 8 MB of RAM, VGA graphic displayadapter and a mouse.
CHANDIGARH BUSINESS
SCHOOL Page 8
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 9/19
Database Tables Include:
✔ SONY Air Conditioner
✔ SONY Refrigerator
✔
SONY Washing Machine
✔ SONY Mobile Phone
CHANDIGARH BUSINESS
SCHOOL Page 9
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 10/19
INITIALIZATION OF MS-ACCESS
CHANDIGARH BUSINESS
SCHOOL Page 10
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 11/19
CHANDIGARH BUSINESS
SCHOOL Page 11
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 12/19
CREATING A DATABASE
CHANDIGARH BUSINESS
SCHOOL Page 12
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 13/19
SONY AIR CONDITIONER
This is the table of SONY product for sales for AC . In this table hasseveral fields like as sales % in the north region , % sales in south region ,% sales in west region , % sales in east rigion , Total % of sales , Total %
of product , Remaing % of product and the last is % grow in AC share .
CHANDIGARH BUSINESS
SCHOOL Page 13
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 14/19
SONY REFREGRETAR TABLE
This is the table of Sony product for sales for Refregreter . In this tablehas several fields like as sales % in the north region , % sales in southregion , % sales in west region , % sales in east rigion , Total % of sales ,Total % of product , Remaing % of product and the last is % grow inRefregreter share .
CHANDIGARH BUSINESS
SCHOOL Page 14
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 15/19
SONY WASHING MACHINE
This is the table of SONY product for sales for Washing Machine . In thistable has several fields like as sales % in the north region , % sales in
CHANDIGARH BUSINESS
SCHOOL Page 15
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 16/19
south region , % sales in west region , % sales in east rigion , Total % of sales , Total % of product , Remaing % of product and the last is % grow
in Washing Machine share .
CHANDIGARH BUSINESS
SCHOOL Page 16
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 17/19
SONY MOBILE PHONES
This is the table of sony product for sales for Mobile phones . In this tablehas several fields like as sales % in the north region , % sales in southregion , % sales in west region , % sales in east rigion , Total % of sales ,Total % of product , Remaing % of product and the last is % grow inMobile phones .
CHANDIGARH BUSINESS
SCHOOL Page 17
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 18/19
RELATIONSHIP BETWEEN TABLES
CHANDIGARH BUSINESS
SCHOOL Page 18
8/3/2019 SONY Products and Sales
http://slidepdf.com/reader/full/sony-products-and-sales 19/19
CHANDIGARH BUSINESS
SCHOOL Page 19