Description of Node A34 Asismeni Low Chart rd a new part into the database of any company, the purchasing and R&D teams (review this new part review is based on part information and specification, the review yields to an updated part information Next, the R&D team use part, technical and vendor information to confirm whether the part is a new part or not Once the new part confirmation is ápproved, the purchasing team requests a part number using part specification and the updated part information, which results in assigning part information and num information and number are needed, which yields to a final part information report. After the purchasing team registers the new part, this new part can be released, resulting in its part list. ber, otherwise the part is rejected. In order to register the new part, the updated part DBM &IIS Lab Manual By Dr. Nadjib Brahimi and Eng. Rasha Adnan
Understanding Access Databases
As you already know, a database is a collection of information. In Access, every database is stored in a single file. That file contains database objects, which are the components of a database.
Database objects are the main players in an Access database. Altogether, you have six different types of database objects:
- Tables store information. Tables are the heart of any database, and you can create as many tables as you need to store different types of information. A fitness database could track your daily running log, your inventory of exercise equipment, and the number of high-protein whey milkshakes you down each day, as three separate tables.
- Queries let you quickly perform an action on a table. Usually, this action involves retrieving a choice bit of information (like the 10 top-selling food items at Ed’s Roadside Diner or all the purchases you made in a single day). However, you can also use queries to apply changes.
- Forms are attractive windows that you create, arrange, and colorize. Forms provide an easy way to view or change the information in a table.
- Reports help you print some or all of the information in a table. You can choose where the information appears on the printed page, how it’s grouped and sorted, and how it’s formatted.
- Macros are mini-programs that automate custom tasks. Macros are a simple way to get custom results without becoming a programmer.
- Modules are files that contain Visual Basic code. You can use this code to do just about anything—from updating 10,000 records to firing off an email.
Access gurus refer to all these database ingredients as objects because you manage them all in essentially the same way. If you want to use a particular object, you add it to your database, give it a name, and then fine-tune it. Later on, you can view your objects, rename them, or delete ones you don’t want anymore.
Designing a database is the process of adding and configuring database objects. For those keeping score, an Access database can hold up to 32,768 separate objects.
In this chapter, you’ll consider only the most fundamental type of database object: tables. But first, you need to create a blank database you can work with.