Up to 50% + 10% Off Get up to 50% Off + 10% Off! Code: NOEL18 Ends: 12/17 Details

  1. Help
Christmas Delivery Countdown
: :
Up to 50% + 10% Off Get up to 50% Off + 10% Off! Code: NOEL18 Ends: 12/17 Details

Individual Media-Rich Final Assignment (Copy)

Hello, you either have JavaScript turned off or an old version of Adobe's Flash Player. Get the latest Flash player.

Individual Media-Rich Final Assignment (Copy) - Page Text Content

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.

Sizes: mini|medium|large|massive
Default User
  • By: Marvin A.
  • Joined: over 9 years ago
  • Published Mixbooks: 2
No contributors

About This Mixbook

  • Title: Individual Media-Rich Final Assignment (Copy)
  • Tags: None
  • Published: over 9 years ago