1 / 14

Microsoft Access 1

Microsoft Access 1. Database Creation and Management. Overview of Access. One of database management systems software. Access, SQL Server, Oracle, DB 2 MS Access is a relational model (database) . a collection of tables that are related to one another based on a common field .

saul
Download Presentation

Microsoft Access 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Access 1 Database Creation and Management

  2. Overview of Access • One of database management systems software. • Access, SQL Server, Oracle, DB 2 • MS Access is a relational model (database). • a collection of tables that are related to one another based on a common field. • Relational model – developed based on predicate logic and set theory from mathematics.

  3. A schematic diagram of a relational database (a) and a sample part of a relational database showing different tables (b) Relational model (database)

  4. Properties of Relation 1 • Based on the set theory 1. There are no duplicate rows. • The body of the relation is a mathematical set (i.e., a set of rows), and sets in mathematics by definition do not include duplicate elements. • If a "relation" contains duplicate rows, then it is not a relation.

  5. Properties of Relation 2 2. Rows are unordered (top to bottom). • Sets in mathematics are not ordered. So, even if a relation A's rows are reversely ordered, it is still the same relation. • Thus, there is no such thing as "the 5th row" or the last row. In other words, there is no concept of positional addressing.

  6. Properties of Relation 3 3. Columns are unordered (left to right). • The heading of a relation is also defined as a set. • There is no such thing as "5th column" or the last column.

  7. Properties of Relation 4 4. Every value isatomic. • At every row-and-column position within the table, there always exists precisely one value, never a list of values. Or equivalently, relations do not contain repeating groups. ** No two rows can be identical **

  8. A Sample Relation

  9. A Nonrelation Example Cells of the table hold multiple values

  10. Example of a Nonrelational Table No two rows can be identical

  11. Open an existing database • To open an existing database, you must first start Access • When Access is launched you will see the Access window, with the task pane on the right side of the window. • From the task pane, you can open an existing database. • Or simply double-click the existing database to open. • Download and save “Restaurant 1” database.

  12. How Access creates and saves a new database • Create a new database • Your first activity (before question #1) for the midterm is creating a new database. • Database name: your last name + first initial of your first name • When you press the Save button in Access, you are saving the design of the Access objects and NOT the database itself! • The Save function in Access differs from the Save function in other Windows programs.

  13. Valle Coffee’s Restaurant DB • Valle company sells inexpensive coffee beans to various restaurants. Barbara Hennessey, the Director of CRM, and her staff use Access to maintain company data such as customer orders and billings. Barbara has recently developed Restaurant 1 database to track orders and billings. However, she has not been able to develop the database fully to track and maintain other important company data. So, she is asking for your help in completing and maintaining the Valle database.

  14. Descriptions of Restaurant DB • Valle coffee’s Restaurant 1 database will contain five tables: • Customer table, which Barbara already has. • Order table, which you will create soon. • Product and Order Detail tables, which you will import from FineFood database. • Billing Address table that is in Excel format and you will import it, and then convert to Access table.

More Related