Learn Microsoft Access 2013 - DVD Training Course

Description: Become a master of the new version of Microsoft’s database program when taking our Microsoft Access 2013 training course. Not only will you learn all the new features and enhancements, but our self-study Access 2013 training videos are taught by certified instructors in the field that have years of experience in the corporate training world. With our Microsoft Access 2013 training course, you will learn from a variety of interactive components that make learning fun while still informative. Busy professionals don’t have to take time off of work or miss out on family time when learning from our self-study Access 2013 training videos either. This DVD course is easy to use and do not require Internet access. So you can learn at anytime and anytime, You can always go back to learn as many as times you can without any monthly fee nor registration fee. Learn Microsoft Access 2013 - DVD Training Course Learn Microsoft Access 2013 - DVD Training Course Click image to enlarge Description Become a master of the new version of Microsoft’s database program when taking our Microsoft Access 2013 training course. Not only will you learn all the new features and enhancements, but our self-study Access 2013 training videos are taught by certified instructors in the field that have years of experience in the corporate training world. With our Microsoft Access 2013 training course, you will learn from a variety of interactive components that make learning fun while still informative. Busy professionals don’t have to take time off of work or miss out on family time when learning from our self-study Access 2013 training videos either. Course Outline: Microsoft Access 2013 Basic 1.0 Getting Started with Access 2013 1.1 Introduction 1.2 Starting and Closing Access 1.3 Identifying Tabs, Ribbons, The Quick Access Toolbar and Locating the Backstag 1.4 Identifying Account Information and Switching Users 1.5 Opening Existing and Recently Used Databases 1.6 Identifying the Primary Access Objects 1.7 Exploring the Different Access Views 1.8 Understanding Five Essential Steps for Database Design 1.9 Creating a New Database 1.10 Getting Help 2.0 The Essential Access Building Block: Tables 2.1 Introduction 2.2 Creating Tables 2.3 Identifying Data Types 2.4 Setting Basic Properties 2.5 Setting Additional Properties 2.6 Controlling Data Using Input Masks 2.7 Establishing a Primary Key 2.8 Creating Table Relationships 2.9 Establishing Referential Integrity 2.10 Identifying Table Relationship Types 3.0 Working with Access Data 3.1 Introduction 3.2 Entering Table Data 3.3 Deleting and Changing Records 3.4 Using Find, Replace and Go To Features 3.5 Sorting and Filtering Records 3.6 Modifying Tables: Rename, Copy, Delete, Save As 3.7 Viewing Data from Related Tables 4.0 Queries 4.1 Introduction 4.2 Introducing Queries 4.3 Creating a Select Query Using the Wizard 4.4 Building a Select Query in Design View 4.5 Adding Criteria to a Query 4.6 Asking And/or Questions 4.7 Using Wildcards to Find Data 4.8 Setting Query Properties 5.0 Designing Forms 5.1 Introduction 5.2 Worksheet Tab Configuration 5.3 View and Zoom 5.4 Setting Panes and Split Windows 5.5 Working with Multiple Windows 6.0 Generating Reports 6.1 Introduction 6.2 Printing your Workbook 6.3 Advanced Printing Options 6.4 Sharing as Other File Types Microsoft Access 2013 Intermediate 1.0 Enhancing Tables 1.1 Introduction 1.2 Validation Rules and Validation Text 1.3 Creating an Input Mask 1.4 Using Lookup Wizard to Restrict Data Entry 1.5 Using Hyperlink in Tables 1.6 Utilizing OLE Data Type 2.0 Using a Variety of Query Types 2.1 Introduction 2.2 Creating a Query with Two or More Tables 2.3 Creating a Parameter Query 2.4 Creating an Update Query 2.5 Creating an Append Query 2.6 Creating a Delete Query 2.7 Making Table Query 2.8 Finding the Duplicates Using the Wizard 2.9 Finding the Unmatched Using the Wizard 2.10 Using the Record Group Tool 2.11 Showing Top Values 3.0 Enhancing Forms 3.1 Introduction 3.2 Setting Tab Stops on Forms 3.3 Adding Buttons to Forms 3.4 Drawing Elements and Inserting Graphics 3.5 Controlling Form Input Using Option Groups 3.6 Aligning and Distributing Controls 3.7 Changing the Default View of the Form 4.0 Enhancing Reports 4.1 Introduction 4.2 Adding a Calculated Field 4.3 Applying Conditional Formatting 4.4 Hiding Fields and Duplicates 4.5 Creating Backgrounds 4.6 Inserting Page Breaks and Creating Headers and Footers 4.7 Grouping and Sorting 5.0 Maintaining and Customizing database 5.1 Introduction 5.2 Examing the Database Object Relationships 5.3 Documenting the Access Database 5.4 Protecting Data with a Password 5.5 Creating Custom Ribbon Tabs 5.6 Establishing Startup Options and Custom Icons 5.7 Customizing the Navigation Pane 5.8 Changing the Default Save location Microsoft Access 2013 Advanced 1.0 Recording and Using Macro 1.1 Introduction 1.2 Looking at the Macro Environment 1.3 Creating a Macro 1.4 Finding Macro 1.5 Attaching a Macro to a Form Button 1.6 Creatng an AutoExec Macro 1.7 Using Access with Other Applicaton 2.0 Applying Database Tools 2.1 Introduction 2.2 Creating a Database Backup 2.3 Compacting and Repairing a Database 2.4 Splitting a Database 2.5 Converting a Database to an ACCDE File 2.6 Exploring Access Options 3.0 Using Access with Other Applications 3.1 Introduction 3.2 Importing Excel 3.3 Exporting Data to Excel 3.4 Exporting to PDF 3.5 Exporting to Mail Merge in Word 3.6 Publishing in HTML to a Web Browser 3.7 Sharing via E-Mail 4.0 Applying Query Tools 4.1 Introduction 4.2 Adding Calculated Fields 4.3 Splitting a Single Field into Multiple Field 4.4 Converting Text to Proper Case 4.5 Organizing with the Partition Function 4.6 Querying Dates 4.7 Nesting IIf Functions 4.8 Developing a Union Query 4.9 Setting a Starting AutoNumber 4.10 Creating a Self Join Query Content: DVD-ROM disc (sealed in a DVD-case) System Requirements: Platform: Windows 10, 8, 7 and Vista Processor: Pentium 133 Mhz or higher RAM: 32MB Hard drive space: 10MB CD-ROM Drive speed: 24 Pictures sell! Auctiva offers Free Image Hosting and Editing.300+ Listing Templates! Auctiva gets you noticed! The complete eBay Selling Solution. Track Page Views With Auctiva's FREE Counter

Price: 29.95 USD

Location: Burlingame, California

End Time: 2024-03-16T07:21:47.000Z

Shipping Cost: 7.95 USD