From http://rogersaccessblog.blogspot.com/ - Roger's Access Blog
Access Basics
- http://rogersaccessblog.blogspot.com/2009/05/how-do-i-create-application-in.html - How do I Create an Application in Microsoft Access?
- http://rogersaccessblog.blogspot.com/2013/04/how-do-i-convert-macro-to-vba-code.html - How Do I Convert A Macro to VBA Code?
- http://rogersaccessblog.blogspot.com/2013/03/how-do-i-configure-my-access-database.html - How Do I Configure My Access Database Start Up?
- http://rogersaccessblog.blogspot.com/2008/11/access-101-how-do-i-bypass-start-up.html - How Do I Bypass Start Up Options?
- http://rogersaccessblog.blogspot.com/2013/04/how-do-i-run-macro-or-code-when.html - How do I run a macro or code when the database first starts?
- http://rogersaccessblog.blogspot.com/2008/09/frequently-asked-question-can-i-create.html - Can I Create an EXE from my Access Application?
- http://rogersaccessblog.blogspot.com/2009/04/how-do-i-decompile-database.html - How Do I Decompile a Database?
- http://rogersaccessblog.blogspot.com/2010/07/how-do-i-add-value-to-combo-box-with.html - How do I add a value to a combo box with Not In List?
- http://rogersaccessblog.blogspot.com/2011/10/what-to-do-when-you-take-over-database.html - What To Do When You Take Over A Database Application
Compacting Databases
- http://rogersaccessblog.blogspot.com/2010/09/what-does-it-mean-to-compact-my-access.html - What Does It Mean to Compact My Access Database?
- http://rogersaccessblog.blogspot.com/2010/09/how-do-i-compact-access-database.html - How Do I Compact an Access Database?
- http://rogersaccessblog.blogspot.com/2010/12/should-i-use-compact-on-close-feature.html - Should I use the Compact On Close feature of Access?
- http://rogersaccessblog.blogspot.com/2010/09/how-can-i-compact-current-access.html - How Can I Compact the Current Access Database in Code?
- http://rogersaccessblog.blogspot.com/2010/09/how-can-i-compact-my-access-database.html - How Can I Compact my Access Database Less Often?
- http://rogersaccessblog.blogspot.com/2010/09/help-my-database-is-corrupted-and-i.html - Help! My Database is Corrupted, and I Can't Repair!
Domain Functions Demystified
- http://rogersaccessblog.blogspot.com/2010/12/domain-functions-demystified.html - Domain Functions Demystified: Introduction
- http://rogersaccessblog.blogspot.com/2010/12/domain-functions-demystified-criteria.html - Domain Functions Demystified: Criteria Expressions
- http://rogersaccessblog.blogspot.com/2010/12/domain-function-example-simulate.html - Domain Function Example: Simulate AutoNumber with DMax
- http://rogersaccessblog.blogspot.com/2010/12/domain-function-examples-numbered-query.html - Domain Function Example: Numbered Query With DCount
- http://rogersaccessblog.blogspot.com/2011/01/domain-function-example-running-sum.html - Domain Function Example: Running Sum with DSum
- http://rogersaccessblog.blogspot.com/2011/01/between-in-query.html - Domain Function Example: "Difference Between" in Query
- http://rogersaccessblog.blogspot.com/2011/01/domain-function-example-rolling-average.html - Domain Function Example: Rolling Average in Query
- http://rogersaccessblog.blogspot.com/2011/02/begin-date-and-end-date-from-effective.html - Domain Function Example: Begin Date and End Date from Effective Date
- http://rogersaccessblog.blogspot.com/2011/10/how-do-i-calculate-median-in-access.html - How do I calculate a Median in Access? Part1
- How do I calculate a Median in Access? Part 2
Date Stuff
- http://rogersaccessblog.blogspot.com/2012/01/date-stufffunctions.html - Date Functions
- http://rogersaccessblog.blogspot.com/2012/01/date-stuffusing-functions.html - Date Stuff–Using the Functions
- http://rogersaccessblog.blogspot.com/2012/01/date-stuff-useful-examples.html - Date Stuff – Useful Examples
- http://rogersaccessblog.blogspot.com/2012/01/now-function-in-default-value-stores.html - Now() Function in Default Value Stores the Wrong Time
Database Design Basics
- http://rogersaccessblog.blogspot.com/2012/06/really-bad-design-decisions-case-study.html - Really Bad Design Decisions: A Case Study
- http://rogersaccessblog.blogspot.com/2008/12/what-is-primary-key.html - What is a Primary Key?
- http://rogersaccessblog.blogspot.com/2008/12/access-101-what-is-index.html - What is an Index?
- http://rogersaccessblog.blogspot.com/2008/10/what-does-null-mean-how-is-it-different.html - What does NULL mean? How is it different than the Empty String?
- http://rogersaccessblog.blogspot.com/2010/10/normalizing-city-state-and-zip.html - Normalizing City, State, and Zip
What is Normalization?
- http://rogersaccessblog.blogspot.com/2008/12/what-is-normalization-part-i.html - What Is Normalization, Part I: Why Normalization?
- http://rogersaccessblog.blogspot.com/2008/12/what-is-normalization-part-ii.html - What Is Normalization, Part II: Break it up.
- http://rogersaccessblog.blogspot.com/2008/12/what-is-normalization-part-iii.html - What Is Normalization: Part III: Putting It Back Together
- http://rogersaccessblog.blogspot.com/2009/01/what-is-normalization-part-iv.html - What is Normalization: Part IV: More Relationships
- http://rogersaccessblog.blogspot.com/2009/01/what-is-normalization-part-v.html - What Is Normalization: Part V: Many-to-Many Relationships
Entity-Relationship Diagramming
- http://rogersaccessblog.blogspot.com/2009/01/entity-relationship-diagramming-part-i.html - Entity-Relationship Diagramming: Part I
- http://rogersaccessblog.blogspot.com/2009/01/entity-relationship-diagramming-part-ii.html - Entity-Relationship Diagramming: Part II
- http://rogersaccessblog.blogspot.com/2009/02/entity-relationship-diagramming-part.html - Entity-Relationship Diagramming: Part III
- http://rogersaccessblog.blogspot.com/2009/02/in-entity-relationship-parts-i-ii-and.html - Entity-Relationship Diagramming: Part IV
The Normal Forms
- http://rogersaccessblog.blogspot.com/2009/02/normal-forms-introduction.html - The Normal Forms: Introduction
- http://rogersaccessblog.blogspot.com/2009/02/normal-forms-first-normal-form-1nf.html - The Normal Forms: First Normal Form (1NF)
- http://rogersaccessblog.blogspot.com/2009/03/normal-forms-second-normal-form.html - The Normal Forms: Second Normal Form (2NF)
- http://rogersaccessblog.blogspot.com/2009/03/normal-forms-third-normal-form.html - The Normal Forms: Third Normal Form (3NF)
- http://rogersaccessblog.blogspot.com/2009/03/normal-forms-in-nutshell.html - The Normal Forms: In a Nutshell
What’s Wrong With Repeated Columns?
- http://rogersaccessblog.blogspot.com/2011/03/problem-of-repeated-columns.html - The Problem of Repeated Columns
- http://rogersaccessblog.blogspot.com/2011/03/querying-repeated-columns-multiple-ors.html - Querying Repeated Columns: Multiple ORs
- http://rogersaccessblog.blogspot.com/2011/03/querying-repeated-columns-multiple.html - Querying Repeated Columns: Multiple Unions
- http://rogersaccessblog.blogspot.com/2011/03/querying-repeated-columns-multiple_28.html - Querying Repeated Columns: Multiple Joins
- Querying%20Repeated%20Columns:%20Multiple%20IIFs - Querying Repeated Columns: Multiple IIFs
- http://rogersaccessblog.blogspot.com/2011/04/querying-repeated-columns-impossible.html - Querying Repeated Columns: Impossible Joins
- http://rogersaccessblog.blogspot.com/2011/04/aggregating-across-repeated-columns.html - Aggregating Across Repeated Columns: Summing
- http://rogersaccessblog.blogspot.com/2011/04/aggregating-across-repeated-columns_25.html - Aggregating Across Repeated Columns: Counting
- http://rogersaccessblog.blogspot.com/2011/05/aggregating-across-repeated-columns.html - Aggregating Across Repeated Columns: Averaging
Normalizing Repeating Columns
- http://rogersaccessblog.blogspot.com/2011/05/normalizing-repeated-columns-simple-pc.html - Normalizing Single Repeated Column (Part1)
- http://rogersaccessblog.blogspot.com/2011/05/normalizing-repeated-columns-simple-pc_23.html - Normalizing Single Repeated Column (Part2)
- http://rogersaccessblog.blogspot.com/2011/05/normalizing-repeated-columns-complex-pc.html - Normalizing Multiple Columns (Part1)
- http://rogersaccessblog.blogspot.com/2011/05/normalizing-repeated-columns-complex-pc_31.html - Normalizing Multiple Columns (Part 2 )
- http://rogersaccessblog.blogspot.com/2011/06/normalizing-repeated-columns-yesno.html - Normalizing Yes/No Fields (Part1)
- http://rogersaccessblog.blogspot.com/2011/06/normalizing-repeated-columns-yesno_14.html - Normalizing Yes/No Fields (Part2)
- http://rogersaccessblog.blogspot.com/2011/06/normalizing-repeated-columns-vba.html - Normalizing Repeated Columns With VBA
Queries
- http://rogersaccessblog.blogspot.com/2009/06/what-is-query_01.html - What Is A Query?
- http://rogersaccessblog.blogspot.com/2009/11/this-recordset-is-not-updateable-why.html - This Recordset is Not Updateable. Why?
- http://rogersaccessblog.blogspot.com/2011/07/searching-for-wildcard-in-like-criteria.html - Searching for a Wildcard in a “LIKE” Criteria (Quick Tip)
Select Queries Series:
- http://rogersaccessblog.blogspot.com/2009/06/select-queries-part-1-simple-queries.html - Part 1: Simple Queries
- http://rogersaccessblog.blogspot.com/2009/06/select-queries-part-2-restricting-rows.html - Part 2: Restricting Rows - the Where Clause
- http://rogersaccessblog.blogspot.com/2009/06/select-queries-part-3-sorting-and.html - Part 3: Sorting and Grouping (ORDER BY, GROUP BY)
- http://rogersaccessblog.blogspot.com/2009/07/select-queries-part-4-parameters-top.html - Part 4: PARAMETERS, TOP, DISTINCT, and TRANSFORM...PIVOT
Union Query
- http://rogersaccessblog.blogspot.com/2010/02/union-query-part-1.html - Union Query Part 1: Simple Union Query
- http://rogersaccessblog.blogspot.com/2010/02/union-query-part-2.html - Union Query Part 2: More Union Queries
Joins
- http://rogersaccessblog.blogspot.com/2009/08/what-is-join-part-1-introduction.html - What is a Join: Part 1 (Introduction)
- http://rogersaccessblog.blogspot.com/2009/08/what-is-join-part-2-inner-join.html - What is a JOIN: Part 2 (Inner Join)
- http://rogersaccessblog.blogspot.com/2009/08/what-is-join-part-3-cartesian-joins.html - What Is A Join: Part 3 (Cartesian Joins)
- http://rogersaccessblog.blogspot.com/2009/08/equi-joins-in-where-clause.html - What is a Join: Part 4 (Equi-Joins in the WHERE Clause)
- http://rogersaccessblog.blogspot.com/2009/09/what-is-join-part-5-outer-joins.html - What Is A Join Part 5: Outer Joins
- http://rogersaccessblog.blogspot.com/2008/11/access-101-why-do-i-get-ambiguous-outer.html - Why Do I Get the "Ambiguous Outer Join" Error
Action Queries:
- http://rogersaccessblog.blogspot.com/2009/12/action-queries-delete-query.html - Delete Query
- http://rogersaccessblog.blogspot.com/2010/01/action-queries-update-query.html - Update Query
- http://rogersaccessblog.blogspot.com/2010/01/action-queries-append-query.html - Append Query
- http://rogersaccessblog.blogspot.com/2010/09/append-queries-avoiding-duplicates.html - Append Queries: Avoiding Duplicates
- http://rogersaccessblog.blogspot.com/2010/01/action-queries-make-table-query.html - Make-Table Query
- http://rogersaccessblog.blogspot.com/ - Featured Sample: Action Queries In Code
- http://rogersaccessblog.blogspot.com/2010/01/featured-sample-unbound-sql.html - Featured Sample: UnboundSQL.mdb
Data Definition Language (DDL) Queries:
- http://rogersaccessblog.blogspot.com/2011/08/data-definition-language-ddl-dao-vs-sql.html - SQL vs. DAO
- http://rogersaccessblog.blogspot.com/2011/08/data-definition-language-sql.html - DDL Using SQL
- http://rogersaccessblog.blogspot.com/2011/08/data-definition-language-ddl-ddl-using.html - DDL Using DAO
Top Queries Revealed:
- http://rogersaccessblog.blogspot.com/2009/11/top-query-revealed-simple-top-query.html - Simple Top Query
- http://rogersaccessblog.blogspot.com/2009/11/top-query-revealed-aggregate-values-and.html - Aggregate Values and Top Values By Group.
- http://rogersaccessblog.blogspot.com/2009/12/top-query-problem-ties.html - Top Query Problem - Ties
- http://rogersaccessblog.blogspot.com/2009/12/top-query-revealed-top-query-to-find.html - Top Query to find Random Records
- http://rogersaccessblog.blogspot.com/2009/12/top-query-revealed-top-query-to-find.html - Parameters in Top Queries
Count Distinct In Access Series:
- http://rogersaccessblog.blogspot.com/2012/04/count-distinct-in-access-part-1.html - COUNT DISTINCT in Access: Part 1
- http://rogersaccessblog.blogspot.com/2012/04/count-distinct-in-access-part-2.html - COUNT DISTINCT In Access: Part 2
- http://rogersaccessblog.blogspot.com/2012/05/count-distinct-in-access-part-3.html - COUNT DISTINCT In Access: Part 3
- http://rogersaccessblog.blogspot.com/2012/06/count-distinct-in-access-part-4.html - - COUNT DISTINCT in Access: Part 5
Miscellaneous
- http://rogersaccessblog.blogspot.com/2009/04/what-is-fastest-way-to-return-record.html - What is the fastest way to return the Record Count of a table?
- http://rogersaccessblog.blogspot.com/2009/04/what-is-fastest-way-to-return-record_23.html - What is the fastest way to return the Record Count from an Access Query?
- http://rogersaccessblog.blogspot.com/2009/09/what-is-difference-between-having-and.html - What is the difference between HAVING and WHERE in Aggregate Queries?
Reports
-
http://rogersaccessblog.blogspot.com/2011/07/showing-query-parameters-in-report.html - Showing Query Parameters in a Report (Quick Tip)
VBA/Programming
- http://rogersaccessblog.blogspot.com/2009/04/bang-vs-dot-in-dao.html - Bang Vs. Dot In DAO
- http://rogersaccessblog.blogspot.com/2011/10/bang-vs-dot-in-forms.html - Bang Vs. Dot in Forms
- http://rogersaccessblog.blogspot.com/2011/10/referencing-forms-subforms-and-sub.html - Referencing Forms, Subforms, and Sub-subforms
- http://rogersaccessblog.blogspot.com/2011/08/data-definition-language-ddl-ddl-using.html - Data Definition Language (DDL): DDL Using DAO
- http://rogersaccessblog.blogspot.com/2008/11/access-101-how-do-i-find-path-and.html - How Do I Find The Path and Filename For My Database?
- http://rogersaccessblog.blogspot.com/2008/11/access-101-how-do-i-replace-system.html - How Do I Replace System Error Messages With Custom Messages?
- http://rogersaccessblog.blogspot.com/2013/04/how-do-i-convert-macro-to-vba-code.html - How Do I Convert A Macro to VBA Code?
- http://rogersaccessblog.blogspot.com/2013/04/how-do-i-hide-form-but-leave-it-running.html - How Do I Hide a Form But Leave It Running?
- http://rogersaccessblog.blogspot.com/2008/10/access-101-how-do-i-run-process.html - How Do I Run A Process Automatically Once A Day? Part 1
- http://rogersaccessblog.blogspot.com/2008/11/access-101-how-do-i-run-process.html - How Do I Run A Process Automatically Once A Day? Part 2
- http://rogersaccessblog.blogspot.com/2010/06/whats-difference-between-early-binding.html - What’s the Difference Between Early Binding and Late Binding?
- http://rogersaccessblog.blogspot.com/2011/10/how-do-i-calculate-median-in-access.html - How do I calculate a Median in Access? Part1
- http://rogersaccessblog.blogspot.com/2011/10/how-do-i-calculate-median-in-access_10.html - How do I calculate a Median in Access? Part 2
-
http://rogersaccessblog.blogspot.com/2012/09/recreate-access-tables-in-sql-server.html - Recreate Access Tables in SQL Server
Web Databases
- The Data
- http://rogersaccessblog.blogspot.com/2010/05/access-2010-web-databases-how-can-i-put.html - How Can I Put My Access Database On The Web?
- http://rogersaccessblog.blogspot.com/2010/05/access-2010-web-databases-creating-back.html - Web Compatibility
- http://rogersaccessblog.blogspot.com/2010/05/access-2010-web-databases-how-can-i.html - How can I create a Compound Unique Index?
- http://rogersaccessblog.blogspot.com/2010/05/access-2010-web-databases-creating.html - Creating Relationships
- http://rogersaccessblog.blogspot.com/2010/06/access-2010-web-databases-uploading-to.html - Uploading to SharePoint
- http://rogersaccessblog.blogspot.com/2010/06/access-2010-web-databases-viewing.html - Viewing Tables In SharePoint
- http://rogersaccessblog.blogspot.com/2010/06/access-2010-web-databases-other.html - Other Compatibility Errors
------------- Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<
|