{"course":{"productid":24602,"modality":1,"active":true,"language":"en","title":"Microsoft Access 365 for End Users","productcode":"ACS365A","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-ACS365A","courseware":{"has_ekit":false,"has_printkit":true,"language":"de"},"url":"https:\/\/portal.flane.de\/course\/training-acs365a","contents":"<ul>\n<li>1 Get to know Access<\/li><li>2 Working with databases<\/li><li>3 Data entry in forms<\/li><li>4 Data entry in tables<\/li><li>5 Search, replace, sort data<\/li><li>6 Filter data<\/li><li>7 Working with queries<\/li><li>8 Relationships between tables<\/li><li>9 Print reports and data<\/li><li>10 Create new database<\/li><li>11 Create tables<\/li><li>12 Create forms<\/li><li>13 Edit forms<\/li><li>14 Create queries<\/li><li>15 Create reports and labels<\/li><li>16 Edit database objects<\/li><li>17 Manage databases<\/li><\/ul>","outline":"<h5> 1 Get to know Access<\/h5><ul>\n<li>1.1 Basic knowledge of databases<\/li><li>1.2 Start Access and open database<\/li><li>1.3 Access windows at a glance<\/li><li>1.4 Using the ribbon<\/li><li>1.5 Using Access Help<\/li><li>1.6 Closing databases and exiting Access<\/li><li>1.7 Exercise<\/li><\/ul>\n<h5> 2 Working with databases<\/h5><ul>\n<li>2.1 Navigation area and start form<\/li><li>2.2 Customizing the Navigation Area<\/li><li>2.3 Opening and closing objects<\/li><li>2.4 Exercise<\/li><\/ul>\n<h5> 3 Data entry in forms<\/h5><ul>\n<li>3.1 Basic knowledge of forms<\/li><li>3.2 Basic knowledge of data types<\/li><li>3.3 Entering a new data record<\/li><li>3.4 Special features of data entry<\/li><li>3.5 AutoCorrect function<\/li><li>3.6 Spell check<\/li><li>3.7 Editing and deleting records<\/li><li>3.8 Exercise<\/li><\/ul><h5> 4 Data entry in tables<\/h5><ul>\n<li>4.1 Basic knowledge tables<\/li><li>4.2 Data input<\/li><li>4.3 Edit and delete data<\/li><li>4.4 Copy or move data<\/li><li>4.5 Change table layout<\/li><li>4.6 Evaluating columns with functions<\/li><li>4.7 Exercise<\/li><\/ul><h5> 5 Search, replace, sort data<\/h5><ul>\n<li>5.1 Search and replace data<\/li><li>5.2 Sorting data records<\/li><li>5.3 Exercise<\/li><\/ul>\n<h5> 6 Filter data<\/h5><ul>\n<li>6.1 Basic knowledge of filters<\/li><li>6.2 General filters<\/li><li>6.3 Deactivate, activate or delete filters<\/li><li>6.4 The value list<\/li><li>6.5 Selection-based filters<\/li><li>6.6 Exercise<\/li><\/ul><h5> 7 Working with queries<\/h5><ul>\n<li>7.1 Basic knowledge of queries<\/li><li>7.2 Execute queries<\/li><li>7.3 Exercise<\/li><\/ul><h5> 8 Relationships between tables<\/h5><ul>\n<li>8.1 Basic knowledge of relationships<\/li><li>8.2 Basic knowledge of primary and foreign keys<\/li><li>8.3 Types of relationships<\/li><li>8.4 Reference integrity<\/li><li>8.5 Display relationships<\/li><li>8.6 Dependent data in forms<\/li><li>8.7 Dependent data in the data sheet view<\/li><li>8.8 Queries over several tables<\/li><li>8.9 Display object dependencies<\/li><li>8.10 Exercise<\/li><\/ul>\n<h5> 9 Print reports and data<\/h5><ul>\n<li>9.1 Basic knowledge of reports<\/li><li>9.2 Open report<\/li><li>9.3 Page settings of reports<\/li><li>9.4 Print report<\/li><li>9.5 Printing tables, queries and forms<\/li><li>9.6 Exercise<\/li><\/ul>\n<h5> 10 Create new database<\/h5><ul>\n<li>10.1 Create database in four steps<\/li><li>10.2 Simple database planning<\/li><li>10.3 Use database template<\/li><li>10.4 Creating an empty database<\/li><li>10.5 Exercise<\/li><\/ul><h5> 11 Create tables<\/h5><ul>\n<li>11.1 Basic knowledge table creation<\/li><li>11.2 Basic knowledge of data types<\/li><li>11.3 Creating tables in the data sheet view<\/li><li>11.4 Create lookup fields<\/li><li>11.5 Edit fields<\/li><li>11.6 Exercise<\/li><\/ul><h5> 12 Create forms<\/h5><ul>\n<li>12.1 Basic knowledge of forms<\/li><li>12.2 Formular-Assistent<\/li><li>12.3 Creating forms automatically<\/li><li>12.4 Creating forms manually<\/li><li>12.5 Create navigation forms<\/li><li>12.6 Exercises<\/li><\/ul><h5> 13 Edit forms<\/h5><ul>\n<li>13.1 Basic knowledge layout view<\/li><li>13.2 Control layouts<\/li><li>13.3 Changing the size and position of controls<\/li><li>13.4 Designing database objects with themes<\/li><li>13.5 Formatting controls<\/li><li>13.6 Inserting and deleting objects<\/li><li>13.7 Exercises<\/li><\/ul>\n<h5> 14 Create queries<\/h5><ul>\n<li>14.1 Apply Selection Query Wizard<\/li><li>14.2 Queries in the Design View<\/li><li>14.3 Define query criteria<\/li><li>14.4 Exercises<\/li><\/ul><h5> 15 Create reports and labels<\/h5><ul>\n<li>15.1 Basic knowledge of reports<\/li><li>15.2 Report Wizard<\/li><li>15.3 Grouped reports<\/li><li>15.4 Summary reports<\/li><li>15.5 Basic reports<\/li><li>15.6 Creating Empty Reports Manually<\/li><li>15.7 Editing reports<\/li><li>15.8 Creating labels<\/li><li>15.9 Exercises<\/li><\/ul><h5> 16 Edit database objects<\/h5><ul>\n<li>16.1 Rename or delete database objects<\/li><li>16.2 Copying and linking database objects<\/li><li>16.3 Hiding\/showing database objects<\/li><li>16.4 Exercise<\/li><\/ul><h5> 17 Manage databases<\/h5><ul>\n<li>17.1 Storage options<\/li><li>17.2 Backup database<\/li><li>17.3 Encrypt database with password<\/li><li>17.4 Database properties<\/li><\/ul>","comments":"<p>This text was automatically translated. Please click <span class=\"cms-link-marked\"><a class=\"fl-href-prod\" href=\"\/ibb\/de\/course\/training-acs365a\"><svg role=\"img\" aria-hidden=\"true\" focusable=\"false\" data-nosnippet class=\"cms-linkmark\"><use xlink:href=\"\/css\/img\/icnset-linkmarks.svg#linkmark\"><\/use><\/svg>here<\/a><\/span> to read the original German version.<\/p>","summary":"<p>Learn quickly and without ballast how to easily create tables, forms, queries and reports with Access. Supported with easy-to-understand, practical examples and tips, we show you how to work cleverly and goal-oriented with Access.<\/p>\n<p>As a database user, you will quickly learn to work with tables and forms in Access. Supported by handy sample databases, you will become familiar with the basic aspects of Access, such as entering, sorting, and filtering data, working with relationships and queries, and printing reports. So by the end of the first few chapters, you&#039;ll not only understand the basics of working with Access, but also have hands-on experience.<\/p>\n<p>As a database developer, you will gradually learn all the basic Access features that may be of importance in later practice - from planning and creating databases with a view to data types, to creating and editing forms, to creating and editing queries and reports. In this way, you can easily expand your Access skills step by step according to your personal requirements. In addition, &quot;Access 2019 - Basics for Users&quot; also provides you with valuable services time and again as a quick reference book.\n<\/p>\n<ul>\n<li>Basics of databases<\/li><li>Working with tables, forms, queries and reports<\/li><li>Working with filters<\/li><li>Relationships between tables<\/li><li>Create a new database<\/li><li>Edit database objects<\/li><li>Manage databases<\/li><\/ul><p>\nTailored to the learning topics in &quot;Access 2019 - Basics for Users,&quot; BookPlus gives you a comprehensive, digital media package with sample, exercise, and results files, knowledge tests, supplemental learning content, a glossary, and quick reference guides to key commands.<\/p>","contents_plain":"- 1 Get to know Access\n- 2 Working with databases\n- 3 Data entry in forms\n- 4 Data entry in tables\n- 5 Search, replace, sort data\n- 6 Filter data\n- 7 Working with queries\n- 8 Relationships between tables\n- 9 Print reports and data\n- 10 Create new database\n- 11 Create tables\n- 12 Create forms\n- 13 Edit forms\n- 14 Create queries\n- 15 Create reports and labels\n- 16 Edit database objects\n- 17 Manage databases","outline_plain":"1 Get to know Access\n\n\n- 1.1 Basic knowledge of databases\n- 1.2 Start Access and open database\n- 1.3 Access windows at a glance\n- 1.4 Using the ribbon\n- 1.5 Using Access Help\n- 1.6 Closing databases and exiting Access\n- 1.7 Exercise\n\n 2 Working with databases\n\n\n- 2.1 Navigation area and start form\n- 2.2 Customizing the Navigation Area\n- 2.3 Opening and closing objects\n- 2.4 Exercise\n\n 3 Data entry in forms\n\n\n- 3.1 Basic knowledge of forms\n- 3.2 Basic knowledge of data types\n- 3.3 Entering a new data record\n- 3.4 Special features of data entry\n- 3.5 AutoCorrect function\n- 3.6 Spell check\n- 3.7 Editing and deleting records\n- 3.8 Exercise\n 4 Data entry in tables\n\n\n- 4.1 Basic knowledge tables\n- 4.2 Data input\n- 4.3 Edit and delete data\n- 4.4 Copy or move data\n- 4.5 Change table layout\n- 4.6 Evaluating columns with functions\n- 4.7 Exercise\n 5 Search, replace, sort data\n\n\n- 5.1 Search and replace data\n- 5.2 Sorting data records\n- 5.3 Exercise\n\n 6 Filter data\n\n\n- 6.1 Basic knowledge of filters\n- 6.2 General filters\n- 6.3 Deactivate, activate or delete filters\n- 6.4 The value list\n- 6.5 Selection-based filters\n- 6.6 Exercise\n 7 Working with queries\n\n\n- 7.1 Basic knowledge of queries\n- 7.2 Execute queries\n- 7.3 Exercise\n 8 Relationships between tables\n\n\n- 8.1 Basic knowledge of relationships\n- 8.2 Basic knowledge of primary and foreign keys\n- 8.3 Types of relationships\n- 8.4 Reference integrity\n- 8.5 Display relationships\n- 8.6 Dependent data in forms\n- 8.7 Dependent data in the data sheet view\n- 8.8 Queries over several tables\n- 8.9 Display object dependencies\n- 8.10 Exercise\n\n 9 Print reports and data\n\n\n- 9.1 Basic knowledge of reports\n- 9.2 Open report\n- 9.3 Page settings of reports\n- 9.4 Print report\n- 9.5 Printing tables, queries and forms\n- 9.6 Exercise\n\n 10 Create new database\n\n\n- 10.1 Create database in four steps\n- 10.2 Simple database planning\n- 10.3 Use database template\n- 10.4 Creating an empty database\n- 10.5 Exercise\n 11 Create tables\n\n\n- 11.1 Basic knowledge table creation\n- 11.2 Basic knowledge of data types\n- 11.3 Creating tables in the data sheet view\n- 11.4 Create lookup fields\n- 11.5 Edit fields\n- 11.6 Exercise\n 12 Create forms\n\n\n- 12.1 Basic knowledge of forms\n- 12.2 Formular-Assistent\n- 12.3 Creating forms automatically\n- 12.4 Creating forms manually\n- 12.5 Create navigation forms\n- 12.6 Exercises\n 13 Edit forms\n\n\n- 13.1 Basic knowledge layout view\n- 13.2 Control layouts\n- 13.3 Changing the size and position of controls\n- 13.4 Designing database objects with themes\n- 13.5 Formatting controls\n- 13.6 Inserting and deleting objects\n- 13.7 Exercises\n\n 14 Create queries\n\n\n- 14.1 Apply Selection Query Wizard\n- 14.2 Queries in the Design View\n- 14.3 Define query criteria\n- 14.4 Exercises\n 15 Create reports and labels\n\n\n- 15.1 Basic knowledge of reports\n- 15.2 Report Wizard\n- 15.3 Grouped reports\n- 15.4 Summary reports\n- 15.5 Basic reports\n- 15.6 Creating Empty Reports Manually\n- 15.7 Editing reports\n- 15.8 Creating labels\n- 15.9 Exercises\n 16 Edit database objects\n\n\n- 16.1 Rename or delete database objects\n- 16.2 Copying and linking database objects\n- 16.3 Hiding\/showing database objects\n- 16.4 Exercise\n 17 Manage databases\n\n\n- 17.1 Storage options\n- 17.2 Backup database\n- 17.3 Encrypt database with password\n- 17.4 Database properties","comments_plain":"This text was automatically translated. Please click here to read the original German version.","summary_plain":"Learn quickly and without ballast how to easily create tables, forms, queries and reports with Access. Supported with easy-to-understand, practical examples and tips, we show you how to work cleverly and goal-oriented with Access.\n\nAs a database user, you will quickly learn to work with tables and forms in Access. Supported by handy sample databases, you will become familiar with the basic aspects of Access, such as entering, sorting, and filtering data, working with relationships and queries, and printing reports. So by the end of the first few chapters, you'll not only understand the basics of working with Access, but also have hands-on experience.\n\nAs a database developer, you will gradually learn all the basic Access features that may be of importance in later practice - from planning and creating databases with a view to data types, to creating and editing forms, to creating and editing queries and reports. In this way, you can easily expand your Access skills step by step according to your personal requirements. In addition, \"Access 2019 - Basics for Users\" also provides you with valuable services time and again as a quick reference book.\n\n\n\n- Basics of databases\n- Working with tables, forms, queries and reports\n- Working with filters\n- Relationships between tables\n- Create a new database\n- Edit database objects\n- Manage databases\n\nTailored to the learning topics in \"Access 2019 - Basics for Users,\" BookPlus gives you a comprehensive, digital media package with sample, exercise, and results files, knowledge tests, supplemental learning content, a glossary, and quick reference guides to key commands.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":3,"formatted":"3 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1490},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":1490},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":5170},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":2680},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":1490}}},"lastchanged":"2026-02-04T12:37:32+01:00","parenturl":"https:\/\/portal.flane.de\/ibb\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.de\/ibb\/en\/json-course-schedule\/24602","source_lang":"en","source":"https:\/\/portal.flane.de\/ibb\/en\/json-course\/training-acs365a"}}