1 pdf.pdf

Welcome to ‘Intermediate Computer Application’ ‘COMP 103’ Andre Ghosh – Business Program Week #10 1 Agenda ▪ LO’s ▪ Module 7: Integration Level 2 Lecture and Lab Week 11: Test 20% on Database 2 LO’s 1. Use the Flem...

Welcome to ‘Intermediate Computer Application’ ‘COMP 103’ Andre Ghosh – Business Program Week #10 1 Agenda ▪ LO’s ▪ Module 7: Integration Level 2 Lecture and Lab Week 11: Test 20% on Database 2 LO’s 1. Use the Fleming Network account appropriately and responsibly to complete assignments 3. Customize business materials to suit specific requirements and enhance professional appearance = we will learn Word in Business 4 Open and manage multiple Microsoft Office and Windows applications in order to share data sources in the production of business materials. 5 Use functions in the Microsoft Office software applications to share, link, or embed data between applications. 6. Design a database using multiple tables and appropriate relationships where necessary. 7. Use basic database functions to create and modify tables, forms, queries, and reports. 8. Identify the most appropriate Microsoft Office software application to solve a business information need. 3 Relational Database Review Relational Database We have done 2 databases so far: Authors – Books Students – Courses Today you will create Customers – Tea Products Relational Database Relational Database : a collection of related tables that stores, and provides access to, organizes, and retrieves data that are related to one another. In a relational database: Each row in the table is a record with a unique ID called the key. The columns of the table hold attributes of the data, and each record usually has a value for each attribute, making it easy to establish the relationships among data points. A non-relational database is a database that doesn't rely on the relationships between tables to store and retrieve data. https://www.oracle.com/ca Relational Database Database elements or components: 1. Tables and (Keys) 2. Forms 3. Queries 4. Reports Relational Database Example of a tables in a database Unique ID: Columns: Fields = Attributes of the records Primary Key Rows: Records  Relational Database https://www.tutorialsteacher.com/  Relational Database https://www.tutorialsteacher.com/  Relational Database https://www.tutorialsteacher.com/ Relational Database PK PK FK 12 Relational Database Foreign Key Primary Key (Author ID is not displayed in this example, but Author last name is (referenced through the Primary key Author ID in Authors table) Integration 14 Integration Import a Table into Access Import a report into Word 15 Create Relational Database Customers Tea Products Create Relational Database Customers Tea Products A tea company sells tea products to customers Tea sales information is imported to Access from an Excel sheet Access processes the tea sales information and produces a report The report is exported to MS Word and as a PDF files Create Relational Database Creating Customers table Create Relational Database importing Tea sales information from Excel to Access 1 2 3 4  Create Relational Database importing Tea sales information from Excel to Access  Create Relational Database importing Tea sales information from Excel to Access  Create Relational Database importing Tea sales information from Excel to Access  Create Relational Database importing Tea sales information from Excel to Access importing Tea sales information from Excel to Access Establishing a 1 to many relationship between Customers and Tea Products tables Foreign Key (Author ID is not displayed Primary Key in this example, but Author last name is (referenced through the Primary key Author ID in Authors table) Adding additional field/attributed and entering data into Tea Products table Creating Query from Tea Products Creating Query from Tea Products Creating Query from Tea Products Adding a new expression using Builder, apply a filter criteria for the Price > $15 Use Run ! to apply the changes in the Query The results of the Query Creating the Report Creating the Report Exporting the Report to Word and PDF Next Week 11 Week 11 Module 8. PowerPoint Lecture and Lab Test 20% Questions ? 37 Thank you! FlemingCollegeToronto.ca 38