MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 ChGenre: eLearning | Language: English + .VTT | Duration: 3 hours | Size: 1.63 GBUnderstanding the Basic Principles and Starting to Design Access DatabasesWhat you’ll learnThis training course is designed to enable users to get to grips with the main features of Access, including a thorough treatment of the new ‘Ribbon’ interface.

RequirementsDelegates should be proficient in using a PC with the Windows operating system, but no prior experience with Access is required.

DescriptionMODULE 1: Getting Started with AccessLearning outcomes: Understand how to start Microsoft Access and some of its basic navigation and help controls.

Topics covered:Starting OutInterface BasicsDatabase SecurityGetting HelpMODULE 2: The New Ribbon InterfaceLearning outcomes: Exploring the Ribbon’s different tabs and options.

Topics covered:The Quick Access ToolbarBasics of TabsThe Home TabThe Create TabThe External Data TabThe Database Tools TabMODULE 3: Creating a Simple DatabaseLearning outcomes: Creating basic tables and a look at the different types of fields available.

Topics covered:First Steps in Database CreationDatabase RecordsCreating a TableFormatting TextMODULE 4: Forms; Queries; Reports and FiltersLearning outcomes: Creating basic forms, queries, reports and filters; essential to the successful creation and administration of an Access Database.

Topics covered:Creating and Using FormsCreating and Using QueriesCreating and Using ReportsSorting and Filtering DataViewing DataPrinting a Database ObjectWho this course is for:The course is intended for new users of MS Access 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time.