pt. I. Access building blocks. 1. An introduction to database development : The database terminology of Access ; Relational databases ; Access database objects ; A five-step design method -- 2. Getting started with Access : The Access welcome screen ; How to create a blank desktop database ; The Access 2013 interface -- pt. II. Understanding Access tables. 3. Creating Access tables : Table types ; Creating a new table ; Creating tblCustomers ; Changing a table design ; Understanding tblCustomers field properties ; Setting the primary key ; Indexing Access tables ; Printing a table design ; Saving the completed table ; Manipulating tables ; Adding records to a database table ; Understanding attachment fields -- 4. Understanding table relationships : Building bulletproof databases ; Data normalization and denormalization ; Table relationships ; Integrity rules ; Keys -- 5. Working with Access tables : Understanding datasheets ; Looking at the datasheet window ; Opening a datasheet ; Entering new data ; Navigating records in a datasheet ; Changing values in a datasheet ; Using the undo feature ; Copying and pasting values ; Replacing values ; Adding new records ; Deleting records ; Displaying records ; Sorting and filtering records in a datasheet ; Aggregating data ; Printing records -- 6. Importing and exporting data : How Access works with external data ; Options for importing and exporting ; How to import external data ; How to export to external formats -- 7. Linking to external data : Linking external data ; Working with linked tables ; Splitting a database --
pt. III. Working with Access queries. 8. Selecting data with queries : Introducing queries ; Creating a query ; Working with query fields ; Adding criteria to your queries ; Printing a query's recordset ; Saving a query ; Creating multi-table queries ; Working with the table pane ; Creating and working with query joins -- 9. Using operators and expressions in Access : Introducing operators ; Using operators and expressions in queries ; Entering single-value field criteria ; Using multiple criteria in a query ; Entering criteria in multiple fields -- 10. Going beyond select queries : Aggregate queries ; Action queries ; Crosstab queries -- pt. IV. Analyzing data in Access. 11. Transforming data in Access : Finding and removing duplicate records ; Common transformation tasks -- 12. Working with calculations and dates : Using calculations in your analyses ; Using dates in your analyses -- 13. Performing conditional analyses : Using parameter queries ; Using conditional functions -- 14. Fundamentals of using Access SQL : Understanding basic SQL ; Getting fancy with advanced SQL statements ; Using SQL specific queries -- 15. Subqueries and domain aggregate functions : Enhancing your analyses with subqueries ; Domain aggregate functions -- 16. Running descriptive statistics in Access : Basic descriptive statistics ; Advanced descriptive statistics --
pt. V. Working with Access forms and reports. 17. Creating basic Access forms : Formulating forms ; Working with controls ; Introducing properties -- 18. Working with data on Access forms : Using form view ; Changing values in a form ; Printing a form ; Working with form properties ; Adding a form header or footer ; Working with section properties ; Changing the layout ; Converting a form to a report -- 19. Working with form controls : Setting control properties ; Creating a calculated control ; Working with subforms ; Form design tips ; Tackling advanced forms techniques ; Using the tab control ; Using dialog boxes to collect information ; Designing a form from scratch -- 20. Presenting data with Access reports : Introducing reports ; Creating a report, from beginning to end ; Banded report design concepts ; Creating a report from scratch ; Improving the report's appearance -- 21. Advanced Access report techniques : Grouping and sorting data ; Formatting data ; Adding data ; Trying more techniques -- pt. VI. Access programming fundamentals. 22. Using Access macros : An introduction to macros ; Understanding macro security ; Multi-action macros ; Submacros ; Conditions ; Temporary variables ; Error handling and macro debugging ; Embedded macros ; Macros versus VBA statements -- 23. Getting started with Access VBA : Introducing Visual Basic for Applications ; Understanding VBA terminology ; Starting with VBA code basics ; Creating VBA programs ; Understanding VBA branching constructs ; Working with objects and collections ; Exploring the Visual Basic editor -- 24. Mastering VBA data types and procedures : Using variables ; Working with data types ; Understanding subs and functions ; Creating functions ; Simplifying code with named arguments -- 25. Understanding the Access event model : Programming events ; Identifying common events ; Paying attention to event sequence -- 26. Debugging your Access applications : Organizing VBA code ; Testing your applications ; Traditional debugging techniques ; Using the Access debugging tools ; Trapping errors in your code --
pt. VII. Advanced Access programming techniques. 27. Accessing data with VBA codes : Working with data ; Understanding ADO objects ; Understanding DAO objects ; Writing VBA code to update a table -- 28. Advanced data access with VBA : Adding an unbound combo box to a form to find data ; Filtering a form -- 29. Integrating Access and SQL Server : Introducing SQL Server Express ; Understanding data types in SQL Server ; Installing SQL Server Express ; Connecting to SQL Server ; Working with SQL Server objects -- 30. Customizing the ribbon : The ribbon hierarchy ; Editing the default ribbon ; Working with the quick access toolbar ; Developing custom ribbons ; Creating a custom ribbon ; The basic ribbon XML ; Adding ribbon controls ; Attaching ribbons in forms and reports ; Completely removing the ribbon -- 31. Preparing your Access application for distribution : Defining the current database options ; Developing the application ; Polishing your application ; Bulletproofing an application ; Securing the environment -- pt. VIII. Access and Windows SharePoint services. 32. Understanding Windows SharePoint services : Introducing SharePoint ; Reviewing various types of SharePoint sites ; Looking at a SharePoint website ; The concept behind Access and SharePoint integration -- 33. Integrating Access with SharePoint : Sharing Access data with SharePoint ; Using SharePoint templates -- 34. Understanding Access services : Explaining managed applications ; Looking at Web publishing in Access ; Understanding Access services ; Examining Access Web application limits -- 35. Deploying Access applications to SharePoint : Publishing a custom Access application to SharePoint -- 36. Using Access data macros : Introducing data macros ; Understanding table events ; Using the macro designer for data macros ; Understanding the action catalog ; Creating your first data macro ; Managing macro objects ; Recognizing the limitations of data macros --
pt. IX. Appendixes. A. Access 2013 specifications : Access database specifications ; SQL Server Express specifications
B. Optimizing Access applications : Understanding module load on demand ; Distributing ACCDE files ; Understanding the compiled state ; Improving speed ; Working with large Access databases
C. Understanding query performance and database corruption : Optimizing query performance ; Handling database corruption
D. Function reference for data analysts : Abs ; Asc ; Atn ; Choose ; Chr ; Cos ; Date ; DateAdd ; DateDiff ; DatePart ; DateSerial ; DateValue ; Day ; DDB ; Domain aggregate functions ; Exp ; FormatCurrency ; FormatDateTime ; FormatNumber ; FormatPercent ; FV ; Hour ; IIf ; InStr ; InStrRev ; IPmt ; IRR ; IsError ; IsNull ; IsNumeric ; LCase ; Left ; Len ; Log ; Mid ; Minute ; MIRR ; Month ; MonthName ; Now ; NPer ; NPV ; NZ ; Partition ; Pmt ; PPmt ; PV ; Rate ; Replace ; Right ; Rnd ; Round ; Second ; Sgn ; Sin ; SLN ; SQL aggregate functions ; Sqr ; Str ; StrConv ; String ; StrReverse ; Switch ; SYD ; Tan ; Time ; TimeSerial ; TimeValue ; Trim, LTrim, RTrim ; TypeName ; UCase ; Val ; VarType ; Weekday ; WeekdayName ; Year.
