𝔖 Scriptorium
✦   LIBER   ✦

πŸ“

Microsoft Access for Beginners & Advanced Users 2022

✍ Scribed by Matt Vic


Publisher
Independently published
Year
2022
Tongue
English
Leaves
169
Category
Library

⬇  Acquire This Volume

No coin nor oath required. For personal study only.

✦ Synopsis


Have you ever seen large arrays of data and doubted if you would ever find a software application for managing such large arrays of information? Are you working in a public or private organization and you are been given a task to manage the organization's database system that has extensive data? Or do you need a proven database software that you can use to manage business records effectively? These and many more questions are the reason for designing the Microsoft Access application for solving various database issues. Nevertheless, managing database information using Microsoft Access requires a level of specialty and technicality which means you will need a well-conducted and proven user guide that will help you to manage your database records effectively and conveniently which is what you’ve gotten when you grab a copy of this user guide, regardless if you are a newbie that does not know anything about Microsoft Access or if you’ve gathered little skill and experience on Microsoft Access.

This user guide excellently exposes you to in and out of Microsoft Access and endows you with the quality skills and knowledge requires for manipulating the Microsoft Access tool with little effort:

We will start by entering and storing data into the database records, getting you familiar with the navigation pane. We will forge ahead by constructing a database table using data types and field properties to effectively enter the data into the database table in such a way to avoid all forms of errors while entering the data.

Then we will establish the relationship that exists between the tables you have in the database table, we will also deal with finding, sorting, and querying the database table.

In conclusion, we will generate a report from the result we have gotten from the query and finally add the final touches to the report of the database to make it an exceptional report that you can present to top management.

✦ Table of Contents


CONTENTS
INTRODUCTION
CHAPTER ONE
GETTING STARTED WITH MICROSOFT ACCESS
INTRODUCING YOU TO ACCESS DATABASE
BASIC TERMINOLOGY TO BECOME PROFICIENT ON ACCESS DATABASE
LAUNCHING INTO MICROSOFT ACCESS APPLICATION
WORKING WITH ACCESS OPENING SCREEN
CREATING A DATABASE FILE
CREATING A BLANK DATABASE FILE
CREATING A DATABASE FILE FROM THE PREFORMATTED TEMPLATE
CHAPTER TWO
COMPOSITION OF DATABASE OBJECT
USING TABLES TO STORE DATABASE DATA
GENERATING FORMS TO ENTER AND MAINTAIN DATABASE DATA
SELECTING QUERIES TO EXTRACT DATABASE DATA
USING REPORTS FOR DATA PRESENTATION AND INSPECTION
MACRO
MODULE
WORKING WITH THE NAVIGATION PANE
OPEN/CLOSE AND RESIZE THE NAVIGATION PANE
SELECTING A PREDEFINED CATEGORY
FINDING AN OBJECT WITH THE PANE
SELECTING DATABASE OBJECT
SORT OBJECTS
CHAPTER THREE
CONSTRUCTING A DATABASE
ASCERTAINING KIND OF INFORMATION THAT IS NEEDED FOR YOUR DATABASE
DISTRIBUTING INFORMATION INTO THE DIFFERENT DATABASE TABLES
ASSIGNING FIELDS TO THE DATABASE TABLES
SELECTING A PRIMARY KEY FIELD FOR EACH DATABASE TABLE
ESTABLISHING RELATIONSHIPS AMONG THE DATABASE TABLES
CHAPTER FOUR
CONSTRUCTING DATABASE TABLES
CREATING A DATABASE TABLE
CREATING A DATABASE TABLE FROM THE SCRATCH
CREATE A DATABASE TABLE USING AN IN-BUILT TEMPLATE
IMPORTING A DATABASE TABLE FROM ANOTHER DATABASE TABLE
TWO WAYS OF OPENING A DATABASE TABLE
DETERMINING DATA TYPE
DATA TYPE FOR ENTERING FIELDS
ENTERING AND MODIFYING FIELDS OF A DATABASE TABLE
ENTERING A FIELD INTO A BLANK DATABASE FILE
ADJUSTING THE FIELDS FOR THE TABLE YOU CREATED WITH THE TEMPLATE
DO YOU KNOW WHAT THE PRIMARY KEY FIELD IS?
IMPORTANCE OF A PRIMARY KEY
LAW OF A PRIMARY KEY
CREATING A PRIMARY KEY
RENAMING AND DELETING A FIELDS
MOVING A FIELD
FIELD PROPERTIES A GUARANTEE FOR CORRECT DATA ENTRIES
EXAMINING EACH FIELD PROPERTIES SETTINGS
ACTIVATING LOOKUP WIZARD FOR DATA ENTRY LIST
INDEXING FOR FASTER QUERIES
WHEN TO INDEX AND WHICH FIELD IS TO BE INDEXED
CREATING AN INDEX
CREATING MULTIPLE-FIELD INDEX
BUILDING DATABASE TABLES RELATIONSHIP
CATEGORIES OF RELATIONSHIPS
MANAGING TABLES WITHIN THE RELATIONSHIP WINDOW
ESTABLISHING RELATIONSHIP BETWEEN TABLES
MODIFYING TABLE RELATIONSHIP
CHAPTER FIVE
ENTERING DATA INTO THE DATABASE TABLE
DATA ENTERING APPROACHES
DATA ENTERING BY SWITCHING TO DATASHEET VIEW
TIPS AND TRICKS EXPOSURE FOR ENTERING DATA IN A DATASHEET
AMENDING THE LOOK OF THE DATASHEET
ENTERING DATA WITH THE HELP OF A FORM
CHAPTER SIX
FINDING, SORTING, FILTERING, AND QUERYING YOUR DATA
FINDING MISSING DATA WITH THE FIND COMMAND
SORTING RECORDS ALPHABETICALLY AND NUMERICALLY
SORTING A DATABASE FIELD
FILTERING FOR SPECIFIC INFORMATION
METHODS OF FILTERING A DATABASE TABLE
IMPORTANT NOTE FOR USING ALL FILTER METHODS
FILTER BY FIELD CONTENT
FILTER BY SELECTION
FILTER BY FORM
ADVANCED FILTER/SORT
GETTING STARTED WITH A QUERY
CREATING A NEW QUERY
OPENING QUERIES AND SWITCHING VIEW
WORKING WITH THE QUERY DESIGN WINDOW
ADDING THE NEEDED TABLE TO THE QUERY DESIGN WINDOW
SELECTING THE FIELDS NEEDED IN THE QUERY
ARRANGING QUERY RESULTS WITH SORT
SELECTING THE FIELDS THAT WILL BE DISPLAYED IN THE QUERY RESULT
UNDERSTANDING QUERY CRITERIA
FORMAT FOR NUMERIC CRITERIA
FORMAT FOR TEXT CRITERIA
FORMAT FOR DATE CRITERIA
SAVING YOUR QUERY
RUNNING A QUERY
OTHER FORMS OF QUERIES
SELECT QUERY
CALCULATION QUERY
SUMMARY QUERY
CHAPTER SEVEN
PRESENTING DATABASE RESULTS IN THE FORM OF A REPORT
CREATING A PROFESSIONAL REPORT
OPENING AND INSPECTING A REPORT
REFINING THE APPEARANCE OF YOUR REPORT
CHAPTER EIGHT
APPROPRIATE SHORTCUTS, TIPS, AND TRICKS
DO AWAY WITH DATA MISMATCH
WRONG CRITERIA BRING WRONG OR NO QUERY RESULT
THERE SHOULD BE A LINK BETWEEN THE TABLES IN THE RELATIONSHIP
EACH TABLE SHOULD HAVE A PRIMARY KEY AND IT SHOULD BE A NUMERIC DATA TYPE
VALIDATING ACCESS DATA TYPE
SHORTCUTS AND CONTROL KEYS
SHORTCUTS FOR ENTERING DATA IN DATASHEET VIEW
GENERAL SHORTCUTS
GRID PANE SHORTCUTS
Conclusion
INDEX


πŸ“œ SIMILAR VOLUMES


MICROSOFT ACCESS & EXCEL FOR BEGINNERS &
✍ Demystified, Tech πŸ“‚ Library πŸ“… 2021 🌐 English

Data Analysis and Database Management made easy On daily basis, men are involved with data processing, manipulations and analysis, be it for academic purposes, businesses, training, etc. This book is all you need to easily learn Microsoft Access and Excel for data management as it provides a compre

Microsoft Word 2022 for Beginners & Pros
✍ Matt Vic πŸ“‚ Library πŸ“… 2022 πŸ› Independently published 🌐 English

Discover Complete Features and Functions of Microsoft Word with this Concise User Guide. The most recognized and widely used word processing application in the whole universe as of now is Microsoft Word. The driving force behind its popularity is multiple features that are embedded in it. However

Microsoft PowerPoint 2022 for Beginners
✍ Matt Vic πŸ“‚ Library πŸ“… 2022 πŸ› Independently published 🌐 English

Becoming proficient in PowerPoint 2022 to take your businesses and ideas to the next level using Microsoft Office PowerPoint. PowerPoint 2022 comes with an incredible interface that you can employ to effectively communicate your thoughts and ideas with your targeted audience and make an excellent

Microsoft Excel & Access For Beginners &
✍ Vic, Matt πŸ“‚ Library πŸ“… 2021 🌐 English

Are you passionate and eager to learn how to manage both small and large databases successfully but haven’t gathered enough knowledge or no knowledge? Maybe creating, managing, editing, and analyzing data is all you want? You are get covered with this complete user guide which takes you from basic t

Microsoft Excel & Access For Beginners &
✍ Vic, Matt πŸ“‚ Library πŸ“… 2021 🌐 English

Are you passionate and eager to learn how to manage both small and large databases successfully but haven’t gathered enough knowledge or no knowledge? Maybe creating, managing, editing, and analyzing data is all you want? You are get covered with this complete user guide which takes you from basic t

Word and Excel for Beginners 2021: A Com
✍ Matt Vic πŸ“‚ Library 🌐 English

<span>A Complete Beginners to Advanced User Guide for Microsoft Office Word and Excel 2021<br><br></span><span>This is a Complete two-in-one book for Microsoft Word and Excel 2021</span><span> for beginners, intermediate and advanced users that are ready to learn Word and Excel 2021 to the fullest.