Setting Up a Database in Excel
- Type product
Setting Up a Database in Excel
Beschrijving
Spells out the design considerations and tools needed for creating a database in Excel.In this course, author Dennis Taylor shows how to use Excel for creating a simple database. The course explains the limits of Excel as a data management tool and spells out the design considerations for creating a database. It also demonstrates using tables to simplify database creation as well as the Form and Data Validation tools to manage data. Topics include: Understanding database design concepts Using the Text to Columns feature Creating fields Using tables Adding total fields Formatting tables with the Design tab Using the Form tool to build and view data Using data validation to restrict data entri…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Spells out the design considerations and tools needed for creating a database in Excel.In this course, author Dennis Taylor shows how to use Excel for creating a simple database. The course explains the limits of Excel as a data management tool and spells out the design considerations for creating a database. It also demonstrates using tables to simplify database creation as well as the Form and Data Validation tools to manage data. Topics include: Understanding database design concepts Using the Text to Columns feature Creating fields Using tables Adding total fields Formatting tables with the Design tab Using the Form tool to build and view data Using data validation to restrict data entries
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.