This is a project book that guides you through the process of building a traditional Access desktop database that uses one Access database as the front-end (queries, reports, and forms) and another Access database to contain the tables and data. By separating the data from the rest of the database, the Access database can be easily shared by multiple users over a network. When you build a database correctly at the outset, later this database can be migrated to another system with fewer issues and fewer objects that need to be redone. FEATURESUnderstand the concepts of normalizationBuild tables and links to other data sources and understand table relationshipsConnect and work with data stored in other formats (Text, Word, Excel, Outlook, and PowerPoint)Retrieve data with DAO, ADO, and DLookup statementsLearn how to process text files for import and exportCreate expressions, queries, and SQL statementsBuild bound and unbound forms and reports and write code to preview and printIncorporate macros in your databaseWork with attachments and image filesLearn how to display and query your Access data in the Internet browserSecure your database for multi-user accessCompact your database to prevent corruption resulting in data loss
人気のある作家
J KING (12) JJ TAM (12) yang hu (11) Al Sweigart (8) Mojang AB (8) desti publishhings (7) Hidenori Kusaka (6) John Bach (6) JP TAM (6) Andrea Vedaldi (5) Halonjash Publications (5) Hiro Ainana (5) Horst Bischof (5) Intelligent Feather Publications (5) Jan-Michael Frahm (5) Michael W. Lucas (5) Andrew Park (4) Benjamin Smith (4) Engr. Michael David (4) Harvey Deitel (4)最適なファイルサイズ
10531 KB 1079 KB 1116 KB 1233 KB 2661 KB 370 KB 484 KB 536 KB 649 KB 738 KB 790 KB 10049 KB 1006 KB 10137 KB 1016 KB 102097 KB 1029 KB 10325 KB 1032 KB 1035 KB