
Access 365 Project Book
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions


Person
Content
- Cover
- Title Page
- Copyright Page
- Contents
- Introduction
- Acknowledgments
- Part I Plan, Design, and Create a Database
- Chapter 1 Planning and Designing a Database
- About Access Databases
- About Access Objects
- The Employee Training Database (ETD)
- Planning Your Database
- Some Database Design Questions to Ask
- Business Rules for the Database
- Creating a Database Diagram
- Action Item 1.1
- Designing the Database
- Guidelines for Creating Tables
- Understanding Table Relationships
- About Primary Keys
- About Foreign Keys and Null Values
- What Is Database Normalization?
- Data Normalization Rules
- Benefits of Data Normalization
- What Is Database Denormalization?
- Action Item 1.2
- Summary
- Chapter 2 Creating a Desktop Database
- About Access Database File Formats
- Creating an Access Desktop Database
- Completing the Initial Table Structure
- Naming Conventions in Access
- Naming a Field
- What Is the Data Type?
- Saving the Table
- Working in the Table Design View
- Modifying a Field Size
- Specifying the Field Format and Input Mask
- Specifying the Default Value for a Field
- Specifying Validation Rule and Validation Text
- Changing a Table Design
- Modifying the Field Data Type
- Changing a Field Name
- Action Item 2.1
- Changing a Field Location
- Action Item 2.2
- Inserting a New Field
- Action Item 2.3
- Deleting a Field
- Action Item 2.4
- Entering Data in a Table
- Copy, Export, and Remove Tables
- Action Item 2.5
- Printing a Table Design
- Summary
- Part II Create and Work with Database Tables
- Chapter 3 Creating Access Tables
- Creating a Table in Design View
- Action Item 3.1
- Creating a Table Using Application Parts
- Creating a Table Using a Make Table Query
- Creating a Table With a Data Definition Query
- Creating Remaining Tables in the ETD Database
- Action Item 3.2
- Untitled
- Chapter 4 Setting up Primary Keys, Indexes, and Table Relationships
- Relating Tables
- Action Item 4.1
- Action Item 4.2
- Action Item 4.3
- Creating Many-to-Many Relationships
- Action Item 4.4
- Establishing Table Relationships Using Data Definition Language
- Displaying the System Objects
- Action Item 4.5
- Creating the Relationship Report
- Action Item 4.6
- Indexing Fields
- Summary
- Chapter 5 Populating Access Tables With Data
- Importing Data Into an Access Table
- Importing Versus Linking
- Importing Data From a Text File
- Importing Data From Excel Worksheets
- Action Item 5.1
- Importing Data From XML Files
- Importing Data From a Tab-Delimited Text File
- About Datasheets and Subdatasheets
- Action Item 5.2
- Action Item 5.3
- Importing Data From Another Access Database
- Reusing Saved Imports
- How to Deal With Unsuccessful Imports
- Importing Worksheet Ranges
- Action Item 5.4
- Action Item 5.5
- Action Item 5.6
- Summary
- Part III Create and Work With QueriesPart III Create and Work With Queries
- Chapter 6 Creating and Working With Select Queries
- Explain the Concept of Queries as Used in an Access Database
- Action Item 6.1
- Creating a Query
- Filtering a Query
- Creating a Calculated Field in a Query
- Using the Expression Builder
- Understanding Query Totals and Grouping
- Creating a Parameter Query
- Using Multiple Parameters
- Action Item 6.2
- Creating Crosstab Queries
- Developing SQL Skills using Select Queries
- Action Item 6.3
- Predicates in SQL Statements
- Using the DISTINCT Predicate
- Using the DISTINCTROW Predicate
- Using the TOP Predicate
- Understanding and Using Subqueries
- SQL Keywords used in Subqueries
- The IN and NOT Operators
- The EXISTS Predicate
- The ANY, SOME, and ALL Predicates
- Understanding Null Values in Data
- Finding Unmatched Data
- Action Item 6.4
- Finding Duplicate Data
- Action Item 6.5
- Creating and Using a Union Query
- Action Item 6.6
- Speeding Up Your Select Queries
- Summary
- Chapter 7 Performing Database Operations With Action Queries
- Using Make Table Queries
- Action Item 7.1
- Using Append Queries
- Using Criteria With Append Queries
- Action Item 7.2
- Action Item 7.3
- Using Update Queries
- Action Item 7.4
- Action Item 7.5
- Using Delete Queries
- Other Types of Queries in Access
- Summary
- Part IV Create and Work with Forms
- Chapter 8 Designing and Using Forms
- About Access Forms
- Designing Forms
- The Form Tool
- The Form Wizard
- The Form Design and a Blank Form
- The Multiple Items Forms
- The Split Form
- The Modal Dialog Forms
- Modal Forms versus Popup Forms
- The Navigation Forms
- Navigation Forms vs Switchboard Forms
- Understanding Form Views
- Understanding Form Properties
- Format Properties
- Data Properties
- Event Properties
- Other Properties
- Creating and Modifying a Form
- Understanding Form Controls
- Selecting and Deselecting Controls
- Resizing a Control
- Moving and Aligning Controls
- Adjusting Spacing Between Controls
- Copying Controls
- Action Item 8.1
- Working With Controls and Their Properties
- Action Item 8.2
- Summary
- Chapter 9 Form Customization
- Applying Special Effects to Form Controls
- Changing a Control Type
- Action Item 9.1
- Combo Box and List Box: Synchronization
- Action Item 9.2
- Using Functions in Form Controls
- Summary
- Part V Create and Work With Reports
- Chapter 10 Designing and Using Reports
- Designing Reports
- The Report Tool
- The Report Design and a Blank Report
- The Report Wizard
- The Labels Wizard
- The Main Parts of a Report
- Modifying the Report
- Action Item 10.1
- Adding Page Breaks
- Using Expressions in the Group Header
- Understanding Circular References
- Summary
- Chapter 11 Report Customization
- Creating a Record Source for the Report
- Defining the Grouping Structure in a Report
- Working With the Report Header
- Preparing the Page Header
- Preparing the CourseName Header
- Preparing the SessionID Header
- Preparing the Detail Section
- Using an Immediate IF Function
- Preparing the CourseName Footer
- Preparing the Page Footer and Report Footer
- Adding Page Breaks
- Events in Access Reports
- Format Event (Section Formatting)
- Publishing the Report
- Action Item 11.1
- Creating a Report Selection Form
- The Option Group Control
- Macros: A Brief Introduction
- Summary
- Part VI Compact, Split and Secure the Database
- Chapter 12 Compacting, Splitting, and Securing an Access Database
- Compacting and Repairing Your Database
- Database Compact and Repair: Precautions
- Action Item 12.1
- Using the Compact on Close Option
- Backing Up and Restoring Your Database
- Using Access to Back Up a Database
- Restoring a Database From a Backup Copy
- Splitting Your Database
- Understanding Linked Tables
- Using the Linked Table Manager
- Reviewing the Back-End Database
- Securing an Access ACCDB Database
- Encrypting a Database With a Password
- Decrypting Database
- User-Level Security in Access Databases
- Migration Process: From Access to SQL Server
- Summary
- Appendix: Microsoft Access File Formats
- Index
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.