Microsoft Access 2010
This hands-on Microsoft Access 2010 introductory course will teach students how to use essential features of Microsoft Access 2010 and discover how to build a database and store your data more efficiently.
Accurate data is essential in a successful business. Microsoft Access 2010 course shows how to manage, create, and analyze effective databases. It starts with Access fundamentals and moves on to topics like filters, queries, forms, and reports.
Access is now much more than a way to create desktop databases. It’s an easy-to-use tool for quickly creating browser-based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure than ever, and you can easily share your applications with colleagues.
What Will I Learn?
- The Fundamentals
- Creating and Working with a Database
- Finding, Filtering, and Formatting Data
- Working with Tables
- Creating Relational Databases
- Working with Queries
- Working with Forms
- Working with Reports
- Advanced Topics
Click here to enroll in this course.
- Lesson 1a: Understand the Screen, Open and Save a Database, Work with Database Objects
- Lesson 1b: Tour of Tables, Tour of Queries, Tour of Forms, Tour of Reports, Help, Close and Exit Access
Creating and Working with a Database
- Lesson 2a: Plan a Database, Create a Database, Add, Edit, and Delete Records, Select Data, Cut, Copy, and Paste Data
- Lesson 2b: Use Undo and Redo, Check Spelling, Use the Zoom Box, Preview and Print
Finding, Filtering, and Formatting Data
- Lesson 3a: Find and Replace Data, Sort Records, Use Common Filters, Filter by Selection, Filter by Form, Create an Advanced Filter
- Lesson 3b: Adjust Rows and Columns, Change Gridlines and Cell Effects, Freeze a Column, Hide a Column
Working with Tables
- Lesson 4a: Create a Table, Understand Field Types and Properties, Index a Field, Add a Primary Key, Insert, Reorder, and Delete Fields, Add Field Descriptions and Captions, Change the Field Size, Format Number, Currency, and Date/Time Fields
- Lesson 4b: Format Text Fields, Set a Default Value, Require Data Entry, Validate Data, Create an Input Mask, Create a Lookup Field, Create a Value List, Modify a Lookup List
Creating Relational Datebases
- Lesson 5a: Table Relationships and Relationship Types, Create Relationships Between Tables, Enforce Referential Integrity, Print and Delete Relationships
Working with Queries
- Lesson 6a: Create a Query, Sort a Query, Use AND and OR operators in a Query, Create a Multiple Table Query, Create a Calculated Field, Work with Expressions and the Expression Builder
- Lesson 6b: Use an IIF Function, Summarize Groups of Records, Display Top or Bottom Values, Parameter Queries, Find Duplicate Records, Find Unmatched Records
- Lesson 6c: Crosstab Queries, Delete Queries, Append Queries, Make-Table Queries, Update Queries
Working with Forms
- Lesson 7a: Create a Form with the Form Wizard, Create and Use a Form, Modify a Form in Layout View, Form Design View Basics, Change the Tab Order, Work with Control Properties, Work with Form Properties
- Lesson 7b: Change a Control’s Data Source, Create a Calculated Control, Change a Control’s Default Value, Create a Subform, Work with and Modify Subforms
Working with Reports
- Lesson 8a: Create a Report, Use the Report Wizard, Use the Label Wizard, Work in Layout View, Format Fonts, Copy Formatting, Change Text Alignment
- Lesson 8b: Insert a Logo, Adjust Page Margin and Orientation, Add Page Numbers and Dates, Group and Sort, Summarize Data using Totals, Understand Report Sections
- Lesson 9a: Use Conditional Formatting, Work with Number Formatting, Use Themes, Import Information, Export Information, Link External Information
- Lesson 9b: Mail Merge Records to Word,Use Hyperlink Fields, Database Object Dependencies, Compact and Repair a Database, Convert an Access Database