Microsoft Access 2010: Beginner to Advanced
About this course
Microsoft Access 2010 course covers basic, intermediate, and advanced features of MS Access 2010 software. Access 2010 is a database application, design, and deployment tool that users use to keep track of important information. Users of this software can keep data on their computer, or they can publish it to the Web, so that other users may access the database with a web browser. Access databases can help the user store and track just about any kind of information, such as inventory, contacts, or business processes.
Microsoft Access makes it easier to analyze substantial amounts of information and relational data more efficiently than using Excel or other spreadsheet applications.
Course Outline
Introduction
- Instructor Introduction
- Access Overview
- Course Outline
Section 1: Access Basics
- Section Overview
- What Does Access Do?
- Access Application Window
- Database Objects
- Basic Database and Table Management
- Customizing Access
- Keyboard Shortcuts
- Section Review
Section 2: Designing a Database
- Section Overview
- Database Design Process
- Normalizing Data
- Setting Primary and Foreign Keys
- Section Review
Section 3: Building a Database
- Section Overview
- Creating A New Database
- Creating Tables
- Inserting Field’s in Tables
- Setting Up Field Properties
- Formatting the Datasheet View
- Creating Relationships
- Keyboard Shortcuts
- Section Review
Section 4: Managing Table Data
- Section Overview
- Updating and Deleting Records
- Finding and Replacing Values
- Adding a Total Row
- Using Sub-datasheets
- Sorting Data
- Filtering Data
- Keyboard Shortcuts
- Section Review
Section 5: Creating Selection Queries
- Section Overview
- Creating Queries Using the Query Wizard
- Creating Queries Using the Query Design View
- Adding Criteria
- Add Calculated Fields to Query
- Section Review
Section 6: Creating and Managing Forms
- Section Overview
- Form Basics and Creating Forms
- Contextual Tabs Design and Layout View
- Managing Table Data with Forms
- Modifying the Look and Design
- Design Tab Controls
- Section Review
Section 7: Creating and Managing Reports
- Section Overview
- Creating Reports, Report Views, and Managing Report Sections
- Adding Calculated Fields and Formatting The Report Controls
- Section Review
Section 8: Controlling Data Entry
- Section Overview
- Setting Field Properties
- Validation Rules
- Input Mask
- Create Lookup Field
- Section Review
Section 9: Finding and Joining Data
- Section Overview
- Inner and Outer Joins
- Joining Unrelated Tables and Relating Data Within Tables
- Section Review
Section 10: Creating Flexible Queries
- Section Overview
- Select Query Properties
- Parameter Queries
- Using Wild Cards
- Creating Action Queries
- Section Review