Microsoft Access Tutorial

Microsoft Access TutorialTables A table is a collection of data about a specific topic, such as students or contacts. Using a separate table for each topic means that you store that data only once, which makes your database more efficient, and reduces data-entry errors. Tables organize data into columns (called fields) and rows (called records). Back to top Create a Table from scratch in Design view 1. If you haven't already done so, switch to the Database Window You can press F11 to switch to the Database window from any other window. http://www.bcschools.net/staff/AccessHelp.htm (1 of 7)7/3/2007 2:27:19 PMmMicrosoft Access Tutorial 2. Double-Click on "Create table in Design view". (DESIGN VIEW) 3. Define each of the fields in your table. Under the Field Name column, enter the categories of your table. http://www.bcschools.net/staff/AccessHelp.htm (2 of 7)7/3/2007 2:27:19 PMmmlmllmmnMicrosoft Access Tutorial Under Data Type column, enter the type you want for you categories. The attribute of a variable or field that determines what kind of data it can hold. For example, in a Microsoft Access database, the Text and Memo field data types allow the field to store either text or numbers, but the Number data type will allow the field to store numbers only. Number data type fields store numerical data that will be used in mathematical calculations. Use the Currency data type to display or calculate currency ...