Access 365 Project Book

Name: Access 365 Project Book | Hands-On Database Creation
Brand: Mercury Learning and Information
Price: 73.99 EUR
Availability: OnlineOnly

Hands-On Database Creation

Julitta Korol(Author)

Mercury Learning and Information (Publisher)

1st Edition

Published on 15. November 2023

450 pages

E-Book

ePUB with Adobe-DRM

System requirements

978-1-68392-095-3 (ISBN)

€73.99incl. 7% vat

System requirements

for ePUB with Adobe-DRM

E-Book Single Licence

Available for download

Description

More details

Other 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

Save as PDF Copy link into clipboard

Schweitzer Fachinformationen

Access 365 Project Book

Description

More details

Other editions

Additional editions

Person

Content

System requirements