1 / 6

Advanced Databases Introduction

Advanced Databases Introduction. Dawn Squires Brooks County High School. What is a database?. Software containing a collection of data that can be manipulated and/or retrieved as needed and in a specified manner. Access is one type of database software that we will use.

lavanya
Download Presentation

Advanced Databases Introduction

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. Advanced Databases Introduction Dawn Squires Brooks County High School

  2. What is a database? • Software containing a collection of data that can be manipulated and/or retrieved as needed and in a specified manner. • Access is one type of database software that we will use. • Other examples of database software are: • QuickBase – from the makers of QuickBooks (Intuit) • dQuery • Alpha Five • FileMaker Pro 10

  3. What are key features of Access? • Easy to enter and update data • Easy to ask questions of the database and have it give you answers. • Easy to create nice looking forms to view and enter/update data. • Easy to create classy-looking reports. • Can even be utilized via the web.

  4. Review of what you already know . . . Fields – columns that contain specific information inside of a record Record – rows that contain info about a specific person, product, etc.

  5. What I’ve found . . . • From my years of experience working as an administrative assistant in various types of offices, I have found that usually one doesn’t start out to design a database and begin entering data. Usually, you have data in Word documents and Excel files that you realize would be more useful if you had them incorporated into a database. If they were in a database, you would be able to extract only the information needed at a particular time. A database is born!

  6. What I’ve found continued . . . • I’ve compiled data in various types of file formats that we will incorporate into a database. This data will be used for both Access units on forms and reports. • Have fun!

More Related