Course Description:

Learning objectives: – If you’re thinking about buying Office 2013, there are a few things you should consider before your purchase. – Learn what you need to know about Office 365, a subscription-based version of Office 2013. – Learn all about an Access database and how it works. – Learn about each of the four objects in Access to understand how they interact with each other to create a fully functional relational database. – Familiarize yourself with the Access environment, including the Ribbon, Backstage view, Navigation pane, Document Tabs bar, and Record Navigation bar. – Learn how to to open and close an Access database, as well as how to open, close, and save objects. – Learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. – Learn how to use forms to enter new records and view and edit existing ones. – Learn how to sort and filter data so you can customize how you organize and view your data. – Learn how to create a simple one-table query. – Learn how to create a complex multi-table query. – Learn how to modify and sort queries, and discover different query-building options. – Learn learn how to create, modify, and print reports. – Learn how to use the Report Wizard to create complex reports and use Access formatting options to change the look of your report. – Learn how to create and rearrange table fields, as well as set validation rules, character limits, and data types. – Learn how to create and modify forms using options like design controls and form properties. – Learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts. – Learn how to create a database from an existing template and find resources to learn more about database design. – Learn how to create calculated fields and totals rows. – Learn how to run an Access duplicates query to erase duplicates and strengthen your database. – Use this quick reference guide for 20 of the most common criteria used in Access queries. – Learn more about free alternatives to using Microsoft Office, including Google Docs, Office Online, OpenOffice, and LibreOffice. – Test your knowledge of Access by taking our quiz.

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.