Office training – Microsoft Office.Microsoft Access Academic Course, MS Access Tutorial PDF Book | Free PDF Books
Webinar: 8 great timesavers in Outlook. Archive or back up your mailbox. Password protect your mailbox. Share or publish your Office calendar. Use rules to manage your email. Webinar: Archiving items in Outlook. Apply and change a theme. Apply transitions between slides. Create speaker notes. Create your first PowerPoint presentation. Highlight text and change fonts.
Print slides, notes, or handouts. Use Presenter view. Backgrounds in PowerPoint. Crop a picture to fit a shape. Group shapes or pictures. Make the switch to PowerPoint Webinar: YouTube videos in PowerPoint. Webinar: Ways to avoid rebuilding PowerPoints over and over. Webinar: 5 steps to a better PowerPoint. Working with watermarks. Work with handout masters. Add a sound effect to a transition.
Add bullets to text. Add headers and footers to a presentation. Add sound effects to an animation. Animate pictures, clip art, text, and other objects. Create a flow chart. Create an org chart. Create a template from a presentation. Design motion paths. Insert a bar chart. Insert a line chart. Insert a pie chart. Insert a video from your PC. Insert music and time it to your slides. Rehearse timings for a slide show. Trigger an animation effect. Use slide masters to customize a presentation.
Create your first Word document. Custom margins in Word Line spacing. Spell-check basics. Top tips for working in Word for the web.
Track changes. Webinar: 5 things to raise your game to a college level. Work with word counts in your document. Create labels. Creating an MLA paper with citations and a bibliography. Footnotes in Word Make the switch to Word Mirror margins in Word Resumes in Word.
Take tables of contents TOCs to the next level. Use landscape and portrait orientation. Using Styles in Word. Webinar: Creating forms in Word. Advanced mail merge. Advanced tables of contents. Collapsible headings. Mail merge. Take mail merge to the next level. Office training Office More Access Beginner Design and build tables for a database Access basics, part 1 Create table relationships Access basics, part 2 Create your first Access database Introduction to queries Access basics, part 3 Webinar: Intro to Access Intermediate Dealing with read-only queries Stop a query from asking for input Use parameter queries to filter query results Use update queries to change data in Access Query criteria 2: Using date criteria in queries.
Need more help? Expand your Office skills. Get new features first. Was this information helpful? Yes No. Lesson Notes Subscribed users can add notes to any lesson for future reference. Course Overview What Access Is New in Access Grows Up The Future of Access Access Alternatives Database What a Database Is Database Types Database Organization Understanding Tables Understanding Data Types pt.
Primary Key Basics Understanding Indexes pt. Database Design Database Design Options Understanding Normalization Understanding Relationships Relationship Types pt. Understanding Integrity Getting Started with Access Where to Start Introducing Office Access Database Objects Installing Access pt. Creating a Database Access Interface Tour Database Backups Working with Tables.
Creating Our Database Datasheet or Design Creating Tables pt. Data Types pt. Editing Table Structures Using Input Masks Deleting Rows Required Fields Adding a Primary Key Creating an Index Deleting a Table Access Relationships. Identifying Relationships Design Meets Relationships Creating a Relationship pt. Managing Relationships Viewing Object Dependencies Data Retrieval.
Understanding Queries Access and SQL Query Types Creating Queries pt. Make Table Queries Understanding Join Queries Union Queries Top Queries Distinct Queries Query Filters Append Queries Delete Queries Data Management Options Data Forms and Reports.
Access gives you templates that run on your computer or in the cloud.