Access: different layers, uses relationships define between
sheets to be able to pull a query that has different criterias. What sheet do we need to make? What are the relationships? Connections between these sheets. In a dbase design, eliminate redundancy. Keep areas define by areas. Student information. Import from SASI into Excel, into Access. Spreadsheet in Excel = Tables in Access. Queries only exist when you call it. Once you use it, it goes away. Logistics: How many teachers will use. One Accdb file on one computer. Needs to be centralized. Two views to a table, design and active Start with design view on tables. Create equivalent of column headers on excel Every table has it’s own running or record. First field should be ID, auto numbered. Avoid spaces in field names. Capitalize first letter of every word. (Later on, be doing scripting) Format: phone number, preformat () -… Caption: input form, caption will be the label for that form. Make sure Indexed is set to “No”. don’t want the last name to be index for table because last names are not unique. Required: last name is a must. Data Type tells access what kind of data it is. Text, single box Memo: larger text box. Number: just use text. Use Table as a basis for creating a form. Dark gold: Label light gold: input Add new record on form. Close table. Open table. Database Tools.Relationships>Link to Student ID table. |