Microsoft Access 2013 Basic Level Current Status Not Enrolled Price Free Get Started Login to Enroll Course Content Expand All Basic Course Introduction 1 Topic Expand Lesson Content 0% Complete 0/1 Steps Introduction to Basic Level 1.0 Getting Started with Access 2013 9 Topics Expand Lesson Content 0% Complete 0/9 Steps 1.1 Starting and Closing Access 1.2 Identifying Tabs, Ribbons, QAT and Backstage 1.3 Identifying Account Information and Switching Users 1.4 Opening Existing and Recently Used Databases 1.5 Identifying the Primary Access Objects: Tables, Queries, Forms & Reports 1.6 Exploring the Different Access Views 1.7 Understanding Five Essential Steps for Database Design 1.8 Creating a New Database 1.9 Getting Help 2.0 Learning the Essential Access Building Blocks-Tables 9 Topics Expand Lesson Content 0% Complete 0/9 Steps 2.1 Creating Tables 2.2 identifying Data Types 2.3 Setting Basic Properties: Field Size, Format, Caption and Default Value 2.4 Setting Additional Properties: Required, Allow Zero Length, Indexed and Others 2.5 Controlling Data Using Input Masks 2.6 Establishing a Primary Key 2.7 Creating Table Relationships 2.8 Establishing Referential Integrity 2.9 Identifying Table Relationships 3.0 Working with Access Data 6 Topics Expand Lesson Content 0% Complete 0/6 Steps 3.1 Entering Table Data 3.2 Deleting and Changing Records 3.3 Using Find, Replace and Go To Features 3.4 Sorting and Filtering Records 3.5 Modifying Tables: Rename, Copy, Delete, Save As 3.6 Viewing Data from Related Tables 4.0 Using Queries 7 Topics Expand Lesson Content 0% Complete 0/7 Steps 4.1 Introducing Queries 4.2 Creating a Select Query Using the Wizard 4.3 Building a Select Query in Design View 4.4 Adding Criteria to a Query 4.5 Asking And/or Questions 4.6 Using Wildcards to Find Data 4.7 Setting Query Properties 5.0 Designing Reports 7 Topics Expand Lesson Content 0% Complete 0/7 Steps 5.1 Using an Access Form 5.2 Creating a Form Using The Form Wizard 5.3 Creating a Form FromScratch 5.4 Improving a Form Using The Form Design Tools 5.5 Adding a Calculated Field 5.6 Looking at Form Properties 5.7 Using the Data Entry Property 6.0 Generating Reports 7 Topics Expand Lesson Content 0% Complete 0/7 Steps 6.1 Viewing an Access Report 6.2 Creating an Access Report from Scratch 6.3 Creating an Access Report Using the Wizard 6.4 Looking at Report Properties 6.5 Applying a Theme to a Report 6.6 Preparing a Report for Print 6.7 Making Changes to a Report