
Microsoft Access 2010
As part of the release of the Office 2010 software suite, Microsoft is introducing the latest version of Access, their entry-level database application software. Don't let the words 'entry-level' fool you, this is one very powerful database tool. Access was designed to collect, store, manage, report, and dissect data for individuals and small businesses. The release of the 2010 version continues to raise the bar of what an entry-level database product can do. In this course, Mark Long takes you from opening Access 2010 for the first time through the entire process of creating a database. He covers tables, queries, forms, reports, and many of the other bells and whistles that make up Access 2010. Click the movie links below to get started now!
Course content
Introduction5 lessons
Database Basics7 lessons
Database Design Basics7 lessons
Access 2010 Basics6 lessons
Working with Tables21 lessons
- Creating Our Database3:481 credit or ad
- Quick Access Toolbar Shortcut2:031 credit or ad
- Datasheet or Design?3:441 credit or ad
- Access Data Types3:251 credit or ad
- Field Size Settings5:251 credit or ad
- Date/Time Formats2:581 credit or ad
- Custom Date/Time Formats4:321 credit or ad
- Creating Our Tables5:571 credit or ad
- Required Fields3:051 credit or ad
- Deleting Rows1:371 credit or ad
- Input Masks3:301 credit or ad
- Setting the Field Size3:211 credit or ad
- Default Values3:451 credit or ad
- Allow Zero Length5:381 credit or ad
- Renaming Fields & Tables3:421 credit or ad
- Editing a Table5:151 credit or ad
- Data Validation5:571 credit or ad
- Adding an Index5:361 credit or ad
- Deleting a Table3:221 credit or ad
- Using Caption2:381 credit or ad
- Using the Data Documenter5:321 credit or ad
Relationships4 lessons
Working with Datasheet View8 lessons
Accessing Your Data15 lessons
- Query Basics5:241 credit or ad
- Access & SQL4:441 credit or ad
- Access 2010 Query Types5:331 credit or ad
- Using the Query Wizard4:281 credit or ad
- Using the Query Design View5:031 credit or ad
- Writing Queries in SQL5:091 credit or ad
- Total Queries5:371 credit or ad
- Make Table Queries5:181 credit or ad
- Action Queries5:121 credit or ad
- Crosstab Queries5:561 credit or ad
- Union Queries4:481 credit or ad
- Top Queries4:091 credit or ad
- Multi-Table Queries6:401 credit or ad
- Understanding Query Joins5:451 credit or ad
- Distinct Queries3:201 credit or ad
Data Forms16 lessons
- Access 2010 Forms3:211 credit or ad
- Why Use Forms?3:591 credit or ad
- Using AutoForm3:211 credit or ad
- Using the Form Wizard4:321 credit or ad
- Starting from Scratch6:441 credit or ad
- Layout or Design View?5:071 credit or ad
- Form Controls3:001 credit or ad
- Adding Controls6:261 credit or ad
- Using the Control Wizard6:301 credit or ad
- Control Properties4:221 credit or ad
- Using Combo Boxes pt. 15:481 credit or ad
- Using Combo Boxes pt. 24:371 credit or ad
- Navigation Form3:551 credit or ad
- Setting the Tab Order3:341 credit or ad
- Creating a Pop-up Form pt. 13:251 credit or ad
- Creating a Pop-up Form pt. 24:201 credit or ad
Access 2010 Reports14 lessons
- Report Basics5:041 credit or ad
- Report Types3:111 credit or ad
- Reports the Easy Way3:121 credit or ad
- Reports the Wizard Way5:571 credit or ad
- Reports the Real Way4:341 credit or ad
- Finding the Data4:201 credit or ad
- Basic Report Design4:351 credit or ad
- Sorting & Grouping Data4:361 credit or ad
- Report Headers5:151 credit or ad
- Group & Sum Totals6:001 credit or ad
- Using Expressions4:211 credit or ad
- Report Cosmetics pt. 16:381 credit or ad
- Report Cosmetics pt. 27:001 credit or ad
- Report Cosmetics pt. 34:481 credit or ad