Ask a question from expert

Ask now

Accounting Information System (AIS) Assignment

16 Pages1125 Words185 Views
   

Added on  2020-04-15

Accounting Information System (AIS) Assignment

   Added on 2020-04-15

BookmarkShareRelated Documents
ACCOUNTINGINFORMATION SYSTEM
Accounting Information System (AIS) Assignment_1
Table of Contents1.Introduction...................................................................................................................................32.Use of Database.............................................................................................................................33.Database Design............................................................................................................................33.1Table’s Creation....................................................................................................................43.2ER Diagram...........................................................................................................................53.3Form Creation........................................................................................................................83.4Query Creation....................................................................................................................113.5Report Creation....................................................................................................................134.IT controls...................................................................................................................................155.Ethical, Privacy and Security Issues............................................................................................15References...........................................................................................................................................162
Accounting Information System (AIS) Assignment_2
1.IntroductionYou are the coordinator for a project management company. You will be handling thevarious ongoing projects. You also track the commercial project and employee activities andemployee participation in the each project. The project management company needs to createthe new database application to maintain the Project and employee information. So, you needto create the new database applications by using the Microsoft access. The New databaseapplications needs to save the team members information, supplier’s information, materialinformation and project information. These databases also retrieve, delete and update theinformation. The database application will be created.2.Use of DatabaseThe new database application is used to store the following information.Project informationSupplier’s informationPurchased materials informationEmployee InformationThis database also retrieves the project, supplier and employee information. The newdatabase applications also do update, delete and insert operations. It provides the datasecurity. The database application was only accessed by the company administrators. 3.Database DesignThe New database application creation is done by using the Microsoft Access. It is shownbelow (CORONEL, 2017). The Database creation includes the,Table’s creationER Diagram QueryFormReport3
Accounting Information System (AIS) Assignment_3
3.1Table’s CreationEmployee tableMaterial Lists TableProject Description Table4
Accounting Information System (AIS) Assignment_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Fundamentals Report 2022
|12
|526
|39

Logical and Physical Design of International Parcel Service Database
|11
|567
|286

Database Fundamentals: IPS Database Design and Implementation
|10
|535
|105

Database Design with MySQL | Assignment
|9
|739
|235

Database System of International Parcel Service (IPS)
|9
|573
|288

Report On Implementation Of AAS Database
|6
|474
|35