Creating a Database in Microsoft Access

Introduction

• Instructor: Richard Rost from AccessLearningZone.com
• Focus: Creating a new database in Microsoft Access.

Step 1: Opening Access

• Launch Microsoft Access.
• Recent databases will be listed if opened previously.
• Templates are available from others; select "Blank Database" to create your own.

Step 2: Naming the Database

• Default file name: Database1 (not descriptive).
• Suggested name: "customers".
• Database location: Saved in the user’s Documents folder (can be changed).
• Click "Create" to generate the blank database.

Step 3: Understanding Tables

• Data is stored in one or more tables (similar to Excel spreadsheets).
• First table is created by default (Table1).
  • Rename the table to reflect its content (e.g., "customerT").
  • Use a consistent naming convention (e.g., _T for tables, _Q for queries).

Step 4: Designing the Table

• Define fields (columns) in the table:
  • Click on "Click to Add" to specify the data type.
  • Recommended data types: Short Text, Number, Currency, Date & Time.
• Example fields:
  • First Name (Short Text)
  • Last Name (Short Text)
• Avoid spaces in field names (use camel case).

Step 5: Entering Data

• Input data like in a spreadsheet:
  • Example: Rick Rost, Jim Kirk, Jean-Luc Picard.
• Each record (row) is identifiable by an ID field (Auto Number).
• To add more fields, continue specifying data types and names.

Step 6: Saving the Table

• Close the table; prompt to save changes will appear.
• Confirm to save as "customerT".

Step 7: Opening the Database

• Access saved database easily from Recent list or browse to its location.
• Security warning for first-time opening: Click "Enable Content".

Additional Resources

• Free Microsoft Access Beginner Level 1 Course (4 hours long).
• Condensed version available (30 minutes).
• Links to courses provided in the video description.
• Subscribe for notifications on new uploads.

Community Engagement

• Comments are welcome; instructor tries to respond.
• Join mailing list for email alerts on new videos.
• Membership options available for additional perks.

Membership Benefits

• Silver Members: Extended cut videos, one free beginner class/month.
• Gold Members: Download sample databases, access to code vault.
• Platinum Members: Access to all beginner courses, higher priority for questions.
• Diamond Sponsors: Name/company listed on sponsor page, shout-out in videos.

Conclusion

• Encouragement to explore more about Access on the website.
• Thank you for watching!
• Closing remarks: "Live long and prosper!"