FC: Develop Database Skills By Marvin Spinner's | Developing Database Skills Using Microsoft Access By Marvin Spinner
1: Key Terms Database Helps you to store large amounts of information. Datasheet view A form similar to a spreadsheet that allows records to be entered directly into a table. Design view Where you design and modify tables.
2: Objectives Students will create a database and table. Students will key information into a table and a form.
3: Essential Question How can the use of databases increase productivity in the school/workplace?
4: Real-World Experience Assume that you are creating a database table for a video store. This table will track the checking out and returning of videos. What fields would the database table be likely to contain?
5: Database Organization Think of a database as a file cabinet: 1 drawer holds information on a company’s product. Within each drawer are folders. Information could be about a person or product.
6: Creating a Database Create a new database by opening the File menu and choosing New. The Access startup screen appears. In the New File task pane, choose Blank Database
8: The Microsoft Access Screen The Access screen has a title bar, menu bar, and toolbar. The Status bar is at the bottom of the screen. The Objects bar displays a button for each type of object.
10: Design, Name and Save Table Create the table’s fields in Design view. Each field in a table is divided into three sections: Field Name, Data Type, and Description. Insert data in each of these three sections to create a table. When finished, open the File menu and choose Save. In the Table Name box, key a name that best describes the data to be stored in the table.
11: Field Window
12: Advantages of a Database 1. Enter information 2. Store Large Amounts of Information 3. Find Information quickly 4. Organize Information in Different Ways
13: Real-World Tech How might you use a database to record information about your community?
14: Discussion Questions The first step in creating a table is deciding what fields will be needed. Discuss what fields would be needed for a database of learners’ academic records. The correct data type is very important. Using the list of fields from Question #1, determine the correct data type for each field and why you chose it.
15: The name you choose for a table is also very important. Choose a name for th table designed in Questions 1 and 2. Discuss why you chose this name, and give examples of names that are not appropriate and why. ANY QUESTIONS?
16: Project #1 1. Open Microsoft Access. 2. Create a new database using the filename Software Pros. 3. Create a table in Design View with the following fields: ID, Stock Number, Software, Price, and Beginning Inventory. 4. Save the Table as Software Pros.
17: Project #2 Switch to Datasheet view and enter the records shown on the handout.