Access – introductionA one-day workshop This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. ObjectivesAudienceFormatObjectivesLearning objectivesThis course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports AudienceWho should attend?This workshop offers useful shortcuts and is therefore also suitable for those who are self-taught. No previous Access experience required. Designed for Office 365 versions: 2016, 2013 and 2010 FormatFormat A very practical, interactive one-day session for a maximum group size of 12. Comprehensive materials provided. 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records Download PDF Any questions? Please just give us a call on 01582 463463 – we’re here to help!