Table of Contents
: Get Going with Access
Exercise 1: An address book, Developing a database system , The COMPANY database system, A working method, Planning, Analyzing your data, Brain storm, A diagram of your database, Planning the tables, Customer list, Invoices, Exercise 2: Creating the database and the first table, More information about field properties, Entering data in your table, AutoForm, Exercise 3: Tables for invoices, The invoice heading table, The charges table, Exercise 4: Relationships, Exercise 5: Using a Query to sort data, Exercise 6: Combining tables, Exercise 7: A Query which can calculate, Exercise 8: A new, improved Customer Index, Delete a record, Display your records in table form, Ring up automatically, Tired of those clouds?, Exercise 9: An invoice window, Improving the form, Exercise 10: A new field to show the total, A summary of what we have learned about creating forms, Exercise 11: A combo box, Printing an invoice, Exercise 12: Reports, Customer list, Sorting and grouping, A billing report, Exercise 13: Printing an invoice, Query, The report , A button to print your invoice, Exercise 14: The system menu, The menu form, A macro to open the menu automatically, A shortcut to your system, Exercise 15: Mail merge using Word, Exercise 16: Your own quick ‘look up’ tool , Exercise 17: A advanced Query, Endword. Index: actions in a macro, 49 address list, 7 advantages, 10 aim of database, 8 alphabetical sorting, 22 analyzing data, 9 apply filter, 7 autodialer, 28 autoexec, macro, 49 autoform, 6; 16 autoformat, forms, 29 automatic date, 18 AutoNumber, 13 between, 55 brainstorming, 10 button, 28 calculating in a Query, 24 calculation, 24; 34 caption, 15 charges table, 19 choosing fields in a form, 26 color, 32; 36 column width in tables, 27 combining tables, 23 combo box, 37; 52 command button, 28; 46; 47 Company system, 8 control elements, moving, 35 control objects, altering, 36 Control Wizard, 28; 37 copying a field, 44 create database, 5; 13 create table, 13 criteria, 43 criteria in Query, 51 currency format, 25; 34 customer list, 11; 39 data analysis, 9 data modeling, 8 data type, 13; 18 Database for a Company, 8 database window, 5 database wizard, 5 date, 18 date interval, 55 decimal indicator, 25 decimals, 19 Default value, 15; 18; 19 delete record, 27 description, 13 design view, 16 detail, forms, 35 detail, report, 40 developing a system, 8 double integer, 18 E/R-model, 10 easy exercise, 5 elements, 10 enabled, 32 enforced referential integrity, 20 enhed, 10 entering new records, 17 entering records, 39 event, 53 field, 13 field properties, 15; 25 Field size, 15 field, length, 14 field, locked, 32 fields, moving, 44 filtering, 7 first, 6 form footer, 35 form header, 35 form wizard, 26 format, 15 forms, 26 forms containing subforms, 30 forms in a Query, 24 forms, autoformat, 29 forms, menu, 47 forms, printing, 39 forms, size, 33 forms, sorting, 28 forms, structure, 35 forms, working with, 31 getting started, 10 grouping, report, 40 header, report, 41 Help, 15 improving forms, 31 indexed, 15 information on invoice, 12 inserting fields in forms, 34 Integer, 19 integrity, 21 Introduction to Access, 5 invoice, 12 invoice, tables, 18 key fields, 11 last, 6 lock a field, 32 locking a field, 36 long integer, 18 macro, 49; 53 mail merge, 50 manual creation of reports, 44 manual creation of tables, 13 many-to-one, 10 menu, 8; 47 modeling data, 8 modem, 28 moving fields, 44 naming objects, 14 new record, 6; 17 next, 6 Null, 51 null values, 51 number, 19 number format, 25 object names, 14 objects, 10 one-to-many, 10 Open Access, 5 open database, 7 order, 38 order of work, 9 page footer, report, 40 page header, report, 40 parameters in a Query, 54 planning, 8; 9 planning tables, 11 preparation, 9 previous, 6 primary key, 11; 13 print preview, 42 printing, 7 printing forms, 39 properties, 15; 25 purpose, 8 Query, 22 Query with calculations, 24 Query, criteria, 43 record, delete, 27 referential integrity, 21 referential integrity, 20 relationship, 10 relationship, data type, 18 relationships, 20 Relationships window, 20 remove filter, 7 report, 39 report for one invoice, 42 report design, 40 report footer, 40 Report header, 40 reports, 7 reports, creating manually, 44 required fields, 15 résumé, Query, 54 Sales tax, 12 save, 5 search, 7; 52 searching in a form, 26 shortcut, 8 shortcut, Windows 95, 50 sort, 22 sorting forms, 28 sorting, report, 40 Start Access, 5 Start button, 5 subforms, 30 sum, 34 system development, 8; 9 tab order, 38 table, 13 table display, forms, 27 Table wizard, 6 table, delete rows, 14 table, entering data, 16 table, insert rows, 14 tables for invoices, 18 tables, combining, 23 tables, planning, 11 tabs in the database window, 5 telephone, 28 text box, 34 Text box, label, 34 text box, report, 41 text, data type, 13 theories of relational databases, 10 toolbox, 37 total, 12; 34 totals in a Query, 54 unbound, 34 understanding your data, 8 unique, 11; 13 validation, 15 VAT, 12 wants, 10 wizard database, 5 wizard, forms, 26 working orderly, 9