With the fully developed model in hand to serve as the construction blueprint, creating the tables in Microsoft Access becomes a simple exercise in following the established plan.
- With all of our pre-planning work done,…we're ready to get started implementing…our database's design, here inside of Microsoft Access.…To get started I'm going to…create a new blank desktop database.…I'll just click on the Blank database icon.…Then I'll bring up a window where I can browse out,…using the folder icon, to choose…where I want to save my database.…I'll just go ahead and place mine here on the desktop.…Then we're going to give the database a filename.…I'll call my TwoTrees.…And press the Create button to start up the new database.…
That gets us started here with a new table called Table1.…I'm going to switch into design view,…in order to start putting in my fields.…We can switch our view either from the Fields tab,…over on the far left; we'll see this View button,…just click on this icon here;…or you can find that same icon…over on the Home tab and in the same position…on the far left.…Let's go ahead and click on the upper portion…with the View button and then I'll switch us…into design view after we save our table name.…
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
- Identify the three rules of relations.
- Summarize the four stages of developing a relational database.
- Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask.
- Explain how to avoid scope creep.
- Recall the characteristics of a Lookup Table.
- Recognize situations in which denormalization would be beneficial.
- Understand the types of relationships modeled by junction tables.
- Define referential integrity.
Skill Level Beginner
1. Relational Database Basics
Relational structures3m 46s
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.