ICT Database Lesson 4 Manipulating and Sharing Data

ICT Database Lesson 4 Manipulating and Sharing Data in a Database

Common Errors • • Mistyping data or entering the wrong data type ü Data integrity can be improved using field properties: format, length, or a “mask” (date/time or (xxx) xxxxxxx) Referring to a non-existent table or field. ü The name of the table may have been changed or the table may have been deleted. Syntax errors – rules for wording or commands Checking the status of a table should be the first step in troubleshooting

Importing / Exporting Data • Exporting data prepares the data to be used in other programs such as spreadsheet programs. • Importing prepares data to be used in the open program ü Import data for a large number of records. ü Usually a spreadsheet, another database, or as a text file (. txt, . csv) ü Map corresponding fields

Reports A way to display your data in a visually appealing and easy-to-read format. You can format the data for different types of reports • group and/or sort data, display subtotals, averages and other statistical data • highlight values by using conditional formatting • apply themes to enhance the "look and feel" of reports • add images to reports • preview and print reports

Reports • • Reflect current data only at the time the report is run Reports tool provides the fastest way for you to create a report ü Generates a report immediately without prompting you for information ü Displays all the fields from the underlying table or query

Reports: Controls - Themes • • Controls: display data, perform actions, and let you view and work with information that enhances the user interface, such as labels and images. Three types of controls: bound, unbound, and calculated Allow you to manipulate data such as sorting or summing a column Themes alter the “look and feel” of database reports