Microsoft Access 2007
by Tim Warner
Start the free chapterMicrosoft Access 2007 helps you effectively track, report, and share information in a manageable environment. With a library of pre-built tracking applications (database solutions) and the Microsoft Office Fluent user interface, Access 2007 does not require deep database knowledge or programming skills. In this VTC course, Author / IT Instructor, Tim Warner introduces users to database design concepts while assisting them in becoming proficient with building and maintaining an Access 2007 database. To begin learning today, simply click on one of the Microsoft Access 2007 links.
Course content
Introducing Access 20077 lessons
Exploring Access 200711 lessons
- Using the Getting Started Window4:121 credit or ad
- Introducing the Ribbon4:481 credit or ad
- Using the Navigation Pane4:331 credit or ad
- Opening and Closing Databases4:311 credit or ad
- Managing Macro Security4:311 credit or ad
- Exploring Tables4:401 credit or ad
- Exploring Queries4:371 credit or ad
- Exploring Forms4:111 credit or ad
- Exploring Reports3:261 credit or ad
- Exploring Macros3:471 credit or ad
- Exploring Modules2:291 credit or ad
Creating a Database9 lessons
- Creating a Database from a Template5:211 credit or ad
- Creating a Database from Scratch4:531 credit or ad
- Creating a Table from a Template4:431 credit or ad
- Creating a Table from Scratch4:571 credit or ad
- Using Fields and Data Types pt. 14:171 credit or ad
- Using Fields and Data Types pt. 24:301 credit or ad
- Setting Table Properties4:401 credit or ad
- Working in Datasheet View pt. 14:521 credit or ad
- Working in Datasheet View pt. 24:541 credit or ad
Importing Data7 lessons
Exporting Data5 lessons
Modifying Table Design12 lessons
- Renaming Tables3:451 credit or ad
- Dropping Tables2:361 credit or ad
- Managing Fields pt. 14:031 credit or ad
- Managing Fields pt. 24:551 credit or ad
- Managing Fields pt. 33:401 credit or ad
- Using Undo and Redo4:521 credit or ad
- Changing the Primary Key pt. 13:511 credit or ad
- Changing the Primary Key pt. 24:101 credit or ad
- Setting Table Relationships pt. 13:561 credit or ad
- Setting Table Relationships pt. 24:451 credit or ad
- Setting Table Relationships pt. 32:471 credit or ad
- Using the Table Analyzer Wizard3:161 credit or ad
Maintaining Data Integrity14 lessons
- Introduction to Data Types4:151 credit or ad
- Managing Data Types pt. 14:021 credit or ad
- Managing Field Data Types pt. 23:121 credit or ad
- Setting Field Length3:171 credit or ad
- Using Input Masks pt. 14:251 credit or ad
- Using Input Masks pt. 24:081 credit or ad
- Using Default Values pt. 13:081 credit or ad
- Using Default Values pt. 23:001 credit or ad
- Setting a Validation Rule4:521 credit or ad
- Creating a Lookup List pt. 13:471 credit or ad
- Creating a Lookup List pt. 23:301 credit or ad
- Creating a Lookup List pt. 34:521 credit or ad
- Compacting the Database1:391 credit or ad
- Backing Up the Database1:191 credit or ad
Using Forms17 lessons
- Understanding Forms4:161 credit or ad
- Navigating in Forms3:541 credit or ad
- Creating a Form Quickly4:411 credit or ad
- Using the Form Wizard4:031 credit or ad
- Understanding Form Views3:391 credit or ad
- Creating a Blank Form pt. 13:221 credit or ad
- Creating a Blank form pt. 23:321 credit or ad
- Aligning Controls4:241 credit or ad
- Sizing Controls4:501 credit or ad
- Controlling Data Input3:441 credit or ad
- Creating an Option Group pt. 13:321 credit or ad
- Creating an Option Group pt. 23:341 credit or ad
- Formatting a Form3:101 credit or ad
- Using AutoFormat2:041 credit or ad
- Setting Tab Order1:331 credit or ad
- Creating Subforms pt. 13:181 credit or ad
- Creating Subforms pt. 23:091 credit or ad
Querying Data15 lessons
- Sorting Table Records4:151 credit or ad
- Using Basic Filters4:031 credit or ad
- Using Filter By Form3:071 credit or ad
- Using Advanced Filters3:311 credit or ad
- Understanding Queries4:191 credit or ad
- Using the Query Wizard4:081 credit or ad
- Designing Select Queries4:301 credit or ad
- Adding Query Criteria4:541 credit or ad
- Designing Parameter Queries3:541 credit or ad
- Using Calculated Fields3:151 credit or ad
- Designing Action Queries pt. 13:581 credit or ad
- Designing Action Queries pt. 23:541 credit or ad
- Designing Action Queries pt. 35:101 credit or ad
- Generating Totals and Averages3:241 credit or ad
- Using Expression Builder3:321 credit or ad
Working with Reports11 lessons
- Understanding Reports2:191 credit or ad
- Creating a Report Quickly3:581 credit or ad
- Using the Report Wizard4:521 credit or ad
- Formatting a Report4:491 credit or ad
- Creating a Blank Report pt. 14:271 credit or ad
- Creating a Blank Report pt. 22:491 credit or ad
- Creating a Blank Report pt. 34:401 credit or ad
- Using Queries in Reports5:261 credit or ad
- Using Calculated Values4:251 credit or ad
- Previewing and Printing a Report3:401 credit or ad
- Saving a Report as PDF3:031 credit or ad
Securing and Sharing Data5 lessons
Customizing Your Database12 lessons
- Creating a Switchboard pt. 14:191 credit or ad
- Creating a Switchboard pt. 23:561 credit or ad
- Creating a Switchboard pt. 33:421 credit or ad
- Understanding the Navigation Pane4:281 credit or ad
- Defining Custom Categories pt. 13:551 credit or ad
- Defining Custom Categories pt. 23:311 credit or ad
- Setting Global Options4:541 credit or ad
- Customizing Quick Access pt. 13:351 credit or ad
- Customizing Quick Access pt. 24:091 credit or ad
- Creating a Custom Ribbon4:381 credit or ad
- Using Performance Analyzer3:411 credit or ad
- Using Database Documenter2:311 credit or ad