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.
Author(s): Matt Vic
Publisher: Independently published
Year: 2022
Language: English
Pages: 169
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
