Overview of This Book
This unique book on Microsoft Access has been carefully written to ensure that readers can comprehend with ease all of the information contained in this book. In this book, you will learn all you need to know to make the best of Microsoft Access which also includes all necessary tips on VBA and macros.
Below is a sneak peek into what you will learn when you purchase this guide;
Chapter 1: Development of Databases
In this chapter, you will learn about the various vocabularies that are being used in Microsoft Access databases. In this section, you will learn about various databases, tables, records fields, and values and you will also learn about other relational databases. Objects in the Access Database which include tables, queries, display forms that include data entry, reports macros and VBA will also be discussed in detail in this chapter. Lately, you will learn about the various step design methods that should be embarked upon when making plans for database objects.
Chapter 2: Getting Started
Now you are ready to get started with the proper use of Microsoft Access. You will be introduced to the welcome screen, how to design an empty database, the interface which includes a panel for navigation, custom, object type tables and related views, data designed, tweaked date, and the ribbon and you will also learn about the toolbar for quick Access.
Chapter 3: Designing Access Tables
As you will get to understand later on when you are reading this book, the importance of tables in Microsoft Access, in this chapter, you will learn about the diverse types of tables used in Microsoft Access which include object tables, transaction tables, and join tables. You will also learn about the perfect way wherein you can design a New Table. This section includes learning about giving a field a name, knowing a type of data, giving a field description, and also getting to specify validation rules. This chapter will also introduce you to making use of the design tab where you will learn about the primary key, insert rows, delete rows, property sheet, indexes, and a host of others. You will also learn how to make a TBL customer as well as how best you can alter a table design which includes deleting a field you are no longer in use of and modifying the location of a field amongst others. Allocation of properties is another very important factor you will learn about in this chapter. Here you will learn about the common properties, format, custom numeric format, long and short text formats, input mask, and caption. Furthermore in this chapter, you will learn about indexing Access Tables which includes learning about the need for indexes, and multiple-field indexes, and you will also learn about when to index tables. Lastly in this chapter, you will learn about moving a table to a different database, adding records to a database table, having a perfect understanding of attachment fields, including an attachment field in the Datasheet view, and also including an attachment field in the design view.
Chapter 4: Knowing the Relationships between Tables
As earlier explained Access has a lot to do with tables, in this chapter, you will learn the various relationships that exist between tables. You will learn how to build bulletproof databases, and you will learn about the normalization and denormalization of data. Various table relationships will be discussed in detail in this chapter. Relationships like connecting data, one-to-one, one-to-many and so on will be discussed in this chapter. You will also learn about the various integrity rules, the creation of relationships, and the enforcing of referential integrity and you will also learn how you can get to view the relationships and how you can get to follow application-specific integrity rules.
Chapter 5: Working with Access Tables
So much about tables, yeah? In this chapter, you will learn about making effective use of Access Tables. You will learn about comprehending datasheets, looking at the datasheet window, moving in a datasheet, making use of the navigation buttons, and you will also learn about how best to check out the datasheet ribbon. Furthermore in this chapter, you will learn how to open a datasheet, insert new data, have a perfect understanding of how properties affect data entry, and gain an understanding of how properties affect data entry. In this chapter still, you will learn how to move between records to locate a particular value, getting values in the Datasheet. Making use of the undo feature, copying and pasting values, inclusion of new records, showing and deleting records, and altering display fonts are some of the other things you will be exposed to in this chapter. Arranging data in columns, saving the altered layout, filtering and organizing records in a datasheet, filtering a form, aggregating data, printing records, and previewing records are some of the other details you will get to learn in this chapter! Quite robust I must confess!
Chapter 6: Importing and Exporting Data
Data can be imported and exported. In this chapter, you will learn about the various ways in which Access works with external data. You will learn about the various types of external data, ways in which you can work with external data, when to import external data, and when to export it. You will also learn about the various options for importing and exporting which include importing from another Access database, importing from an Excel spreadsheet, importing data from text...
