MICROSOFT ACCESS 2019 DELUXE Training Tutorial Course with Quick Reference Guide

Description: MICROSOFT ACCESS 2019 DELUXE Training Tutorial Course with Quick Reference Guide Mastering Access Made Easy DELUXE Self-Study Training Course Product Details:Product Name: Mastering Access Made Easy Manufacturer: TeachUcomp, Inc. Versions Covered: 2019 & 365 Course Length: 5 Hours Video Lessons: 108 Instruction Manuals: 189 pages (PDF) Practice Exam: Included Final Exam: Included Certificate of Completion: Included Quick Reference Guide: 2 Pages, Laminated, 25 Topics Product Type: DELUXELearn Microsoft Access with this Deluxe training package from TeachUcomp, Inc. Mastering Access Made Easy Deluxe features 108 video lessons with over 5 hours of introductory through advanced instruction on both DVD-ROM to play on your PC and via online for one year (with enclosed Online Key Code) to view the course on your computer or mobile device. In addition, you’ll get our Access 2019 Quick Reference Guide- a two-page printed, laminated guide with step-by-step instructions in the most critical functions. Pop in the DVD-ROM or launch the online version to watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our printable classroom instruction manual in PDF (189 pages), additional images and practice exercises.This package also includes an optional practice exam with evaluative feedback, an optional final exam and a Certificate of Completion when you pass the final exam. Test your knowledge after completing the course and demonstrate your proficiency. Whether you are completely new to Access or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Note: A copy of the software is not included with this purchase. This is a tutorial only. Topics Covered:Getting Acquainted with Access1. Creating a New Database2. Overview of a Database3. The Access Interface4. Touch Mode5. Viewing Database Objects in the Navigation Bar6. Opening and Closing DatabasesCreating Relational Database Tables1. The Flat-File Method of Data Storage2. The Relational Model of Data Storage3. Tips for Creating a Relational Database4. Creating Relational Database Tables5. Assigning a Primary Key to a TableUsing Tables1. Using Datasheet View2. Navigating in Datasheet View3. Adding Records in Database View4. Editing and Deleting Records in Datasheet View5. Inserting New Fields6. Renaming Fields7. Deleting FieldsField Properties1. Setting Field Properties2. The Field Size Property3. The Format Property for Date/Time Fields4. The Format Property for Logical Fields5. Setting Default Values for Fields6. Setting Input Masks7. Setting Up Validation Rules and Responses8. Requiring Field Input9. Allowing Zero Length EntriesJoining Tables1. The Relationships Window2. Enforcing Referential Integrity3. Creating Lookup FieldsIndexing Tables1. Indexes2. Creating Indexes3. Deleting IndexesQueries1. Using the Simple Query Wizard2. Designing Queries3. Joining Tables in a Query4. Adding Criteria to the QBE Grid5. Running a Query6. SQL View7. Sorting Query Results8. Hiding Fields in a Result Set9. Using Comparison Operators10. Using AND and OR ConditionsAdvanced Queries1. Using the Between… And Condition2. Using Wildcard Characters in Queries3. Creating a Calculated Field4. Creating Top Value Queries5. Aggregate Function Queries6. Parameter QueriesAdvanced Query Types1. Make Table Queries2. Update Queries3. Append Queries4. Delete Queries5. Crosstab Queries6. The Find Duplicates Query7. Removing Duplicate Records from a Table8. The Find Unmatched QueryCreating Forms1. Forms Overview2. The Form Wizard3. Creating Forms4. Using Forms5. Form and Report Layout View6. Form and Report Design View7. Viewing the Ruler and Grid8. The Snap to Grid Feature9. Creating a Form in Design View10. Modifying Form Sections in Design ViewForm & Report Controls1. Selecting Controls2. Deleting Controls3. Moving and Resizing Controls4. Sizing Controls to Fit5. Nudging Controls6. Aligning, Spacing, and Sizing Controls7. Formatting Controls8. Viewing Control PropertiesUsing Controls1. The Controls List2. Adding Label Controls3. Adding Logos and Image Controls4. Adding Line and Rectangle Controls5. Adding Combo Box Controls6. Adding List Box Controls7. Setting Tab OrderSubforms1. Creating Subforms2. Using the Subform or Subreport ControlReports1. Using the Report Wizard2. Creating Basic Reports3. Creating a Report in Design View4. Sorting and Grouping Data in Reports5. Creating Calculated FieldsSubreports1. Creating SubreportsCharting Data1. Using Charts2. Insert a Modern ChartMacros1. Creating a Standalone Macro2. Assigning Macros to a Command Button3. Assigning Macros to Events4. Using Program Flow with Macros5. Creating Autoexec Macros6. Creating Data Macros7. Editing Named Data Macros8. Renaming and Deleting Named Data MacrosSwitchboard and Navigation Forms1. Creating a Switchboard Form2. Creating a Navigation Form3. Controlling Startup BehaviorAdvanced Features1. Getting External Data2. Exporting Data3. Setting a Database PasswordHelping Yourself1. Using Access Help2. The Tell Me Bar Minimum System Requirements:1 GHz Intel Pentium Processor or equivalentWindows or MAC1 GB RAM256 color SVGA capable of 1024x768 resolutionSpeakers or headphonesDVD-ROM Drive Payment Shipping Returns Contact We accept PayPal for all orders- the safest way to shop on eBay. Physical Products: We offer FREE shipping on all U.S. orders. Your order will be shipped within 1 business day of receiving payment (Monday-Friday). In the very unlikely event that your item is lost or damaged during shipment, please be sure to let us know. We will issue either a full refund or replacement. If you are not 100% satisfied with your purchase, you can return the product and get a full refund (minus any shipping costs) or exchange the product for another one. You can return a product for up to 30 days from the date you purchased it. Any physical product you return must be in the same condition you received it and in the original sealed packaging. Please use the eBay message center to contact us. This assures that we receive your message. We are open Monday through Friday 9-5 Eastern and will answer you within one business day. We're always happy to answer questions. We want to make your buying experience as pleasurable as possible. Listing and template services provided by inkFrog

Price: 44 USD

Location: East Lansing, Michigan

End Time: 2023-12-11T21:08:35.000Z

Shipping Cost: 0 USD