1 / 9

1) What is a Database?

1) What is a Database?. A database is an organized collection of information about a subject. Examples: Address Book, Telephone Book. 2) How is an Access Database Organized? What is the file extension for Access 2007 and Access 2003?. Access maintains all its objects in one database file.

nenet
Download Presentation

1) What is a Database?

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. 1) What is a Database? • A database is an organized collection of information about a subject. • Examples: Address Book, Telephone Book

  2. 2) How is an Access Database Organized? What is the file extension for Access 2007 and Access 2003? • Access maintains all its objects in one database file. • The file extension for Access 2007 is .accdb • The file extension for Access 2003 is .mdb

  3. 3) What is a Navigation Pane? • When you first open the Access Database you will see the Navigation Pane. • It displays a list of the objects in a database. • It can be minimized or maximized.

  4. 4) What are the four main types of objects? What are the two additional more advanced types of objects? • Four main types are: Tables, Queries, Forms, and Reports. • Two advanced types are: Macros and Modules

  5. 5) What is a row called? What is a column called? What are field contents? • Access is like Excel in some ways, but it has more advanced database features. • A spreadsheet is an object that is now called a table. • A row is now called a record. • A column is now called a field. • The header for a column is now called a field Name. • The data in a field is now the field contents.

  6. 6) What is a form? • A form is a window for viewing the data in one or more tables. • Forms can be used to view, input, or edit data. • They show the information for one record on one single page.

  7. 7) What is a query? • A query allows you to see or work with a portion of a table by limiting the number of fields and by selecting specific records. • What would be the closest similar command that completes the same in Excel?

  8. 8) What is a report? • A report is formatted information from a table or query that can be sent to a printer. • It can be a detailed list of records, calculated values, and totals, or a chart summarizing the data.

  9. 9) What is a relational database? • Database tables that share common fields are related. • If there are tables that are related in a database, then it is called a relational database.

More Related