MGMT2006 – Management Information Systems Report 2022

Running head: MGMT2006 – Management Information Systems
MGMT2006 – Management Information Systems
Name of the Student
Name of the University
Author Note

MGMT2006 – Management Information Systems 1
Introduction and Background:
MGMT HARDWARE, runs a chain of 14 buildings that supplies stores that are
located in 4 of the Caribbean countries. The organisation caters for the wide set of items as
well as wide set of services that include home delivery, building materials, household
materials, online ordering, retail sales, drive through sales and order online pickup in store
sales. The organisation is having an ecommerce website that is centrally branded which caters
to the requirements of the all 4 countries as well as then presents a feel and consistent look to
all the consumers. The locations that are situated within the country can connect over the
Metro-E wide area network (WAN) that are provided by FLOW. However, there is no such
connectivity for country to country. It is because the organisation grew by the acquisitions
and mergers, not in all the locations utilize the similar ERP (Enterprise Resource Planning)
software. Each of the stores are having an offline server which can ensure about the location
is able to still sell and receive the stock whenever the WAN goes down.
Some reports needs to be produced that are relate to sales and stocks that is for an upcoming
tradeshow.
MS access:
DBMS means Database management system which is a Microsoft access. It's comes from
Microsoft which combines the software and a graphical user interface with the relational
Microsoft jet database engine with the development tools. Database management system is a
part of the Microsoft office, which was suite of applications. It is sold separately and also
included higher editions and professional. In this system Microsoft access can stores data,
and it's based on privet format mode, which access the jet database engine. In this system it
can also link directly or import to stored data in databases and other applications. Application
software was developed to access the Microsoft, which can use the data architects, software

MGMT2006 – Management Information Systems 2
developers, and power users. VBA (visual basic for applications) is supported to access the
Microsoft office applications, which based on an object that can programming the language
to including the legacy of Data Access Objects (DAO) for reference the variety of objects. In
this system it gets many other components of ActiveX and mainly the ActiveX data objects.
In the VBA (Visual basic for applications) programing environment visual objects can used
for exposed the reports and forms in the properties and methods. Windows operating system
operations which was declare or call as VBA code modules.
Importing excel data to access:
Setting up primary keys:

MGMT2006 – Management Information Systems 3
Relationship:
Queries:
Q1-Cat10Items:
SELECT Items.[Item No], Items.Descr, Items.Cat, Items.[Sub Cat], Items.[Selling Price],
Items.[Average Cost]
FROM Items
WHERE (((Items.Cat)="where")) OR (((Items.Cat) Like "10"))
ORDER BY Items.Cat;