Сообщения

Exercise #28

Изображение
  How do I do an order form in Excel:  Create Product Drop Downs On the Order Form worksheet, select cells B10:B14. On the Excel Ribbon's Data tab, click Data Validation. From the Allow dropdown, choose List. In the Source box, type: =ProductList. Click the OK button. What are orders in Excel: Excel employs a common arithmetic process called "order of operations" when assessing a calculation. Excel's sequence of operations is based on the acronym PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction), but with some tweaks to deal with the formula syntax in a spreadsheet. What is an Excel form: A form is a collection of controls, like boxes and dropdown lists, that make it easy for others to input or change data in your worksheet. See Excel templates for additional information on templates you may download.

Exercise #27

Изображение
  Where is data analysis on Excel: Q.   Where is the data analysis button in Excel? Click the File tab, click Options, and then click the Add-Ins category. In the Manage box, select Excel Add-ins and then click Go. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. How do you do data analysis on Excel: To access the Add-Ins category, navigate to the File tab, Options, and Add-Ins. Select Excel Add-ins from the Manage drop-down menu and click Go. Check the Analysis ToolPak check box in the Add-Ins box before clicking OK. Is Excel enough for Data Analysis: For data analysis, Excel is insufficient. If you simply need to conduct simple activities like percentages and distributions, Excel spreadsheets may be sufficient. If you want to go beyond the fundamentals, though, Excel will not suffice. Excel may be a bit dangerous to rely for sophisticated analyses.

Homework #6

Изображение
  What is DBMS easy definition: A database management system, sometimes known as a DBMS, is essentially a computerised data-keeping system. Users of the system are given the ability to execute a variety of actions on it, such as manipulating the data in the database or managing the database structure itself.  What is DBMS with example: The database management system (DBMS) organises and maintains incoming data, as well as allowing users and other applications to modify or extract it. MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro are some examples of database management systems.  What is a DBMS and what are its functions: Summary of the lesson. A database management system (DBMS) is a piece of software that allows you to arrange data in a database. The abbreviation DBMS is commonly used to refer to it. Concurrency, security, backup and recovery, integrity, and data descriptions are all features of a database managemen...

Exercise #25

Изображение
  What are database products examples: MySQL, Microsoft Access, Microsoft SQL Server, FileMaker Pro, Oracle Database, and dBASE are examples of prominent database management systems (DBMSs).  What are 3 examples of a database: Examples: Microsoft SQL Server, Oracle Database, MySQL, PostgreSQL and IBM Db2. Examples: Apache Cassandra, MongoDB, CouchDB, and CouchBase. Examples: Microsoft Azure SQL Database, Amazon Relational Database Service, Oracle Autonomous Database.  What is a database product: A product database may be readily defined as an organised collection of product-related data that is kept and maintained electronically. These data are referred to as product specifications.

Exercise #24

Изображение
  What is customer database: A customer database is a collection of data that comprises contact information for leads such as first and last names, phone numbers, and email addresses, among other things. It can also contain the following information: Age, gender, marital status, and family composition are all demographic factors. What are customer databases called: Customer relationship management systems (CRM) are a type of database that stores customer information (CRM).

Exercise #23

Изображение
What is entity relationship diagram design:   An entity relationship diagram (ERD), often called an entity relationship model, is a graphical depiction of relationships between people, things, locations, concepts, and events in an information technology (IT) system. What is entity relationship diagram with example: An entity is a type of data item or component. In an ER diagram, an entity is represented by a rectangle. Consider the following scenario: We have two entities in the following ER diagram: Student and College, and these two entities have a many to one connection since many students attend a single college.