
Microsoft Access 2013
Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there. To begin learning today, simply click on the movie links.
Course content
Welcome7 lessons
Database 1019 lessons
- What a Database Is3:581 credit or ad
- Database Types5:111 credit or ad
- Database Organization4:311 credit or ad
- Understanding Tables4:131 credit or ad
- Understanding Data Types pt. 14:321 credit or ad
- Understanding Data Types pt. 26:141 credit or ad
- Primary Key Basics4:301 credit or ad
- Understanding Indexes pt. 15:071 credit or ad
- Understanding Indexes pt. 25:231 credit or ad
Database Design 1016 lessons
Getting Started with Access 20138 lessons
- Where to Start4:391 credit or ad
- Introducing Office 3654:031 credit or ad
- Access Database Objects4:581 credit or ad
- Installing Access 2013 pt. 14:291 credit or ad
- Installing Access 2013 pt. 24:201 credit or ad
- Creating a Database5:241 credit or ad
- Access Interface Tour7:091 credit or ad
- Database Backups2:151 credit or ad
Working with Tables15 lessons
- Creating Our Database5:021 credit or ad
- Datasheet or Design5:211 credit or ad
- Creating Tables pt. 15:541 credit or ad
- Creating Tables pt. 25:481 credit or ad
- Data Types pt. 16:181 credit or ad
- Data Types pt. 24:071 credit or ad
- Editing Table Structures4:301 credit or ad
- Date/Time Formats pt. 14:091 credit or ad
- Date/Time Formats pt. 25:041 credit or ad
- Using Input Masks4:541 credit or ad
- Deleting Rows3:001 credit or ad
- Required Fields4:061 credit or ad
- Adding a Primary Key6:261 credit or ad
- Creating an Index5:161 credit or ad
- Deleting a Table4:081 credit or ad
Access Relationships7 lessons
- Identifying Relationships2:181 credit or ad
- Design Meets Relationships3:561 credit or ad
- Creating a Relationship pt. 17:191 credit or ad
- Creating a Relationship pt. 26:391 credit or ad
- Creating a Relationship pt. 35:481 credit or ad
- Managing Relationships4:071 credit or ad
- Viewing Object Dependencies4:171 credit or ad
Data Retrieval14 lessons
- Understanding Queries4:471 credit or ad
- Access and SQL6:301 credit or ad
- Query Types4:101 credit or ad
- Creating Queries pt. 16:371 credit or ad
- Creating Queries pt. 26:191 credit or ad
- Make Table Queries6:231 credit or ad
- Understanding Join Queries4:431 credit or ad
- Union Queries4:051 credit or ad
- Top Queries4:391 credit or ad
- Distinct Queries4:001 credit or ad
- Query Filters3:131 credit or ad
- Append Queries3:331 credit or ad
- Delete Queries3:161 credit or ad
- Data Management Options2:211 credit or ad